[Link]
com/2020/08/03/what-a-universal-journal-table-acdoca-covers-and-
what-not/
--COBK, COEP
CO Header and Item Tables
--FINSTS_ACDOC_FCT
It contains a list of fieldnames of table ACDOCA and a column "BSEG_FIELD".
So this is basically the mapping of fieldnames between ACDOCA and BSEG.
--POPER
The year-end carry-forward figures are stored as period 000 in ACDOCA
ACDOCA contains carry forward figures in period 000 in the table, and thus
when calculating YTD (year-to-date) figures, you do not need to go back to previous
years
and can total 000 period related figures with other periods needed.
--FBL*N
--FAGLL03
--FAGLL03H
This transaction interrogates the ACDOCA table in addition to many other tables
such as BKPF, BSEG, SKA1, SKB1, KNA1, LFA1 etc.
This makes this transaction a central hub for all your universal journal querying.
ACDOCA table replaces COEP, COBK, ANEK, ANEP, ANEA and a few other tables.
As a result of this simplification, the table covers fields in GL accounting, asset
accounting,
profitability analysis and the material ledger.
--Understanding SAP movement types
There is some methodology behind numbering of movement types. The prefix of each
movement type denotes the type of movement it is. These prefixes can be grouped
together as below:
1xx Goods Receipt from purchasing/production + returns
2xx Goods Issue for consumption
3xx Transfers
4xx Transfers for Special Stock
5xx Goods Receipt without reference to PO or PP order
6xx Logistics Execution -Shipment movement types
70x Physical inventory (Inventory managed)
71x Physical inventory (Warehouse managed)
8xx Brazilian Movements and Industry solutions
9xx, Xxx, Yxx, Zxx Customer ranges
--With the Universal Journal, the ‘old’ CO-PA tables are outdated.
-----------------------------------------------------------------------------------
------------------
Tables Costing
based Account based SAP S/4HANA
-----------------------------------------------------------------------------------
------------------
Actual line items CE1XXXX
COEJ ACDOCA
Plan line items CE2XXXX
COEP ACDOCP
Totals records per profitability segment CE3XXXX COSS,
COSP ACDOCA
Profitability Segment definition CE4XXXX
CE4XXXX CE4XXXX
--BSTAT ( Posted Document Type ) Domain Value Help
Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward and Balance Adjustments from Migration
U Posting in General Ledger Only
O Financial Statements: Open Entry
T Posting in Simulation Extension Ledger
P Predicted Document
J Closing Operations (postings are not made to record type 0)
SELECT DISTINCT "BSTAT"
FROM "ACDOCA"
WHERE "RCLNT" = '100'
--RLDNR CHAR2 Ledger in General Ledger Accounting ( Text FINS_LEDGER_T )
--BELNR CHAR10 Accounting Document Number ( Just Number without Value Help or
Text )
--DOCLN CHAR6 Six-Character Posting Item for Ledger( Just Number without Value
Help or Text )
SELECT "RLDNR", "BELNR", "DOCLN", "RBUKRS", "GJAHR", "POPER", "PERIV", "KSL",
"HSL", "WSL"
FROM "ACDOCA"
WHERE "RCLNT" = '100'
AND "POPER" = '000'
AND "RBUKRS" = '6200'
AND "GJAHR" = '2021'
SELECT "RLDNR", "BELNR", "DOCLN", "RBUKRS", "GJAHR", "POPER", "PERIV", "KSL",
"HSL", "WSL"
FROM "ACDOCA"
WHERE "RCLNT" = '100'
AND "POPER" = '000'
AND "RBUKRS" = '6200'
AND "GJAHR" = '2021'
AND "AWTYP" = 'AMBU' --Asset Transaction
--AND "AWTYP" IN ( 'AMBU', 'ANLA' ) --Asset Transaction
AND "AWTYP" IN ( 'TRAVL', 'AXBTA' ) --Travel Expenses Text Table TTYP
select distinct rclnt, rbukrs, awtyp
from acdoca
select distinct rclnt, rbukrs, awtyp
from acdoca
where awtyp in ('AMBU', 'ANLA', 'TRAVL', 'AXBTA')
SELECT "RLDNR", COUNT(*)
FROM "ACDOCA"
WHERE "RCLNT" = '100'
GROUP BY "RLDNR" --0L
ORDER BY 2 DESC
SELECT "RBUKRS", COUNT(*)
FROM "ACDOCA"
WHERE "RCLNT" = '100'
GROUP BY "RBUKRS"
ORDER BY 2 DESC
SELECT "GJAHR", COUNT(*)
FROM "ACDOCA"
WHERE "RCLNT" = '100'
GROUP BY "GJAHR"
ORDER BY 2 DESC
SELECT "RBUKRS", "GJAHR", "POPER", COUNT(*)
FROM "ACDOCA"
WHERE "RCLNT" = '100' AND "RBUKRS" = '6200' --AND "POPER" = '000'
GROUP BY "RBUKRS", "GJAHR", "POPER"
ORDER BY 2, 3, 4 DESC
SELECT *
FROM "VBAK"
WHERE "MANDT" = '100'
AND "VKORG" = '6200'
SELECT "VBELN", "BELNR"
FROM "VBRK"
WHERE "MANDT" = '100'
AND "BUKRS" = '6200'
SELECT "BELNR", "ZUONR" AS "INV_NUM"
FROM "BSEG"
WHERE "MANDT" = '100'
AND "BUKRS" = '6200'
AND "ZUONR" = '0090000057'
--Ref. Procedures
SELECT distinct "AWTYP"
FROM "BKPF"
WHERE "MANDT" = '100'
SELECT "AWKEY" --VBRK-VBELN
FROM "BKPF"
WHERE "MANDT" = '100'
AND "AWTYP" = 'VBRK'
--Link Between Billing Document And Accounting Document
[Link]
number/
BKPF-AWTYP = 'VBRK'
BKPF-AWKEY = VBRK-VBELN
BKPF stores the header lines for accounting documents.
Accounting documents make up the financials of your organisation.
Line items are stored in table BSEG.
The link between BSEG and BKPF is made on fields MANDT, BUKRS, GJAHR, BELNR.
The same document number can be used in different company codes.
The same document number can also be used multiple times within the same company
code in different years.
A cash memo is a document that records cash sales and purchases.
if a business orders a batch of materials from a supplier and notice that
some of the materials are defective, they can return those materials along
with a debit note that lists the cost of those materials for the supplier to refund
to the business.
When a customer returns a product, the business can send them a credit note for the
amount they paid
as a refund for their purchase. Credit notes are most frequently used by
businesses.