vb_debi_ddl

View of KNA1, KNB1 and BSID | view: VB_DEBI | Extraction: Not supported | Component: Information System
Tables used: BKPFBSEGKNA1KNB1
Column Name Description
Column Name Description
dmbtr Amount in local currency
wrbtr Amount in document currency
skfbt Amount Eligible for Cash Discount in Document Currency
sknto Cash Discount Amount in Local Currency
wskto Cash Discount Amount in Document Currency
Column Name Description
Column Name Description
augdt Clearing Date
budat Posting Date in the Document
bldat Document Date in Document
zfbdt Baseline Date for Due Date Calculation
madat Date of Last Dunning Notice
Column Name Description
xcpdk Indicator: Is the account a one-time account? Show values
shkzg Debit/Credit Indicator Show values
xcpdd Indicator: Address and Bank Data Set Individually Show values
bstat Document Status Show values
xarch Indicator: Document Already Archived? Show values
Column Name Description Domain name
kunnr Customer Number KUNNR
bukrs Company Code BUKRS
umsks Special G/L Transaction Type UMSKS
umskz Special G/L Indicator UMSKZ
augbl Document Number of the Clearing Document BELNR
zuonr Assignment number ZUONR
gjahr Fiscal Year GJAHR
belnr Document Number of an Accounting Document BELNR
buzei Number of Line Item Within Accounting Document BUZEI
anred Title TEXT15
begru Authorization Group BRGRU
konzs Group key KONZS
adrnr Address ADRNR
name1 Name 1 NAME
name2 Name 2 NAME
name3 Name 3 NAME
name4 Name 4 NAME
ort01 City TEXT35
ort02 District TEXT35
pfort PO Box city TEXT35
pfach PO Box PFACH
pstl2 P.O. Box Postal Code PSTLZ
pstlz Postal Code PSTLZ
sortl Sort field CHAR10
stras Street and House Number TEXT35
begru_b Authorization Group BRGRU
zterm Terms of payment key ZTERM
xblnr Reference Document Number XBLNR1
blart Document Type BLART
monat Fiscal period MONAT
bschl Posting Key BSCHL
gsber Business Area GSBER
mwskz Tax on sales/purchases code MWSKZ
sgtxt Item Text TEXT50
saknr G/L Account Number SAKNR
hkont General Ledger Account SAKNR
zterm_b Terms of payment key ZTERM
zbd1t Cash discount days 1 ZBDXT
zbd2t Cash discount days 2 ZBDXT
zbd3t Net Payment Terms Period ZBDXT
zbd1p Cash discount percentage 1 PRZ23
zbd2p Cash Discount Percentage 2 PRZ23
zlsch Payment Method ZLSCH
zlspr Payment Block Key ZAHLS
rebzg Document No. of the Invoice to Which the Transaction Belongs BELNR
mansp Dunning Block MANSP
mschl Dunning Key MSCHL
manst Dunning Level MAHNS
cession_kz Accounts Receivable Pledging Indicator CESSION_KZ
Master Data Relations Join Conditions
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • VB_DEBI_DDL.BUKRS == SKB1.BUKRS
  • VB_DEBI_DDL.MANDT == SKB1.MANDT
  • VB_DEBI_DDL.AKONT == SKB1.SAKNR
Industry key
  • Industry key
  • Client
  • VB_DEBI_DDL.BRSCH == T016.BRSCH
  • VB_DEBI_DDL.MANDT == T016.MANDT
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Company Code
  • Client
  • VB_DEBI_DDL.BUSAB == T001S.BUSAB
  • VB_DEBI_DDL.BUKRS == T001S.BUKRS
  • VB_DEBI_DDL.MANDT == T001S.MANDT
City Code
  • Region (State, Province, County)
  • City Code
  • Country/Region Key
  • Client
  • VB_DEBI_DDL.REGIO == T005G.REGIO
  • VB_DEBI_DDL.CITYC == T005G.CITYC
  • VB_DEBI_DDL.LAND1 == T005G.LAND1
  • VB_DEBI_DDL.MANDT == T005G.MANDT
County Code
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • County Code
  • VB_DEBI_DDL.REGIO == T005E.REGIO
  • VB_DEBI_DDL.LAND1 == T005E.LAND1
  • VB_DEBI_DDL.MANDT == T005E.MANDT
  • VB_DEBI_DDL.COUNC == T005E.COUNC
Country/Region Key
  • Country/Region Key
  • Client
  • VB_DEBI_DDL.LAND1 == T005.LAND1
  • VB_DEBI_DDL.MANDT == T005.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • VB_DEBI_DDL.MANDT == LFA1.MANDT
  • VB_DEBI_DDL.LIFNR == LFA1.LIFNR
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • VB_DEBI_DDL.REGIO == T005S.BLAND
  • VB_DEBI_DDL.LAND1 == T005S.LAND1
  • VB_DEBI_DDL.MANDT == T005S.MANDT
Language Key VB_DEBI_DDL.SPRAS == T002.SPRAS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • VB_DEBI_DDL.MANDT == T880.MANDT
  • VB_DEBI_DDL.VBUND == T880.RCOMP
Key for sorting according to assignment numbers VB_DEBI_DDL.ZUAWA == TZUN.ZUAWA