queryviz
tables/relationship path
open in builder
TVKO
BUKRS
T001
BUKRS
LFB1
LIFNR, BUKRS
BSIK

BSIK

accounting: secondary index for vendors (open items)
fi30f · 11k · 7r
Replaced by ACDOCA
Vendor open items secondary index replaced by CDS views on ACDOCA. Use I_JournalEntryItem or custom CDS views filtering on vendor account type.
key differences:
  • •No separate open/cleared split — use clearing date (AUGDT) to determine status
  • •CDS view I_OperationalAcctgDocItem replaces direct table access
  • •Vendor line items filtered by account type (KOART = K) in ACDOCA

fields (30)

fieldtypelengthkeydescription
AUGBLchar10pkclearing document number
AUGDTdats8pkclearing date
BELNRchar10pkaccounting document number
BUKRSchar4pkcompany code
BUZEInumc3pknumber of line item within accounting document
GJAHRnumc4pkfiscal year
LIFNRchar10pkaccount number of vendor or creditor
MANDTclnt3pkclient
UMSKSchar1pkspecial g/l transaction type
UMSKZchar1pkspecial g/l indicator
ZUONRchar18pkassignment number
BLARTchar2document type
BLDATdats8document date in document
BSCHLchar2posting key
BUDATdats8posting date in the document
DMBTRcurr13amount in local currency
HKONTchar10general ledger account
MONATnumc2fiscal period
MWSKZchar2tax on sales/purchases code
PRCTRchar10profit center
SGTXTchar50item text
SHKZGchar1debit/credit indicator
WAERScuky5currency key
WRBTRcurr13amount in document currency
XBLNRchar16reference document number
ZBD1Tdec3cash discount days 1
ZFBDTdats8baseline date for due date calculation
ZLSCHchar1payment method
ZLSPRchar1payment block key
ZTERMchar4terms of payment key

relationships (7)

configuration

reference to config tables

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

reference to master data

references
LFA1
LIFNRLIFNR
N:1
referenced by
LFB1
LIFNRLIFNR
BUKRSBUKRS
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms