1. Home
  2. Resources
  3. SAP Tables
  4. VBAPKOM - Communication Fields for Maintaining SD Document Items

SAP Table VBAPKOM

Communication Fields for Maintaining SD Document Items

VBAPKOM (Communication Fields for Maintaining SD Document Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBAPKOM to other SAP tables.

Source: VBAPKOM (Communication Fields for Maintaining SD Document Items)

VBAPKOM table fields

Field Data element Checktable Datatype Length Decimals
POSNR Sales Document Item POSNR_VA NUMC 6 0
MATNR Material Number MATNR CHAR 18 0
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
GRPOS Item for which this item is an alternative GRPOS NUMC 6 0
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
FAKSP Block FAKSP CHAR 2 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
KDMAT Material belonging to the customer KDMAT CHAR 35 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
ZMENG Target quantity in sales units DZMENG QUAN 13 3
ZIEME Target quantity UoM DZIEME UNIT 3 0
VRKME Sales unit VRKME UNIT 3 0
PSTYV Sales document item category PSTYV CHAR 4 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
KSCHL1 Condition type KSCHA CHAR 4 0
KBETR1 Rate (condition amount or percentage) KBETR CURR 11 2
KWAER1 Currency Key WAERS CUKY 5 0
KPEIN1 Condition pricing unit KPEIN DEC 5 0
KMEIN1 Condition unit in the document KVMEI UNIT 3 0
KSCHL2 Condition type KSCHA CHAR 4 0
KBETR2 Rate (condition amount or percentage) KBETR CURR 11 2
KWAER2 Currency Key WAERS CUKY 5 0
KPEIN2 Condition pricing unit KPEIN DEC 5 0
KMEIN2 Condition unit in the document KVMEI UNIT 3 0
KSCHL3 Condition type KSCHA CHAR 4 0
KBETR3 Rate (condition amount or percentage) KBETR CURR 11 2
KWAER3 Currency Key WAERS CUKY 5 0
KPEIN3 Condition pricing unit KPEIN DEC 5 0
KMEIN3 Condition unit in the document KVMEI UNIT 3 0
KSCHL4 Condition type KSCHA CHAR 4 0
KBETR4 Rate (condition amount or percentage) KBETR CURR 11 2
KWAER4 Currency Key WAERS CUKY 5 0
KPEIN4 Condition pricing unit KPEIN DEC 5 0
KMEIN4 Condition unit in the document KVMEI UNIT 3 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VGTYP Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
SHKZG Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
AUFNR Order Number AUFNR CHAR 12 0
VBELV Originating document VBELV CHAR 10 0
POSNV Originating item POSNV NUMC 6 0
VLAUFZ Validity period of contract VLAUF_VEDA NUMC 3 0
VLAUEZ Unit of validity period of contract VLAUE_VEDA CHAR 1 0
1 Day
2 Week
3 Month
4 Year
VLAUFK Validity period category of contract VLAUK_VEDA CHAR 2 0
VINSDAT Installation date VIDAT_VEDA DATS 8 0
VABNDAT Agreement acceptance date VADAT_VEDA DATS 8 0
VBEGDAT Contract start date VBDAT_VEDA DATS 8 0
VUNTDAT Date on which contract is signed VUDAT_VEDA DATS 8 0
VKUESCH Assignment cancellation procedure/cancellation rule VKUES_VEDA CHAR 4 0
VAKTSCH Action at end of contract VASCH_VEDA CHAR 4 0
VEINDAT Date on which cancellation request was received VEDAT_VEDA DATS 8 0
VWUNDAT Requested cancellation date VWDAT_VEDA DATS 8 0
VKUEPAR Cancellation party VKPAR_VEDA CHAR 1 0
A Oneself
B Contract partner
VKUEGRU Reason for Cancellation of Contract VKGRU_VEDA CHAR 2 0
VENDDAT Contract end date VNDAT_VEDA DATS 8 0
VBELKUE Cancellation document number of contract partner VBELK_VEDA CHAR 20 0
VBEDKUE Date of cancellation document from contract partner VBEDK_VEDA DATS 8 0
VBEGREG Rule for calculating contract start date VBREG_VEDA CHAR 2 0
VVORZEIT Lead time for cancellation prevention activities VZEIT_VEDA NUMC 3 0
VVOREIN Time unit of lead time VZEIE_VEDA CHAR 1 0
1 Day
2 Week
3 Month
4 Year
VDEMDAT Dismantling date VDDAT_VEDA DATS 8 0
VENDREG Rule for contract end date RGVTE CHAR 2 0
VASDA Date for action VASDA DATS 8 0
VASDR Date rule for action VASDR CHAR 2 0
DUMMY_VEDA Dummy function in length 1 DUMMY CHAR 1 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
/XLSO/COURSE_ID Product ID /XLSO/E_PRODUCT_ID NUMC 8 0
/XLSO/COURSE_BDA Start Date BEGDA DATS 8 0
/XLSO/COURSE_EDA End Date ENDDA DATS 8 0
PERNR_D Personnel Number PERNR_D NUMC 8 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
CHARG Batch Number CHARG_D CHAR 10 0
PRODH Product hierarchy PRODH_D CHAR 18 0
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
MATKL Material Group MATKL CHAR 9 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
WGRU1 Material group hierarchy 1 MCW_WGRU1 CHAR 18 0
WGRU2 Material group hierarchy 2 MCW_WGRU2 CHAR 18 0
SKOPF Assortment module W_SORTK CHAR 18 0
VWPOS Item usage VWPOS CHAR 4 0
VKGRU Repair Processing: Classification of Items VKGRU CHAR 3 0
RFCUO Configuration CUOBJ_VA NUMC 18 0
KONDA Price group (customer) KONDA CHAR 2 0
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
PLTYP Price list type PLTYP CHAR 2 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Yes
NULL No
PERFK Invoice dates (calendar identification) PERFK CHAR 2 0
PERRL Invoice list schedule (calendar identification) PERRL CHAR 2 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
KURRF Exchange rate for FI postings KURRF DEC 9 5
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method SCHZW_BSEG CHAR 1 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
STCUR Exchange rate for statistics STCUR DEC 9 5
MSCHL Dunning key MSCHL CHAR 1 0
MANSP Dunning block MANSP CHAR 1 0
FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
WAKTION Promotion WAKTION CHAR 10 0
ABSSC Payment guarantee procedure ABSSCHE_CM CHAR 6 0
LCNUM Financial doc. processing: Internal financial doc. number LCNUM CHAR 10 0
J_1AFITP Tax type J_1AFITP_D CHAR 2 0
J_1ARFZ Reason for zero VAT J_1ARFZVAT CHAR 1 0
J_1AREGIO Region (State, Province, County) REGIO CHAR 3 0
J_1AGICD Activity Code for Gross Income Tax J_1AGICD_D CHAR 2 0
J_1ADTYP Distribution Type for Employment Tax J_1ADTYP_D CHAR 2 0
J_1ATXREL Tax relevant classification J_1ATXREL_ CHAR 10 0
ABTNR Department number ABTNR CHAR 4 0
EMPST Receiving point EMPST CHAR 25 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSARK Customer purchase order type BSARK CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
POSEX_E Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
KURSK_DAT Translation Date WWERT_D DATS 8 0
KURRF_DAT Translation Date WWERT_D DATS 8 0
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
WKWAE Value contract currency WKWAE CUKY 5 0
WKKUR Exchange rate in value contract currency WKKUR DEC 9 5
AKWAE Currency key for letter-of-credit procg in foreign trade AKWAE CUKY 5 0
AKKUR Exchange rate for letter-of-credit procg in foreign trade AKKUR DEC 9 5
AKPRZ Depreciation percentage for financial document processing AKPRZ DEC 5 2
J_1AINDXP Inflation Index J_1AINDXP CHAR 5 0
J_1AIDATEP Indexing base date J_1AIDATES DATS 8 0
BSTKD_M Customer PO number as matchcode field BSTKD_M CHAR 35 0
DELCO Agreed delivery time DELCO CHAR 3 0
FFPRF Dynamic Item Processor Profile AD01PROFNR CHAR 8 0
BEMOT Accounting Indicator BEMOT CHAR 2 0
FAKTF Billing form FAKTF CHAR 2 0
01 Fixed rate
02 Costs
RRREL Revenue recognition category RR_RELTYP CHAR 1 0
NULL Standard revenue recognition
A Time-related revenue recognition
B Service-related revenue recognition
D Billing-related, time-related revenue recognition
E Billing-related, service-related revenue recognition (IS-M)
F Credit/Debit Memos with reference to predecessor
ACDATV Proposed start date for accrual period RR_ACDATV CHAR 1 0
NULL Not relevant
A Proposal based on contract start date
B Proposal based on billing plan start date
WMINR Product catalog number WMINR CHAR 10 0
FKBER Functional Area FKBER CHAR 16 0
CAMPAIGN Generic project planning: GUID from external R/3 system CGPL_GUID16_R3 RAW 16 0
VSART Shipping type VSARTTR CHAR 2 0
SDABW Special processing indicator SDABW CHAR 4 0
VKONT CHAR 12 0
PEROP_BEG Period of Performance Start Date FM_PEROP_SD_LOW DATS 8 0
PEROP_END Period of Performance End Date FM_PEROP_SD_HIGH DATS 8 0
DPBP_REF_FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
DPBP_REF_FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
J_1BCFOP CFOP Code and Extension J_1BCFOP CHAR 10 0
J_1BTAXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 0
J_1BTAXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 0
J_1BTXSDC SD tax code J_1BTXSDC_ CHAR 2 0
PMATN Pricing Reference Material PMATN CHAR 18 0
ZWERT Target Value for Outline Agreement in Document Currency DZWERT CURR 13 2
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
ABLFZ Rounding quantity for delivery ABLFZ QUAN 13 3
ABSFZ Allowed deviation in quantity (absolute) ABSFZ QUAN 13 3
KBVER Allowed deviation in quantity (in percent) KBVER DEC 3 0
KEVER Days by which the quantity can be shifted KEVER DEC 3 0
PLAVO Planning delivery schedule instruction PLAVO CHAR 4 0
VKAUS Usage Indicator ABRVW CHAR 3 0
FMENG Quantity is Fixed FMENG CHAR 1 0
X Yes
NULL No
UEBTK Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Yes
NULL No
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
SPART Division SPART CHAR 2 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
BRGEW Gross Weight of the Item BRGEW_AP QUAN 15 3
NTGEW Net Weight of the Item NTGEW_AP QUAN 15 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume of the item VOLUM_AP QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
LPRIO Delivery Priority LPRIO NUMC 2 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
ROUTE Route ROUTE CHAR 6 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
TAXM1 Tax classification material TAXMT CHAR 1 0
TAXM2 Tax classification material TAXMT CHAR 1 0
TAXM3 Tax classification material TAXMT CHAR 1 0
TAXM4 Tax classification material TAXMT CHAR 1 0
TAXM5 Tax classification material TAXMT CHAR 1 0
TAXM6 Tax classification material TAXMT CHAR 1 0
TAXM7 Tax classification material TAXMT CHAR 1 0
TAXM8 Tax classification material TAXMT CHAR 1 0
TAXM9 Tax classification material TAXMT CHAR 1 0
KONDM Material Pricing Group KONDM CHAR 2 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
SERNR BOM explosion number SERNR CHAR 8 0
ABGRS Results Analysis Key ABGR_SCHL CHAR 6 0
ZSCHL_K Overhead key AUFZSCHL CHAR 6 0
KALSM_K Costing Sheet AUFKALSM CHAR 6 0
BEDAE Requirements type BEDAE CHAR 4 0
NACHL Customer has not posted goods receipt NACHL CHAR 1 0
X Yes
NULL No
EXART Business Transaction Type for Foreign Trade EXART CHAR 2 0
MATNR_G Repairs processing: Serviceable material number RMA_MATNR_G CHAR 18 0
MENGE_G Repairs processing: Serviceable material quantity for repair RMA_MENGE NUMC 7 0
MFRGR Material freight group MFRGR CHAR 8 0
KANNR KANBAN/sequence number KANNR CHAR 35 0
KORDT Delivery date LFDAT DATS 8 0
KORMNG Correction qty for cumulative quantity KORMNG QUAN 13 3
KMPMG Component quantity KMPMG QUAN 13 3
REFOBJTYPE Object Type SWO_OBJTYP CHAR 10 0
REFOBJKEY Object key SWO_TYPEID CHAR 70 0
REFLOGSYS Logical system LOGSYS CHAR 10 0
MATWA Material entered MATWA CHAR 18 0
WKTNR Value contract no. WKTNR CHAR 10 0
WKTPS Value contract item WKTPS NUMC 6 0
POSGUID ATP: Encryption of DELNR and DELPS POSGUID CHAR 22 0
CONFIG_ID External Configuration ID (Temporary) CUXCFG_ID CHAR 6 0
INST_ID Instance Number in Configuration CU_INST_ID CHAR 8 0
STLAL Alternative BOM STLAL CHAR 2 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
UEPVW ID for higher-level item usage UEPVW CHAR 1 0
A Product selection
B Free goods (inclusive bonus)
C Free goods (on-top bonus)
D Repairs
E ** unused **
F Cross selling
G Complete goods (purchase order)
H Automotive (subitem)
I CRM Repairs
K Kit Component
R Replacement Kit Component
BILL_REL Billing Relevance (CRM) CRM_FKREL CHAR 1 0
A Delivery-Related CRM Billing
B Delivery-Related CRM Billing - No Zero Quantity
C Transaction-Related CRM Billing
D Trans.-Related CRM Billing, Replication Decoup. R3 (DOM)
E Not Relevant for Billing
F Delivery-Related CRM Billing with IC Billing in CRM
G Dlvy-Related CRM Billing with IC Billing in CRM- No Zero Qty
SELECTION Selection ID (Persistent) VBX_SEL_ID CHAR 32 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
LOGSYS_EXT Logical system LOGSYS CHAR 10 0
J_1BTAXLW3 ISS Tax Law J_1BTAXLW3 CHAR 3 0
J_1BTAXLW4 COFINS Tax Law J_1BTAXLW4 CHAR 3 0
J_1BTAXLW5 PIS Tax Law J_1BTAXLW5 CHAR 3 0
TAS Treasury Account Symbol PSM_TAS CHAR 30 0
BETC Business Event Transaction Code PSM_BETC CHAR 10 0
MOD_ALLOW Modification Allowed PSM_MOD_ALLOW CHAR 1 0
CANCEL_ALLOW Cancellation Allowed PSM_CANC_ALLOW CHAR 1 0
PAY_METHOD List of the Payment Methods to be Considered DZWELS CHAR 10 0
BPN Business Partner Number PSM_BPN CHAR 6 0
REP_FREQ Reporting Frequency PSM_REP_FREQ CHAR 3 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
Z_PRS_OFFSHORE Professional Services: Delivery Type Z_PRS_OFFSHORE CHAR 1 0
1 Onshore
2 Nearshore
3 Offshore
Z_PRS_BILL_FLAG Professional Services: Billable/Non-Billable Z_PRS_BILLABLE_FLAG CHAR 1 0
X Yes
NULL No
Z_PRS_COUNTRY Country Key LAND1 CHAR 3 0
Z_PRS_CHARGELEVL Professional Services: Charge Level Z_PRS_CHARGELEVEL CHAR 2 0
L1 Trainee Level
L2 Junior Level
L3 Specialist Level
L4 Senior Level
L5 Partner Level
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
FIPOS Commitment Item FIPOS CHAR 14 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
KOSTL Cost Center KOSTL CHAR 10 0
FONDS Fund BP_GEBER CHAR 10 0
FISTL Funds Center FISTL CHAR 16 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
MILL_VS_ACTIVE Checkbox XFELD CHAR 1 0
X Yes
NULL No
MILL_VS_KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
MILL_VS_REAL_POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
MILL_VS_VARCHANGED Checkbox XFELD CHAR 1 0
X Yes
NULL No
MILL_VS_CONF_REPLAY Checkbox XFELD CHAR 1 0
X Yes
NULL No
MILL_VS_VAR_REPLAY Checkbox XFELD CHAR 1 0
X Yes
NULL No
MILL_VS_RFTCH Checkbox XFELD CHAR 1 0
X Yes
NULL No
MILL_SE_GPOSN Global Item MILL_SE_GPOSN NUMC 6 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIPLANTD Plant determination active or not active OID_PLANTD CHAR 1 0
X Yes
NULL No
OIBYPASS IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIEDOK Excise duty validation indicator OIH_EDOK CHAR 1 0
X Yes
NULL No
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO OIH4 CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO OIH4 CHAR 2 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIEDBAL Excise duty balancing is required (indicator) OIH_EDBAL CHAR 1 0
X Yes
NULL No
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIINEX Code for internal or external excise duty rate determination OIH_INEX OIH16 CHAR 2 0
OIEDBALM Excise duty balancing method indicator OIH_EDBALM CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
OIDRC Differential Reference Code (DRC) OIC_DRC OICDC CHAR 5 0
OIC_DRCTRY DRC country OIC_DRCTRY T005 CHAR 3 0
OIC_DRCREG DRC region OIC_DRCREG T005S CHAR 3 0
OIMETIND Metropolitan indicator OIC_METIND OICMI CHAR 4 0
OIWAP Wide-area pricing zone OIC_WAP OICWA CHAR 3 0
OISLF State license fee zone OIC_SLF OICSL CHAR 3 0
OIPSDRC Pricing DRC (grouping customers by DRC for pricing) OIC_PSDRC OICDC CHAR 5 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC T005G CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC T005E CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO T005S CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 T005 CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC T005G CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC T005E CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO T005S CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 T005 CHAR 3 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operatorยดs external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT TVTR CHAR 2 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP TOIA2 CHAR 4 0
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC T008 CHAR 1 0
OICONTNR Outline agreement: contract OIC_CONTNR VBUK CHAR 10 0
OIC_KMPOS Reference contract line item number OIC_KMPOS NUMC 6 0
OIFEECH Fee edit control OIA_FEECH CHAR 1 0
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
OIH_LICTP License type OIH_LICTP OIH20 CHAR 4 0
OIH_LICIN Excise tax internal license number OIH_LICIN OIHL CHAR 10 0
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL OIHL CHAR 10 0
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OIBASPROD Base product number OIA_SBMAT MARA CHAR 18 0
OIDMSG_PRD Message type for product with contract restrictions OIDMSG_PRD CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_QTY Message type for contract restrictions quantity OIDMSG_QTY CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_UOM Message type for contract restrictions unit of measure OIDMSG_UOM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_DAT Message type for contract restrictions validity period OIDMSG_DAT CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_TRM Message type for contract restrictions payment terms OIDMSG_TRM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_SHP Message type for contract restrictions ship-to party OIDMSG_SHP CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIGNRULE Gross/net pricing rule OIC_GNRULE TFRM NUMC 3 0
OID_SHIP Ship-to party KUNWE KNA1 CHAR 10 0
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
PRS_WORK_PERIOD Work Period (Internal Representation) PRS_WORK_PERIOD NUMC 7 0
PARGB Trading partner's business area PARGB CHAR 4 0
PCTRF Profit Center for Billing PCTRF CHAR 10 0
AUFPL_OAA Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL_OAA Internal counter CIM_COUNT NUMC 8 0
COMPREAS Abbreviation for Complaints Reason CMP_COMPREAS_COPY CHAR 4 0
ARSNUM Number of reservation/dependent requirements WTYSC_RSNUM NUMC 10 0
ARSPOS Item number of reservation/dependent requirements WTYSC_RSPOS NUMC 4 0
WTYSC_CLMITEM Claim item number WTYSC_CLMITEM CHAR 16 0

VBAPKOM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBAPKOM OIBASPROD VBAPKOM OIBASPROD MARA General Material Data MATNR
VBAPKOM OIBASPROD T000 MANDT MARA General Material Data MANDT
VBAPKOM OICONTNR VBAPKOM OICONTNR VBUK Sales Document: Header Status and Administrative Data VBELN
VBAPKOM OICONTNR T000 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBAPKOM OIC_DCITYC VBAPKOM OIC_DCITYC T005G City CITYC
VBAPKOM OIC_DCITYC SYST MANDT T005G City MANDT
VBAPKOM OIC_DCITYC VBAPKOM OIC_DLAND1 T005G City LAND1
VBAPKOM OIC_DCITYC VBAPKOM OIC_DREGIO T005G City REGIO
VBAPKOM OIC_DCOUNC SYST MANDT T005E County MANDT
VBAPKOM OIC_DCOUNC VBAPKOM OIC_DLAND1 T005E County LAND1
VBAPKOM OIC_DCOUNC VBAPKOM OIC_DREGIO T005E County REGIO
VBAPKOM OIC_DCOUNC VBAPKOM OIC_DCOUNC T005E County COUNC
VBAPKOM OIC_DLAND1 VBAPKOM OIC_DLAND1 T005 Countries LAND1
VBAPKOM OIC_DLAND1 SYST MANDT T005 Countries MANDT
VBAPKOM OIC_DRCREG T000 MANDT T005S Taxes: Region (Province) Key MANDT
VBAPKOM OIC_DRCREG VBAPKOM OIC_DRCTRY T005S Taxes: Region (Province) Key LAND1
VBAPKOM OIC_DRCREG VBAPKOM OIC_DRCREG T005S Taxes: Region (Province) Key BLAND
VBAPKOM OIC_DRCTRY VBAPKOM OIC_DRCTRY T005 Countries LAND1
VBAPKOM OIC_DRCTRY T000 MANDT T005 Countries MANDT
VBAPKOM OIC_DREGIO VBAPKOM OIC_DREGIO T005S Taxes: Region (Province) Key BLAND
VBAPKOM OIC_DREGIO VBAPKOM OIC_DLAND1 T005S Taxes: Region (Province) Key LAND1
VBAPKOM OIC_DREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBAPKOM OIC_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
VBAPKOM OIC_LIFNR VBAPKOM OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
VBAPKOM OIC_MOT SYST MANDT TVTR Routes: Modes of Transport MANDT
VBAPKOM OIC_MOT VBAPKOM OIC_MOT TVTR Routes: Modes of Transport VKTRA
VBAPKOM OIC_OCITYC VBAPKOM OIC_OCITYC T005G City CITYC
VBAPKOM OIC_OCITYC VBAPKOM OIC_OREGIO T005G City REGIO
VBAPKOM OIC_OCITYC VBAPKOM OIC_OLAND1 T005G City LAND1
VBAPKOM OIC_OCITYC SYST MANDT T005G City MANDT
VBAPKOM OIC_OCOUNC VBAPKOM OIC_OCOUNC T005E County COUNC
VBAPKOM OIC_OCOUNC VBAPKOM OIC_OREGIO T005E County REGIO
VBAPKOM OIC_OCOUNC VBAPKOM OIC_OLAND1 T005E County LAND1
VBAPKOM OIC_OCOUNC SYST MANDT T005E County MANDT
VBAPKOM OIC_OLAND1 SYST MANDT T005 Countries MANDT
VBAPKOM OIC_OLAND1 VBAPKOM OIC_OLAND1 T005 Countries LAND1
VBAPKOM OIC_OREGIO VBAPKOM OIC_OREGIO T005S Taxes: Region (Province) Key BLAND
VBAPKOM OIC_OREGIO VBAPKOM OIC_OLAND1 T005S Taxes: Region (Province) Key LAND1
VBAPKOM OIC_OREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBAPKOM OIDRC VBAPKOM OIDRC OICDC Differential Reference Code OIDRC
VBAPKOM OIDRC T000 MANDT OICDC Differential Reference Code MANDT
VBAPKOM OID_SHIP T000 MANDT KNA1 General Data in Customer Master MANDT
VBAPKOM OID_SHIP VBAPKOM OID_SHIP KNA1 General Data in Customer Master KUNNR
VBAPKOM OIEXGTYP SYST MANDT TOIA2 Exchange types MANDT
VBAPKOM OIEXGTYP VBAPKOM OIEXGTYP TOIA2 Exchange types EXGTYP
VBAPKOM OIGNRULE T000 MANDT TFRM Form Routines for Requirements/Formulas/Data Transports GRPZE
VBAPKOM OIGNRULE VBAPKOM OIGNRULE TFRM Form Routines for Requirements/Formulas/Data Transports GRPNO
VBAPKOM OIHANTYP VBAPKOM OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
VBAPKOM OIHANTYP T000 MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
VBAPKOM OIH_LCFOL VBAPKOM OIH_LCFOL OIHL License Master Data LICIN
VBAPKOM OIH_LCFOL T000 MANDT OIHL License Master Data MANDT
VBAPKOM OIH_LCFOL VBAPKOM OIH_LICTP OIHL License Master Data LICTP
VBAPKOM OIH_LICIN T000 MANDT OIHL License Master Data MANDT
VBAPKOM OIH_LICIN VBAPKOM OIH_LICIN OIHL License Master Data LICIN
VBAPKOM OIH_LICIN VBAPKOM OIH_LICTP OIHL License Master Data LICTP
VBAPKOM OIH_LICTP VBAPKOM OIH_LICTP OIH20 License types LICTP
VBAPKOM OIH_LICTP T000 MANDT OIH20 License types MANDT
VBAPKOM OIINEX VBAPKOM OIINEX OIH16 Internal/external price conditions INEX
VBAPKOM OIINEX T000 MANDT OIH16 Internal/external price conditions MANDT
VBAPKOM OIMETIND VBAPKOM OIMETIND OICMI Metropolitan Indicator OIMETIND
VBAPKOM OIMETIND T000 MANDT OICMI Metropolitan Indicator MANDT
VBAPKOM OINETCYC SYST MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
VBAPKOM OINETCYC VBAPKOM OINETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
VBAPKOM OIPSDRC VBAPKOM OIPSDRC OICDC Differential Reference Code OIDRC
VBAPKOM OIPSDRC T000 MANDT OICDC Differential Reference Code MANDT
VBAPKOM OISLF VBAPKOM OISLF OICSL State License Fee Zone OISLF
VBAPKOM OISLF T000 MANDT OICSL State License Fee Zone MANDT
VBAPKOM OITAXFROM T000 MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
VBAPKOM OITAXFROM VBAPKOM OITAXFROM OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
VBAPKOM OITAXGRP T000 MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
VBAPKOM OITAXGRP VBAPKOM OITAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
VBAPKOM OITAXTO T000 MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
VBAPKOM OITAXTO VBAPKOM OITAXTO OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
VBAPKOM OIWAP VBAPKOM OIWAP OICWA Wide Area Pricing Zone OIWAP
VBAPKOM OIWAP T000 MANDT OICWA Wide Area Pricing Zone MANDT