VC_INTEGRATION_VBAP

Extraction for VBAP | view: VCIVBAP | TRAN | Extraction: Full or Incremental | Component: Configuration and Pricing Services
Tables used: VBAP
Column Name Description
VBELN FK Sales Document
POSNR Sales Document Item
Column Name Description
💲 SD Document Currency (WAERK):
ZWERT Target Value for Outline Agreement in Document Currency
NETWR Net Value of the Order Item in Document Currency
NETPR Net Price
WAVWR Cost in Document Currency
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
CMPRE Item credit price
MWSBP Tax Amount in Document Currency
IFRS15_TOTAL_SSP IFRS 15: Standalone Selling Price
CAPPED_NET_AMOUNT Net Amount Cap
Column Name Description
📏 Target Quantity UoM (ZIEME):
ZMENG Target Quantity in Sales Units
ABLFZ Rounding quantity for delivery
ABSFZ Allowed deviation in quantity (absolute)
📏 Base Unit of Measure (MEINS):
SMENG Scale Quantity in base unit of measure
KLMENG Cumulative Confirmed Quantity in Base Unit
LFMNG Minimum Delivery Quantity in Delivery Note Processing
KMPMG Component Quantity
REQQTY_BU Requested Order Quantity in Base Unit
📏 Sales unit (VRKME):
KWMENG Cumulative order quantity in sales units
LSMENG Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
KBMENG Cumulative Confirmed Quantity in Sales Unit
CMTD_DELIV_QTY_SU Committed Delivery Quantity in Sales Unit
📏 Weight Unit (GEWEI):
BRGEW Gross Weight of the Item
NTGEW Net Weight of the Item
📏 Volume unit (VOLEH):
VOLUM Volume of the item
📏 Purchase Order Unit of Measure (PO_UNIT):
PO_QUAN Purchase Order Quantity
Column Name Description
ABDAT Reconciliation date for agreed cumulative quantity
STDAT Key date of the bill of material
ERDAT Date on which the record was created
ERZET Entry time
AEDAT Last Changed On
STADAT Statistics date
HANDOVERDATE Handover Date at the Handover Location
HANDOVERTIME Handover time at the handover location
_DATAAGING Data Filter Value for Data Aging
CMTD_DELIV_DATE Delivery Date that the Supplier Has Committed To
CMTD_DELIV_CREADATE Deliv. Creation Date in Order to Meet Committed Deliv. Date
SESSION_CREATION_DATE Date of the Session During Which the Record Was Created
SESSION_CREATION_TIME Time of the Session During Which the Record Was Created
ZABDATI Annexing base date
FSH_CANDATE Cancellation Date
J_3GDATVO From Date
J_3GDATBI To Date
Column Name Description
POSAR Item Type Show values
PROCESS_CODE Item Processing Code Show values
LFREL Item Is Relevant for Delivery Show values
FKREL Relevant for Billing Show values
PRODH_UNIV_SALES_DET_ORIGIN Date Relevant for Determination of Product Hierarchy Show values
PRODH_UNIV_BATDET_DET_ORIGIN Date Relevant for Determination of Product Hierarchy Show values
FMENG Quantity is fixed Show values
UEBTK Unlimited Overdelivery Allowed Show values
ATPKZ Replacement part Show values
KZTLF Partial delivery at item level Show values
CHSPL Batch split allowed Show values
VOREF Complete Reference Indicator Show values
UPFLU Update Indicator for Document Flow of Sales Document Show values
ERLRE Completion Rule for Quotation / Contract Show values
AWAHR Order Probability of the Item Show values
VGREF Preceding document has resulted from reference Show values
SHKZG Returns Item Show values
SKTOF Cash Discount Indicator Show values
SUMBD Summing up of requirements Show values
PRSOK Pricing is OK Show values
BWTEX Indicator: Separate valuation Show values
XCHPF Batch Management Requirement Indicator Show values
XCHAR Batch management indicator (internal) Show values
FIXMG Delivery Date and Quantity Fixed Show values
VPZUO Allocation Indicator Show values
KZVBR Consumption posting Show values
CMTFG ID for partial release of order item, credit block Show values
CMPNT ID: Item with active credit function / relevant for credit Show values
CEPOK Status expected price Show values
KOUPD Condition Update Show values
NACHL Customer has not posted goods receipt Show values
MPROK Status manual price change Show values
VGTYP Document Category of Preceding SD Document Show values
PROSA ID for material determination Show values
UEPVW ID for higher-level item usage Show values
KOWRR Statistical Values Show values
PREFE Customs Preference Show values
STLTY BOM category Show values
STMAN Inconsistent configuration Show values
KZBWS Valuation of Special Stock Show values
KZFME ID: Leading unit of measure for completing a transaction Show values
LSTANR Free goods delivery control Show values
SLOCTYPE Type of First Inventory-Managing Location Show values
MSR_APPROV_BLOCK Approval Block Show values
TRMRISK_RELEVANT Risk Relevancy in Sales Show values
TAX_SUBJECT_ST Tax Subject to Substituição Tributária Show values
ABSTA Rejection Status (Item) Show values
BESTA Delivery Confirmation Status (Item) Show values
CMPPI Status of Credit Check Against Financial Document Show values
CMPPJ Status of Credit Check Against Export Credit Insurance Show values
COSTA Purchasing Confirmation Status Show values
DCSTA Delay Status (Item) Show values
FKSAA Order-Related Billing Status (Item) Show values
FSSTA Billing Block Status (Item) Show values
GBSTA Overall Processing Status (Item) Show values
LFGSA Overall Delivery Status (Item) Show values
LFSTA Delivery Status (Item) Show values
LSSTA Overall Delivery Block Status (Item) Show values
RFGSA Overall Reference Status (Item) Show values
RFSTA Reference Status (Item) Show values
UVALL Incompletion Status (Item) Show values
UVFAK Billing Incompletion Status (Item) Show values
UVPRS Pricing Incompletion Status (Item) Show values
UVVLK Delivery Incompletion Status (Item) Show values
UVP01 Customer reserves 1: Item status Show values
UVP02 Customer reserves 2: Item status Show values
UVP03 Item reserves 3: Item status Show values
UVP04 Item reserves 4: Item status Show values
UVP05 Customer reserves 5: Item status Show values
WBSTA Goods Movement Status (Item) Show values
EMCST Embargo Status (Item) Show values
SLCST Screening Status (Item) Show values
TOTAL_LCCST Legal Control Status Show values
PCSTA Product Marketability Status (Item) Show values
DGSTA Dangerous Goods Status (Item) Show values
SDSSTA Safety Data Sheet Status (Item) Show values
DP_CLEAR_STA_ITM Down Payment Status Show values
PBS_STATE State of Project-Based Service Show values
IFRS15_RELEVANCE Item is relevant for IFRS 15 Show values
REVFP Rule for transferring the results of the availability check Show values
ATP_ABC_SUBSTITUTION_STATUS Substitution Status for Alternative-Based Confirmation (ABC) Show values
MILL_BATCH_SEL_F Control of Batch Selection Show values
ADDNS Do Not Substitute Show values
LABSG Indicator for Inbound Forecast and JIT Delivery Schedules Show values
FABSG Indicator for Inbound Forecast Delivery Schedule Headers Show values
FSH_SEAREF Season Determined from Reference Document Show values
FSH_VAS_REL VAS Relevant Show values
FSH_VASREF VAS Determined from Reference Document Show values
RFM_SCC_INDICATOR Season Completeness Indicator Show values
IUID_RELEVANT IUID Relevant for Customer Show values
Column Name Description Domain name
ARKTX Short text for sales order item TEXT40
UEPOS Higher-Level Item in Bill of Material Structures POSNR
GRPOS Item for Which this Item is an Alternative GRPOS
PRODH_UNIV_SALES_PARNT_NODID Node ID UHOID
PRODH_UNIV_BATDET_PARNT_NODID Node ID UHOID
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
POSEX Item Number of the Underlying Purchase Order POSEX
KDMAT Material Number Used by Customer IDNEX
KBVER Allowed deviation in quantity (in percent) PACK2
KEVER Days by which the quantity can be shifted PACK2
GRKOR Delivery Group (Items are delivered together) GRKOR
UEBTO Overdelivery Tolerance PRZ21
UNTTO Underdelivery Tolerance PRZ21
RKFKF Method of billing for CO/PPC orders RKFKF
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
VBELV Originating Document VBELN
POSNV Originating Item POSNR
VGBEL Document number of the reference document VBELN
VGPOS Item number of the reference item POSNR
WERKS Plant (Own or External) WERKS
STKEY Origin of the bill of material STKEY
STLNR Bill of Material STNUM
STPOS Bill of material item number VBAP not used STPOS_VBAP
TAXM1 Tax Classification for Material TAXKD
TAXM2 Tax Classification for Material TAXKD
TAXM3 Tax Classification for Material TAXKD
TAXM4 Tax Classification for Material TAXKD
TAXM5 Tax Classification for Material TAXKD
TAXM6 Tax Classification for Material TAXKD
TAXM7 Tax Classification for Material TAXKD
TAXM8 Tax Classification for Material TAXKD
TAXM9 Tax Classification for Material TAXKD
VBEAF Fixed shipping processing time in days (= setup time) DEC3_2
VBEAV Variable shipping processing time in days DEC3_2
KPEIN Condition Pricing Unit KPEIN
EANNR European Article Number (EAN) - obsolete!!!!! CHAR13
STAFO Update Group for statistics update STAFO
STCUR Exchange rate for statistics (Exch.rate at time of creation) KURRF
EAN11 International Article Number (EAN/UPC) EAN11
PRCTR Profit Center PRCTR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
UMREF Conversion factor: quantities FLTP
CMKUA Credit data exchange rate for requested delivery date KURRF
CUOBJ Configuration CUOBJ
CUOBJ_CH Internal object number of the batch classification CUOBJ
ANZSN Number of serial numbers INT4
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
KLVAR Costing Variant KLVAR
SPOSN BOM Item Number SPOSN
EXART Business Transaction Type EXART
KNUMH Number of condition record from batch determination KNUMB
CHMVS Batches: Exit to quantity proposal NUM3
STLKN BOM item node number KNTNR
STPOZ Internal counter CIM_COUNT
ZSCHL_K Overhead key CHAR6
KANNR KANBAN/Sequence Number CHAR35
CMPRE_FLT Item Credit Price FLTP
ABGES Guaranteed (factor between 0 and 1) FLTP
WGRU1 Material group hierarchy 1 KLASSE
WGRU2 Material group hierarchy 2 KLASSE
TECHS Parameter Variant/Standard Variant TECHS
BERID MRP Area BERID
PCTRF Profit Center for Billing PRCTR
LOGSYS_EXT Logical system LOGSYS
STOCKLOC First Inventory-Managing Location LOCNR
NRAB_KNUMH Number of the Condition Record KNUMH
SGT_RCAT Requirement Segment SGT_SRCA
VBKD_POSNR Sales Document Item POSNR
VEDA_POSNR Sales Document Item POSNR
HANDOVERLOC Location for a physical handover of goods HANDOVER_LOC
EXT_REF_ITEM_ID External Item ID CHAR40
TC_AUT_DET Tax Code Automatically Determined MWSKZ
MANUAL_TC_REASON Manual Tax Code Reason J_1BMANUAL_TC_REASON
FISCAL_INCENTIVE Tax Incentive Type J_1BFISCAL_INCENTIVE_CODE
FISCAL_INCENTIVE_ID Incentive ID J_1BFISCAL_INCENTIVE_ID_SD
SPCSTO Nota Fiscal Special Case for CFOP Determination J_1BSPCSTO_SD
REVACC_REFID Revenue Accounting: Reference ID
REVACC_REFTYPE Revenue Accounting: Reference Type
MANEK Manual Completion of Contract MANEK
HANDLE GUID in 'CHAR' Format in Uppercase SYSUUID_C
CAPPED_NET_AMOUNT_ALERT_THLD Notification Threshold (in Pct) for Exceeded Net Amount Cap CAPPED_NET_AMOUNT_ALERT_THLD
CATS_OVERTIME_CATEGORY Overtime Category CATS_OVERTIME_CATEGORY
ORIGINAL_PLANT Original Plant in Plant Substitution WERKS
DUMMY_SLSDOCITEM_INCL_EEW_PS Dummy function in length 1 DUMMY
MILL_SE_GPOSN Global Item POSNR
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
CPD_UPDAT Time Stamp /CPD/PFP_SC_TSTMP
APCGK_EXTENDI Extended key for annexing package NUMC10
AUFPL_OLC Routing number of operations in the order AUFPL
APLZL_OLC Internal counter CIM_COUNT
ADACN Aircraft registration number ADACN
FSH_CRSD Condition Record Number for Seasons FSH_CRSD
FSH_PSM_PFM_SPLIT PSM and PFM Split ID FSH_PSM_PFM_SPLIT
FSH_VAS_PRNT_ID Item number of the SD document POSNR
FSH_TRANSACTION Transaction Number FSH_TRANSACTION
FSH_ITEM_GROUP Item Group FSH_ITEM_GROUP
FSH_ITEM Item Number FSH_ITEM
FSH_GRID_COND_REC Grid Condition Record Number CHAR32
FSH_PQR_UEPOS Higher-level item in Partial Quantity Rejection POSNR
PRS_OBJNR Engagement mgmt: Object number CHAR22
PRS_SD_SPSNR Standard WBS Element for Project Inception via SD PS_SPSNR
PRS_WORK_PERIOD Work Period (Internal Representation) PRS_WORK_PERIOD
RFM_PSST_RULE PSST Grouping Rule RFM_PSST_RULE
RFM_PSST_GROUP PSST Group RFM_PSST_GROUP_ID
PARGB Trading partner's business area GSBER
AUFPL_OAA Routing number of operations in the order AUFPL
APLZL_OAA Internal counter CIM_COUNT
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
ARSNUM Number of reservation/dependent requirements RSNUM
ARSPOS Item number of reservation/dependent requirements RSPOS
WTYSC_CLMITEM Claim item number WTYSC_CLMITEM
Master Data Relations | to Other Relations ↓ Join Conditions
Form of payment guarantee
  • Form of payment guarantee
  • Client
  • VC_INTEGRATION_VBAP.ABFOR == T691K.ABSFO
  • VC_INTEGRATION_VBAP.MANDT == T691K.MANDT
Results Analysis Key
  • Client
  • Results Analysis Key
  • VC_INTEGRATION_VBAP.MANDT == TKKAA.MANDT
  • VC_INTEGRATION_VBAP.ABGRS == TKKAA.ABGSL
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • VC_INTEGRATION_VBAP.MANDT == TVAG.MANDT
  • VC_INTEGRATION_VBAP.ABGRU == TVAG.ABGRU
Model ID Code
  • Client
  • Model ID Code
  • VC_INTEGRATION_VBAP.MANDT == CSPCMOI.MANDT
  • VC_INTEGRATION_VBAP.ADMOI == CSPCMOI.ADMOI
Order Priority
  • Client
  • Order Priority
  • VC_INTEGRATION_VBAP.MANDT == CSPCPRI.MANDT
  • VC_INTEGRATION_VBAP.ADPRI == CSPCPRI.ADPRI
Order Number
  • Order Number
  • Client
  • VC_INTEGRATION_VBAP.AUFNR == AUFK.AUFNR
  • VC_INTEGRATION_VBAP.MANDT == AUFK.MANDT
Requirements type
  • Requirements type
  • Client
  • VC_INTEGRATION_VBAP.BEDAE == T459A.BEDAE
  • VC_INTEGRATION_VBAP.MANDT == T459A.MANDT
Volume rebate group
  • Volume rebate group
  • Client
  • VC_INTEGRATION_VBAP.BONUS == TVBO.BONUS
  • VC_INTEGRATION_VBAP.MANDT == TVBO.MANDT
Valuation Type
  • Client
  • Valuation Type
  • VC_INTEGRATION_VBAP.MANDT == T149D.MANDT
  • VC_INTEGRATION_VBAP.BWTAR == T149D.BWTAR
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • VC_INTEGRATION_VBAP.MANDT == MCHA.MANDT
  • VC_INTEGRATION_VBAP.CHARG == MCHA.CHARG
  • VC_INTEGRATION_VBAP.MATNR == MCHA.MATNR
  • VC_INTEGRATION_VBAP.WERKS == MCHA.WERKS
Internal Class Number
  • Client
  • Internal Class Number
  • VC_INTEGRATION_VBAP.MANDT == KLAH.MANDT
  • VC_INTEGRATION_VBAP.CLINT == KLAH.CLINT
Equipment Type
  • Type of Technical Object
  • Client
  • VC_INTEGRATION_VBAP.EQART == T370K.EQART
  • VC_INTEGRATION_VBAP.MANDT == T370K.MANDT
Equipment Number
  • Client
  • Equipment Number
  • VC_INTEGRATION_VBAP.MANDT == EQUI.MANDT
  • VC_INTEGRATION_VBAP.EQUNR == EQUI.EQUNR
Billing Block for Item
  • Client
  • Billing Block for Item
  • VC_INTEGRATION_VBAP.MANDT == TVFS.MANDT
  • VC_INTEGRATION_VBAP.FAKSP == TVFS.FAKSP
Regulatory indicator
  • Client
  • Regulatory indicator
  • VC_INTEGRATION_VBAP.MANDT == FERC_C7.MANDT
  • VC_INTEGRATION_VBAP.FERC_IND == FERC_C7.IND
Fashion Collection
  • Season
  • Client
  • Fashion Collection
  • Season Year
Season
  • Season
  • Client
  • Season Year
  • VC_INTEGRATION_VBAP.FSH_SEASON == FSH_SEASONS.FSH_SEASON
  • VC_INTEGRATION_VBAP.MANDT == FSH_SEASONS.MANDT
  • VC_INTEGRATION_VBAP.FSH_SEASON_YEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Season
  • Client
  • Season Year
  • VC_INTEGRATION_VBAP.FSH_SEASON == FSH_SEASONS.FSH_SEASON
  • VC_INTEGRATION_VBAP.MANDT == FSH_SEASONS.MANDT
  • VC_INTEGRATION_VBAP.FSH_SEASON_YEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Season
  • Fashion Theme
  • Client
  • Fashion Collection
  • Season Year
  • VC_INTEGRATION_VBAP.FSH_SEASON == FSH_THEMES.FSH_SEASON
  • VC_INTEGRATION_VBAP.FSH_THEME == FSH_THEMES.FSH_THEME
  • VC_INTEGRATION_VBAP.MANDT == FSH_THEMES.MANDT
  • VC_INTEGRATION_VBAP.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION
  • VC_INTEGRATION_VBAP.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR
Weight Unit
  • Weight Unit
  • Client
  • VC_INTEGRATION_VBAP.GEWEI == T006.MSEHI
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • VC_INTEGRATION_VBAP.MANDT == TGSB.MANDT
  • VC_INTEGRATION_VBAP.GSBER == TGSB.GSBER
Foreign key for movement key
  • CFOP Code and Extension
  • Client
  • VC_INTEGRATION_VBAP.J_1BCFOP == J_1BAG.CFOP
  • VC_INTEGRATION_VBAP.MANDT == J_1BAG.MANDT
Foreign key for Brazilian tax ICMS
  • Client
  • Tax law: ICMS
  • VC_INTEGRATION_VBAP.MANDT == J_1BATL1.MANDT
  • VC_INTEGRATION_VBAP.J_1BTAXLW1 == J_1BATL1.TAXLAW
Foreign key for Brazilian tax IPI
  • Tax law: IPI
  • Client
  • VC_INTEGRATION_VBAP.J_1BTAXLW2 == J_1BATL2.TAXLAW
  • VC_INTEGRATION_VBAP.MANDT == J_1BATL2.MANDT
Foreign Key for Brazilian Tax ISS
  • Client
  • ISS Tax Law
  • VC_INTEGRATION_VBAP.MANDT == J_1BATL3.MANDT
  • VC_INTEGRATION_VBAP.J_1BTAXLW3 == J_1BATL3.TAXLAW
Foreign Key for Brazilian Tax COFINS
  • Client
  • COFINS Tax Law
  • VC_INTEGRATION_VBAP.MANDT == J_1BATL4A.MANDT
  • VC_INTEGRATION_VBAP.J_1BTAXLW4 == J_1BATL4A.TAXLAW
Foreign Key for Brazilian Tax PIS
  • Client
  • PIS Tax Law
  • VC_INTEGRATION_VBAP.MANDT == J_1BATL5.MANDT
  • VC_INTEGRATION_VBAP.J_1BTAXLW5 == J_1BATL5.TAXLAW
Foreign key for SD tax code
  • Client
  • SD tax code
  • VC_INTEGRATION_VBAP.MANDT == J_1BTXSDC.MANDT
  • VC_INTEGRATION_VBAP.J_1BTXSDC == J_1BTXSDC.TAXCODE
Activity Type
  • Activity Type
  • Client
  • VC_INTEGRATION_VBAP.J_3GLVART == J_3GLEIART.J_3GLVART
  • VC_INTEGRATION_VBAP.MANDT == J_3GLEIART.MANDT
Costing Sheet
  • Costing Sheet
  • Client
  • ?
  • ?
  • VC_INTEGRATION_VBAP.KALSM_K == T683.KALSM
  • VC_INTEGRATION_VBAP.MANDT == T683.MANDT
  • VC_INTEGRATION_VBAP.[column in domain "KVEWE"] == T683.KVEWE
  • VC_INTEGRATION_VBAP.[column in domain "KAPPL"] == T683.KAPPL
Costing Variant
  • Client
  • Costing Variant
  • VC_INTEGRATION_VBAP.MANDT == TCK03.MANDT
  • VC_INTEGRATION_VBAP.KALVAR == TCK03.KLVAR
Condition Unit
  • Client
  • Condition Unit
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
  • VC_INTEGRATION_VBAP.KMEIN == T006.MSEHI
Account Assignment Category
  • Account Assignment Category
  • Client
  • VC_INTEGRATION_VBAP.KNTTP == T163K.KNTTP
  • VC_INTEGRATION_VBAP.MANDT == T163K.MANDT
Sales Deal
  • Client
  • Sales Deal
  • VC_INTEGRATION_VBAP.MANDT == KONA.MANDT
  • VC_INTEGRATION_VBAP.KNUMA_AG == KONA.KNUMA
Sales Promotion
  • Client
  • Sales Promotion
  • VC_INTEGRATION_VBAP.MANDT == KONA.MANDT
  • VC_INTEGRATION_VBAP.KNUMA_PI == KONA.KNUMA
Material Price Group
  • Material Price Group
  • Client
  • VC_INTEGRATION_VBAP.KONDM == T178.KONDM
  • VC_INTEGRATION_VBAP.MANDT == T178.MANDT
Product allocation determination procedure
  • Client
  • Product allocation determination procedure
  • VC_INTEGRATION_VBAP.MANDT == T190S.MANDT
  • VC_INTEGRATION_VBAP.KOSCH == T190S.KOSCH
Account Assignment Group for Material
  • Account Assignment Group for Material
  • Client
  • VC_INTEGRATION_VBAP.KTGRM == TVKM.KTGRM
  • VC_INTEGRATION_VBAP.MANDT == TVKM.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • VC_INTEGRATION_VBAP.LGORT == T001L.LGORT
  • VC_INTEGRATION_VBAP.MANDT == T001L.MANDT
  • VC_INTEGRATION_VBAP.WERKS == T001L.WERKS
Delivery Priority
  • Delivery Priority
  • Client
  • VC_INTEGRATION_VBAP.LPRIO == TPRIO.LPRIO
  • VC_INTEGRATION_VBAP.MANDT == TPRIO.MANDT
Material Group: Packaging Materials
  • Material Group: Packaging Materials
  • Client
  • VC_INTEGRATION_VBAP.MAGRV == TVEGR.MAGRV
  • VC_INTEGRATION_VBAP.MANDT == TVEGR.MANDT
Material Group
  • Client
  • Material Group
  • VC_INTEGRATION_VBAP.MANDT == T023.MANDT
  • VC_INTEGRATION_VBAP.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • VC_INTEGRATION_VBAP.MANDT == MARA.MANDT
  • VC_INTEGRATION_VBAP.MATNR == MARA.MATNR
Material Entered
  • Client
  • Material Entered
  • VC_INTEGRATION_VBAP.MANDT == MARA.MANDT
  • VC_INTEGRATION_VBAP.MATWA == MARA.MATNR
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • VC_INTEGRATION_VBAP.MEINS == T006.MSEHI
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
Foreign key for material freight group
  • Client
  • Material freight group
  • VC_INTEGRATION_VBAP.MANDT == TMFG.MANDT
  • VC_INTEGRATION_VBAP.MFRGR == TMFG.MFRGR
Returns Refund Code
  • Returns Refund Code
  • Client
Return Reason
  • Return Reason
  • Client
Checking Group for Availability Check
  • Client
  • Checking Group for Availability Check
  • VC_INTEGRATION_VBAP.MANDT == TMVF.MANDT
  • VC_INTEGRATION_VBAP.MTVFP == TMVF.MTVFP
Material Group 1
  • Client
  • Material Group 1
  • VC_INTEGRATION_VBAP.MANDT == TVM1.MANDT
  • VC_INTEGRATION_VBAP.MVGR1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • VC_INTEGRATION_VBAP.MANDT == TVM2.MANDT
  • VC_INTEGRATION_VBAP.MVGR2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • VC_INTEGRATION_VBAP.MANDT == TVM3.MANDT
  • VC_INTEGRATION_VBAP.MVGR3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • VC_INTEGRATION_VBAP.MANDT == TVM4.MANDT
  • VC_INTEGRATION_VBAP.MVGR4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • VC_INTEGRATION_VBAP.MVGR5 == TVM5.MVGR5
  • VC_INTEGRATION_VBAP.MANDT == TVM5.MANDT
Instruction for Planning Delivery Schedule
  • Instruction for Planning Delivery Schedule
  • Client
  • VC_INTEGRATION_VBAP.PLAVO == TVZP.PLAVO
  • VC_INTEGRATION_VBAP.MANDT == TVZP.MANDT
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • VC_INTEGRATION_VBAP.MANDT == MARA.MANDT
  • VC_INTEGRATION_VBAP.PMATN == MARA.MATNR
Base unit of measure for product group
  • Base unit of measure for product group
  • Client
  • VC_INTEGRATION_VBAP.PRBME == T006.MSEHI
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
Product hierarchy: order item
  • Client
  • Product hierarchy
  • VC_INTEGRATION_VBAP.MANDT == T179.MANDT
  • VC_INTEGRATION_VBAP.PRODH == T179.PRODH
Commission Group
  • Client
  • Commission Group
  • VC_INTEGRATION_VBAP.MANDT == TVPR.MANDT
  • VC_INTEGRATION_VBAP.PROVG == TVPR.PROVG
Profile for Comparison of JIT Del.Sched. with JIT Del.Sched.
  • Client
  • Profile for Comparison of JIT Del.Sched. with JIT Del.Sched.
  • VC_INTEGRATION_VBAP.MANDT == ESD_TOPR.MANDT
  • VC_INTEGRATION_VBAP.PR_F_F == ESD_TOPR.PROFIL
Profile for Comp. of JIT Del.Sched. with Forecast Del.Sched.
  • Client
  • Profile for Comp. of JIT Del.Sched. with Forecast Del.Sched.
  • VC_INTEGRATION_VBAP.MANDT == ESD_TOPR.MANDT
  • VC_INTEGRATION_VBAP.PR_F_L == ESD_TOPR.PROFIL
Profile for Comparison of Frcst.DelSched with Frcst.DelSched
  • Client
  • Profile for Comparison of Frcst.DelSched with Frcst.DelSched
  • VC_INTEGRATION_VBAP.MANDT == ESD_TOPR.MANDT
  • VC_INTEGRATION_VBAP.PR_L_L == ESD_TOPR.PROFIL
Sales document item category
  • Client
  • Sales document item category
  • VC_INTEGRATION_VBAP.MANDT == TVPT.MANDT
  • VC_INTEGRATION_VBAP.PSTYV == TVPT.PSTYV
Route
  • Route
  • Client
  • VC_INTEGRATION_VBAP.ROUTE == TVRO.ROUTE
  • VC_INTEGRATION_VBAP.MANDT == TVRO.MANDT
Serial no. profile
  • Client
  • Serial Number Profile
  • VC_INTEGRATION_VBAP.MANDT == T377P.MANDT
  • VC_INTEGRATION_VBAP.SERAIL == T377P.SERAIL
BOM explosion number
  • Client
  • BOM explosion number
  • VC_INTEGRATION_VBAP.MANDT == SNUM.MANDT
  • VC_INTEGRATION_VBAP.SERNR == SNUM.SERNR
Service Document Type
  • Service Document Type
  • Client
Assortment module
  • Client
  • Assortment module
  • VC_INTEGRATION_VBAP.MANDT == WSOH.MANDT
  • VC_INTEGRATION_VBAP.SKOPF == WSOH.SKOPF
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • VC_INTEGRATION_VBAP.SOBKZ == T148.SOBKZ
  • VC_INTEGRATION_VBAP.MANDT == T148.MANDT
Division
  • Division
  • Client
  • VC_INTEGRATION_VBAP.SPART == TSPA.SPART
  • VC_INTEGRATION_VBAP.MANDT == TSPA.MANDT
Reason for material substitution
  • Reason for material substitution
  • Client
  • VC_INTEGRATION_VBAP.SUGRD == TVSU.SUGRD
  • VC_INTEGRATION_VBAP.MANDT == TVSU.MANDT
Material pricing group of main item
  • Material pricing group of main item
  • Client
  • VC_INTEGRATION_VBAP.UKONM == T178.KONDM
  • VC_INTEGRATION_VBAP.MANDT == T178.MANDT
Pricing reference material of main item
  • Client
  • Pricing reference material of main item
  • VC_INTEGRATION_VBAP.MANDT == MARA.MANDT
  • VC_INTEGRATION_VBAP.UPMAT == MARA.MATNR
Usage Indicator
  • Usage Indicator
  • Client
  • VC_INTEGRATION_VBAP.VKAUS == TVLV.ABRVW
  • VC_INTEGRATION_VBAP.MANDT == TVLV.MANDT
Repair Processing: Classification of Items
  • Repair Processing: Classification of Items
  • Client
  • VC_INTEGRATION_VBAP.VKGRU == TVRMAVK.VORGA
  • VC_INTEGRATION_VBAP.MANDT == TVRMAVK.MANDT
Volume unit
  • Client
  • Volume unit
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
  • VC_INTEGRATION_VBAP.VOLEH == T006.MSEHI
Planning material
  • Planning material
  • Client
  • VC_INTEGRATION_VBAP.VPMAT == MARA.MATNR
  • VC_INTEGRATION_VBAP.MANDT == MARA.MANDT
Planning plant
  • Client
  • Planning plant
  • VC_INTEGRATION_VBAP.MANDT == T001W.MANDT
  • VC_INTEGRATION_VBAP.VPWRK == T001W.WERKS
Sales unit
  • Client
  • Sales unit
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
  • VC_INTEGRATION_VBAP.VRKME == T006.MSEHI
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • VC_INTEGRATION_VBAP.MANDT == TVST.MANDT
  • VC_INTEGRATION_VBAP.VSTEL == TVST.VSTEL
SD Document Currency
  • Client
  • SD Document Currency
  • VC_INTEGRATION_VBAP.MANDT == TCURC.MANDT
  • VC_INTEGRATION_VBAP.WAERK == TCURC.WAERS
Annexing package key
  • Annexing package key
  • Extended key for annexing package
  • Client
  • VC_INTEGRATION_VBAP.ZAPCGKI == /ILE/TV01.APCGK
  • VC_INTEGRATION_VBAP.APCGK_EXTENDI == /ILE/TV01.APCGK_EXTEND
  • VC_INTEGRATION_VBAP.MANDT == /ILE/TV01.MANDT
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • VC_INTEGRATION_VBAP.MANDT == T006.MANDT
  • VC_INTEGRATION_VBAP.ZIEME == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Dynamic Item Processor Profile
  • Client
  • ?
  • Dynamic Item Processor Profile
  • VC_INTEGRATION_VBAP.MANDT == AD01C_PROF.MANDT
  • VC_INTEGRATION_VBAP.[column in domain "AD01USAGE"] == AD01C_PROF.DPUS
  • VC_INTEGRATION_VBAP.AD01PROFNR == AD01C_PROF.PROFNR
Interchangeability Code
  • Interchangeability Code
  • Client
  • ?
  • VC_INTEGRATION_VBAP.ADICC == CSPCICC.ADICC
  • VC_INTEGRATION_VBAP.MANDT == CSPCICC.MANDT
  • VC_INTEGRATION_VBAP.[column in domain "SPC2K"] == CSPCICC.SPC2K