VBKD

Sales Document: Business Data | #transactional | Component: Sales
Column Name Description
MANDT FK Client
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
Column Name Description
Column Name Description
VALDT Fixed Value Date
PRSDT Date for Pricing and Exchange Rate
FKDAT Billing Date
FBUDA Date on which services are rendered
BSTDK Customer Reference Date
BSTDK_E Ship-to Party's Customer Reference Date
KURSK_DAT Translation date
KURRF_DAT Translation date
J_1AIDATEP Indexing base date
_DATAAGING Data Filter Value for Data Aging
PEROP_BEG Period of Performance Start Date
PEROP_END Period of Performance End Date
Column Name Description
KZAZU Order Combination Indicator Show values
MRNKZ Manual Invoice Maintenance Show values
FAKTF Billing form Show values
RRREL Revenue recognition category Show values
ACDATV Proposed start date for accrual period Show values
PODKZ Relevant for POD processing Show values
REVSP Revenue Distribution Type Show values
REVEVTYP Revenue Event Type (Customizing) Show values
FARR_RELTYPE Revenue Accounting Type Show values
PAY_TYPE SEPA: Payment Type Show values
SEPON SEPA-Relevance Show values
MNDVG SEPA-Relevance Show values
Column Name Description Domain name
INCO2 Incoterms (Part 2) INCO2
KURRF Exchange Rate for Postings to Financial Accounting KURRF
VALTG Additional Value Days TAGE2
ZTERM Terms of payment key ZTERM
KURSK Exchange Rate for Price Determination KURRF
GJAHR Fiscal Year GJAHR
POPER Posting period POPER
STCUR Exchange rate for statistics KURRF
LCNUM Financial doc. processing: Internal financial doc. number LCNUM
EMPST Receiving Point TEXT25
BSTKD Customer Reference BSTKD
IHREZ Your Reference TEXT12
BSTKD_E Ship-to Party's Customer Reference BSTKD
IHREZ_E Ship-to Party Character TEXT12
POSEX_E Item Number of the Underlying Purchase Order POSEX
WKKUR Exchange rate in value contract currency KURRF
AKKUR Exchange rate for letter-of-credit procg in foreign trade KURRF
AKPRZ Depreciation percentage for financial document processing PRZ32
BSTKD_M Customer Reference as Matchcode Field CHAR35
CAMPAIGN Generic project planning: GUID from external R/3 system SYSUUID
VKONT Contract Account Number CORR_VKONT_KK
DPBP_REF_FPLNR Billing plan number / invoicing plan number FPLNR
DPBP_REF_FPLTR Item for billing plan/invoice plan/payment cards FPLTR
VTREF Reference Specifications from Contract CORR_VTREF_KK
J_1TPBUPL Branch Code BCODE
INCO2_L Incoterms Location 1 INCO_L
INCO3_L Incoterms Location 2 INCO_L
INCO2_KEY Incoterm Location 1 - Place of Destination /SCMTMS/LOCUUID
INCO3_KEY Incoterm Location 2 - Place of Delivery /SCMTMS/LOCUUID
INCO4_KEY Incoterm - Deviating Place of Destination /SCMTMS/LOCUUID
STCODE LST CST applicability code J_1ISTCODE
FORMC1 Form Type J_1IFORTYP
FORMC2 Form Type J_1IFORTYP
STEUC Control code for consumption taxes in foreign trade STEUC
COMPREAS Abbreviation for Complaints Reason CMP_COMPREAS_COPY
MNDID Unique Reference to Mandate for each Payee ID035
Master Data Relations Join Conditions
Foreign Key Check: Payment Guarantee Procedure
  • VBKD.MANDT == T691M.MANDT
  • VBKD.ABSSC == T691M.ABSSC
Department number
  • Department number
  • Client
  • VBKD.ABTNR == TSAB.ABTNR
  • VBKD.MANDT == TSAB.MANDT
Check: Letter of credit currency
  • VBKD.MANDT == TCURC.MANDT
  • VBKD.AKWAE == TCURC.WAERS
Accounting Indicator
  • VBKD.MANDT == TBMOT.MANDT
  • VBKD.BEMOT == TBMOT.BEMOT
Customer Purchase Order Type
  • VBKD.MANDT == T176.MANDT
  • VBKD.BSARK == T176.BSARK
Ship-to Party Purchase Order Type
  • VBKD.MANDT == T176.MANDT
  • VBKD.BSARK_E == T176.BSARK
Sales District
  • VBKD.MANDT == T171.MANDT
  • VBKD.BZIRK == T171.BZIRK
Agreed Delivery Time
  • VBKD.MANDT == TVDC.MANDT
  • VBKD.DELCO == TVDC.DELCO
Functional Area
  • VBKD.MANDT == TFKB.MANDT
  • VBKD.FKBER == TFKB.FKBER
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • VBKD.INCO1 == TINC.INCO1
  • VBKD.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • VBKD.INCOV == TINCV.INCOV
  • VBKD.MANDT == TINCV.MANDT
Foreign key for J_1ADTYP
  • ?
  • Distribution Type for Employment Tax
Foreign key for tax type
  • Tax type
  • Client
  • ?
Foreign key for J_1AGICD
  • Activity Code for Gross Income Tax
  • ?
Inflation Index
Foreign key for tax region
  • ?
  • Region (State, Province, County)
  • VBKD.MANDT == T005S.MANDT
  • VBKD.[column in domain "LAND1"] == T005S.LAND1
  • VBKD.J_1AREGIO == T005S.BLAND
Foreign key for tax exemption reason
Foreign key for classification of tax relevance
Customer Group
  • Customer Group
  • Client
  • VBKD.KDGRP == T151.KDGRP
  • VBKD.MANDT == T151.MANDT
Customer condition group 1
  • Customer condition group 1
  • Client
  • VBKD.KDKG1 == TVKGG.KDKGR
  • VBKD.MANDT == TVKGG.MANDT
Customer condition group 2
  • Customer condition group 2
  • Client
  • VBKD.KDKG2 == TVKGG.KDKGR
  • VBKD.MANDT == TVKGG.MANDT
Customer condition group 3
  • Customer condition group 3
  • Client
  • VBKD.KDKG3 == TVKGG.KDKGR
  • VBKD.MANDT == TVKGG.MANDT
Customer condition group 4
  • Customer condition group 4
  • Client
  • VBKD.KDKG4 == TVKGG.KDKGR
  • VBKD.MANDT == TVKGG.MANDT
Customer condition group 5
  • Customer condition group 5
  • Client
  • VBKD.KDKG5 == TVKGG.KDKGR
  • VBKD.MANDT == TVKGG.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • VBKD.KONDA == T188.KONDA
  • VBKD.MANDT == T188.MANDT
Account Assignment Group for this Customer
  • VBKD.MANDT == TVKT.MANDT
  • VBKD.KTGRD == TVKT.KTGRD
Client VBKD.MANDT == T000.MANDT
Dunning Block
  • VBKD.MANDT == T040S.MANDT
  • VBKD.MANSP == T040S.MANSP
Dunning Key
  • VBKD.MANDT == T040.MANDT
  • VBKD.MSCHL == T040.MSCHL
Package number
  • VBKD.MANDT == ESLH.MANDT
  • VBKD.PACKNO == ESLH.PACKNO
Invoice Dates (Calendar Identification) VBKD.PERFK == TFACD.IDENT
Invoice List Schedule (calendar identification) VBKD.PERRL == TFACD.IDENT
Price List Type
  • VBKD.MANDT == T189.MANDT
  • VBKD.PLTYP == T189.PLTYP
Special Processing Indicator
  • VBKD.MANDT == TVSAK.MANDT
  • VBKD.SDABW == TVSAK.SDABW
Means-of-Transport Type
  • VBKD.MANDT == TVTY.MANDT
  • VBKD.TRATY == TVTY.TRATY
Means of Transport
  • Means of Transport
  • Client
  • VBKD.TRMTYP == MARA.MATNR
  • VBKD.MANDT == MARA.MANDT
Shipping Type
  • Shipping Type
  • Client
  • VBKD.VSART == T173.VSART
  • VBKD.MANDT == T173.MANDT
Retail promotion
  • Promotion
  • Client
  • VBKD.WAKTION == WAKH.AKTNR
  • VBKD.MANDT == WAKH.MANDT
Value contract currency
  • VBKD.MANDT == TCURC.MANDT
  • VBKD.WKWAE == TCURC.WAERS
Product Catalog
  • Product catalog number
  • Client
  • VBKD.WMINR == WWMI.WMINR
  • VBKD.MANDT == WWMI.MANDT
Payment Method
  • Payment Method
  • ?
  • VBKD.MANDT == T042Z.MANDT
  • VBKD.ZLSCH == T042Z.ZLSCH
  • VBKD.[column in domain "LAND1"] == T042Z.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
DI profile
  • ?
  • Client
  • Dynamic Item Processor Profile