queryviz
tables/relationship path
open in builder
T004
KTOPL
T001
BUKRS
BSID

BSID

accounting: secondary index for customers (open items)
fi29f · 11k · 7r
Replaced by ACDOCA
Customer open items secondary index replaced by CDS views on ACDOCA. Use account type filter (KOART = D) instead of a dedicated table.
key differences:
  • •No separate open/cleared split — use clearing date (AUGDT) to determine status
  • •CDS view I_OperationalAcctgDocItem replaces direct table access
  • •Customer line items filtered by account type (KOART = D) in ACDOCA

fields (29)

fieldtypelengthkeydescription
AUGBLchar10pkclearing document number
AUGDTdats8pkclearing date
BELNRchar10pkaccounting document number
BUKRSchar4pkcompany code
BUZEInumc3pknumber of line item within accounting document
GJAHRnumc4pkfiscal year
KUNNRchar10pkcustomer number
MANDTclnt3pkclient
UMSKSchar1pkspecial g/l transaction type
UMSKZchar1pkspecial g/l indicator
ZUONRchar18pkassignment number
BLARTchar2document type
BSCHLchar2posting key
BUDATdats8posting date in the document
DMBE2curr13amount in second local currency
DMBTRcurr13amount in local currency
HKONTchar10general ledger account
MONATnumc2fiscal period
MWSKZchar2tax on sales/purchases code
PRCTRchar10profit center
REBZGchar10document number of the invoice to which the transaction belongs
SGTXTchar50item text
SHKZGchar1debit/credit indicator
WAERScuky5currency key
WRBTRcurr13amount in document currency
XBLNRchar16reference document number
ZBD1Tdec3cash discount days 1
ZFBDTdats8baseline date for due date calculation
ZTERMchar4terms of payment key

relationships (7)

configuration

reference to config tables

references
T052
ZTERMZTERM
N:1
TBSL
BSCHLBSCHL
N:1
T003
BLARTBLART
N:1
TCURC
WAERSWAERS
N:1
T001
BUKRSBUKRS
N:1
master lookup

reference to master data

references
KNA1
KUNNRKUNNR
N:1
referenced by
KNB1
KUNNRKUNNR
BUKRSBUKRS
1:N
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms