VBKDPO SAP (SD Document: Business Item Data (item no. > 0)) Structure details
Description: SD Document: Business Item Data (item no. > 0)
Structure field list including key, data, relationships and ABAP select examples
VBKDPO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SD Document: Business Item Data (item no. > 0)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VBKDPO TYPE VBKDPO.
The VBKDPO table consists of various fields, each holding specific information or linking keys about SD Document: Business Item Data (item no. > 0) data available in SAP. These include MANDT (Client), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), KONDA (Price group (customer)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VBKDPO structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | BZIRK | BZI | ||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
PERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | TFACD | WFCID | |||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | FPLA | FPLNR | |||
WAKTION | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
ABSSC | Payment guarantee procedure | ABSSCHE_CM | CHAR | 6 | T691M | ABSSCHE_CM | |||
LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | AKKP | ALPHA | LCNUM | AKN | |
J_1AFITP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | J_1AFITP | |||
J_1ARFZ | Reason for zero VAT | J_1ARFZVAT | CHAR | 1 | J_1ARFZ | J_1ARFZVAT | |||
J_1AREGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
J_1AGICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD | J_1AGICD2 | |||
J_1ADTYP | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | J_1ADTYP | |||
J_1ATXREL | Tax relevant classification | J_1ATXREL_ | CHAR | 10 | J_1ATXREL | J_1ATXREL | |||
ABTNR | Department number | ABTNR | CHAR | 4 | TSAB | ABTNR | |||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | T176 | BSARK | |||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | BSTKD | ||||
BSTDK_E | Ship-to party's PO date | BSTDK_E | DATS | 8 | DATUM | ||||
BSARK_E | Ship-to party purchase order type | BSARK_E | CHAR | 4 | T176 | BSARK | |||
IHREZ_E | Ship-to party character | IHREZ_E | CHAR | 12 | TEXT12 | ||||
POSEX_E | Item Number of the Underlying Purchase Order | POSEX_E | CHAR | 6 | ALPHA | POSEX | |||
KURSK_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
KURRF_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | TVKGG | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | TVKGG | KDKGR | |||
WKWAE | Value contract currency | WKWAE | CUKY | 5 | TCURC | WAERS | |||
WKKUR | Exchange rate in value contract currency | WKKUR | DEC | 9(5) | KURRF | ||||
AKWAE | Currency key for letter-of-credit procg in foreign trade | AKWAE | CUKY | 5 | TCURC | WAERS | FWS | ||
AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9(5) | KURRF | ||||
AKPRZ | Depreciation percentage for financial document processing | AKPRZ | DEC | 5(2) | PRZ32 | ||||
J_1AINDXP | Inflation Index | J_1AINDXP | CHAR | 5 | J_1AINFT20 | J_1AINDXP | |||
J_1AIDATEP | Indexing base date | J_1AIDATES | DATS | 8 | J_1AUDATEP | ||||
BSTKD_M | Customer PO number as matchcode field | BSTKD_M | CHAR | 35 | CHAR35 | ||||
DELCO | Agreed delivery time | DELCO | CHAR | 3 | TVDC | DELCO | |||
FFPRF | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
FAKTF | Billing form | FAKTF | CHAR | 2 | FAKTF | ||||
RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | RR_RELTYP | ||||
ACDATV | Proposed start date for accrual period | RR_ACDATV | CHAR | 1 | RR_ACDATV | ||||
VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | VERSART | |||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | TVTY | TRATY | |||
TRMTYP | Means of Transport | TRMTYP | CHAR | 18 | MARA | MATN1 | MATNR | ||
SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | SDABW | |||
WMINR | Product catalog number | WMINR | CHAR | 10 | WWMI | WMINR | WMI | WPC1 | |
FKBER | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
PODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | XFELD | ||||
CAMPAIGN | Generic project planning: GUID from external R/3 system | CGPL_GUID16_R3 | RAW | 16 | SYSUUID | ||||
VKONT | Contract Account Number | CORR_VKONT_KK | CHAR | 12 | ALPHA | CORR_VKONT_KK | |||
DPBP_REF_FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | Assigned to domain | FPLNR | |||
DPBP_REF_FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | Assigned to domain | FPLTR | |||
REVSP | Revenue Distribution Type | RR_REVSP | CHAR | 1 | RR_REVSP | ||||
REVEVTYP | Revenue Event Type (Customizing) | RR_REVEVTYP_CUST | CHAR | 1 | RR_REVEVTYP_CUST | ||||
VTREF | Reference Specifications from Contract | CORR_VTREF_KK | CHAR | 20 | ALPHA | CORR_VTREF_KK | |||
.INCLU--AP | 0 | ||||||||
BOOKING_FR | Booking Date- From | /SAPHT/DRM_BOOK_FROM | DATS | 8 | DATS | ||||
BOOKING_TO | Booking Date - To | /SAPHT/DRM_BOOK_TO | DATS | 8 | DATS | ||||
SHIPPING_FR | Shipping Date - From | /SAPHT/DRM_SHIP_FROM | DATS | 8 | DATS | ||||
SHIPPING_TO | Shipping Date - To | /SAPHT/DRM_SHIP_TO | DATS | 8 | DATS | ||||
BILLING_FR | Billing Date - From | /SAPHT/DRM_BILL_FROM | DATS | 8 | DATS | ||||
BILLING_TO | Billing Date - To | /SAPHT/DRM_BILL_TO | DATS | 8 | DATS | ||||
EXERCISE_FR | Exercise Date -To | /SAPHT/DRM_EXER_FROM | DATS | 8 | DATS | ||||
EXERCISE_TO | Exercise Date - From | /SAPHT/DRM_EXER_TO | DATS | 8 | DATS | ||||
DESIGN_REG_NO | Design registration number | /SAPHT/DRM_DESIGN_REG_NO | CHAR | 30 | CHAR30 | ||||
DROP_SHIP | Dropship indicator | /SAPHT/DRM_DS_IND | CHAR | 1 | /SAPHT/DRM_DS_IND | ||||
.INCLU--AP | 0 | ||||||||
RFPLN | Standard Billing/Invoicing Plan Number | RFPLN_D | CHAR | 10 | FPLA | FPLNR | |||
SYNCH | Automatic Synchronization of Billing Plan | SYNCH | CHAR | 1 | SYNCH | ||||
.INCLU--AP | 0 | ||||||||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
.INCLU--AP | 0 | ||||||||
PEROP_BEG | Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8 | DATUM | ||||
PEROP_END | Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
STCODE | LST CST applicability code | J_1ISTCODE | CHAR | 3 | Assigned to domain | J_1ISTCODE | |||
FORMC1 | Form Type | J_1IFORTYP | CHAR | 3 | Assigned to domain | J_1IFORTYP | |||
FORMC2 | Form Type | J_1IFORTYP | CHAR | 3 | Assigned to domain | J_1IFORTYP | |||
STEUC | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | Assigned to domain | STEUC | |||
.INCLU--AP | 0 | ||||||||
COMPREAS | Abbreviation for Complaints Reason | CMP_COMPREAS_COPY | CHAR | 4 | CMP_COMPREAS_COPY | ||||
.INCLU--AP | 0 | ||||||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
PAY_TYPE | SEPA: Transaction Type | SEPA_PAY_TYPE | CHAR | 1 | SEPA_PAY_TYPE | ||||
SEPON | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG | ||||
MNDVG | SEPA-Relevance | SD_SEPA_FLAG | CHAR | 1 | SD_SEPA_FLAG |
Key field | Non-key field |
How do I retrieve data from SAP structure VBKDPO using ABAP code?
As VBKDPO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VBKDPO as there is no data to select.How to access SAP table VBKDPO
Within an ECC or HANA version of SAP you can also view further information about VBKDPO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects