queryviz
tables/relationship path
open in builder
T004
KTOPL
SKA1
SAKNR
SKB1
BUKRS → RBUKRS, SAKNR → RACCT
ACDOCA

ACDOCA

universal journal entry line items
fi54f · 6k · 10r
Unchanged in S/4
ACDOCA is the Universal Journal, new in S/4HANA. It replaces and merges BSEG, FAGLFLEXA, COEP, ANEP, and MLCD into a single table. All compatibility views (BSEG, FAGLFLEXA, etc.) read from ACDOCA. This is the single source of truth for all financial line items in S/4HANA.

fields (54)

fieldtypelengthkeydescription
BELNRchar10pkaccounting document number
DOCLNnumc6pkuniversal journal entry line item number
GJAHRnumc4pkfiscal year
RBUKRSchar4pkcompany code
RCLNTclnt3pkclient
RLDNRchar2pkledger in general ledger accounting
ANLN1char12main asset number
ANLN2char4asset subnumber
AUFNRchar12order number
AUGBLchar10clearing document number
AUGDTdats8clearing date
AWORGchar10reference organizational units
AWREFchar10reference document number
AWTYPchar5reference transaction
BLARTchar2document type
BLDATdats8document date in document
BUDATdats8posting date in the document
CPUDTdats8accounting document entry date
DRCRKchar1debit/credit indicator
HSLcurr23amount in local currency
KOARTchar1account type
KOKRSchar4controlling area
KSLcurr23amount in controlling area currency
KSTARchar10cost element
KTOSLchar3transaction key
KUNNRchar10customer number
LIFNRchar10vendor account number
LOESSION_KFchar10logical system of source document
MATNRchar40material number
MSLquan23quantity
OSLcurr23amount in second local currency
POPERnumc3posting period
PPRCTRchar10partner profit center
PRCTRchar10profit center
PS_PSP_PNRnumc8wbs element
PSEGMENTchar10partner segment
RACCTchar10account number (g/l account)
RASSCchar6trading partner (company id)
RBUSAchar4business area
RCNTRchar10cost center
RFAREAchar16functional area
RHCURcuky5local currency
RKCURcuky5controlling area currency
RRCTYchar2record type
RTCURcuky5transaction currency
RUNITunit3base unit of measure
RVERSchar3version
SEGMENTchar10segment for segmental reporting
SGTXTchar50item text
TSLcurr23amount in transaction currency
USNAMchar12user name
WERKSchar4plant
XBLNRchar16reference document number (header)
ZUESSIONchar18assignment number

relationships (10)

master lookup

reference to master data

references
LFA1
LIFNRLIFNR
N:1
MARA
MATNRMATNR
N:1
ACDOCP
RLDNRRLDNR
RBUKRSRBUKRS
GJAHRGJAHR
BELNRBELNR
DOCLNDOCLN
1:1
T001
RBUKRSBUKRS
N:1
SKB1
RBUKRSBUKRS
RACCTSAKNR
N:1
KNA1
KUNNRKUNNR
N:1
history

historical/audit records

referenced by
ACDOCP
RLDNRRLDNR
RBUKRSRBUKRS
GJAHRGJAHR
RACCTRACCT
RCNTRRCNTR
N:N
configuration

reference to config tables

references
T001W
WERKSWERKS
N:1
T003
BLARTBLART
N:1
header / item

parent-child document structure

references
BKPF
RBUKRSBUKRS
BELNRBELNR
GJAHRGJAHR
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms