VBAP

Sales Document: Item Data | #itemdata | Component: Sales
Column Name Description
MANDT FK Client
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
LMD_SCHEDULED_DELIVERY_DATE Last Mile Distribution Scheduled Delivery Date
AUDAT_ANA Document Date (Date Received/Sent)
VDATU_ANA Requested Delivery Date
FKDAT_ANA Billing Date
/DMBE/PAYMENTDEEMED Deemed Payment Date
/DMBE/EFFECTIVEDATEFROM Effective From
/DMBE/EFFECTIVEDATETO Effective To
/DMBE/POSTEDDATE Posted Date of a Deal
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
FREEZE_PAOBJNR Profitability Segment Is Dependent on Preceding Document 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
DELIV_RELTD_BILLG_STA Delivery-Related Billing Status (Item) Show values
LGLC_LIC_IND Legal Control License Indicator Show values
DELIVERY_DATE_TYPE_RULE Delivery Date Rule 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
VBTYP_ANA SD Document Category Show values
/DMBE/ITEM_TYPE Item Type Show values
/DMBE/DEAL_POSTED Deal is Posted 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
SUBSTN_NUMERATOR Quantity Conversion: Numerator
SUBSTN_DENOMINATOR Quantity Conversion: Denominator
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
RESOURCE_ID Resource Name (Stock Identifier) NSDM_RESOURCENAME
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
ERNAM Name of Person Responsible for Creating the Object USNAM
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
BOB_FG_ID Free Goods ID of Omnichannel Sales Promotions DOM_BOB_FG_ID
BOB_PROMOTION_ID ID for Omnichannel Sales Promotion DOM_BOB_PROMOTION_ID
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
TRANSIT_PLANT Transit Plant WERKS
VCM_CHAIN_UUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
VCM_CHAIN_CATEGORY Value Chain Category VCM_CHAIN_CATEGORY
REASON_CODE Reason for Return or Expected Delivery Quantity Change SD_ITEM_REASON_CODE
DUMMY_SLSDOCITEM_INCL_EEW_PS Dummy function in length 1 DUMMY
MILL_SE_GPOSN Global Item POSNR
AUART_ANA Sales Document Type AUART
VKORG_ANA Sales Organization VKORG
VTWEG_ANA Distribution Channel VTWEG
SPART_ANA Division SPART
VKBUR_ANA Sales office VKBUR
VKGRP_ANA Sales group VKGRP
AUGRU_ANA Order Reason (Reason for the Business Transaction) AUGRU
KVGR1_ANA Customer Group 1 KVGR1
KVGR2_ANA Customer Group 2 KVGR2
KVGR3_ANA Customer Group 3 KVGR3
KVGR4_ANA Customer Group 4 KVGR4
KVGR5_ANA Customer Group 5 KVGR5
VSBED_ANA Shipping Conditions VSBED
KUNNR_ANA Sold-to Party KUNNR
KNUMV_ANA Number of the Document Condition KNUMV
BSTKD_ANA Customer Reference BSTKD
KUNWE_ANA Ship-to Party KUNNR
KUNRE_ANA Bill-to Party KUNNR
PERVE_ANA Sales Employee PERNR
PERZM_ANA Employee Responsible PERNR
KUNRG_ANA Payer KUNNR
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order CRM_OBJECT_ID
SOLUTION_ORDER_ITM_ID Solution Order Item CRMS4_NUMBER_INT
GLO_LOG_REF1_IT Commodity Code for Poland GLO_LOG_REF1_IT
TXS_BUSINESS_TRANSACTION Tax Service Business Transaction TXS_BUSINESS_TRANSACTION
TXS_MATERIAL_USAGE Tax Service Material Usage
TXS_USAGE_PURPOSE Tax Service Usage Purpose TXS_USAGE_PURPOSE
CPD_UPDAT Time Stamp /CPD/PFP_SC_TSTMP
/DMBE/OPTIONALITYKEY Detail Number /DMBE/DM_OPTIONALITY_KEY
/DMBE/OPTIONALITYFOR Optionality For /DMBE/DM_OPTIONALITY_KEY
/DMBE/CIMAX2 Maximum Carbon Intensity Value /DMBE/DR_MAX_CI_VAL
/DMBE/OPTIONOF Option of SD Item POSNR
/DMBE/ACCOUNTING_TYPE Detail Accounting Type /DMBE/DM_ACCOUNT_TYPE
/DMBE/FAS_CODE Financial Accounting Standards Code /DMBE/DM_FAS_CODE
/DMBE/SCHEDULING_DESK Scheduling Desk /DMBE/DM_SCHEDULERS_DESK
/DMBE/COMPONENTFOR Mixed Product Main Detail Number /DMBE/DM_COMPONENT_FOR
/DMBE/MIXEDPRODUCT Product MATNR
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
ASSIGNMENT_PRIORITY ARun Demand Priority VBELN
ARUN_GROUP_PRIO ARun Demand Group Priority VBELN
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
KOSTL Cost Center KOSTL
FONDS Fund BP_GEBER
FISTL Funds Center FISTL
FKBER Functional Area FKBER
GRANT_NBR Grant GM_GRANT_NBR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
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
TAS Treasury Account Symbol CHAR30
BETC Business Event Type Code CHAR10
MOD_ALLOW Modification Allowed CHAR1
CANCEL_ALLOW Cancellation Allowed CHAR1
PAY_METHOD List of Respected Payment Methods ZWELS
REP_FREQ Reporting Frequency CHAR3
FMFGUS_KEY United States Federal Government Fields SYSUUID_22
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
VLCENDCU End Customer (Central Business Partner) BU_PARTNER
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
  • VBAP.ABFOR == T691K.ABSFO
  • VBAP.MANDT == T691K.MANDT
Results Analysis Key
  • VBAP.MANDT == TKKAA.MANDT
  • VBAP.ABGRS == TKKAA.ABGSL
Reason for Rejection of Sales Documents
  • VBAP.MANDT == TVAG.MANDT
  • VBAP.ABGRU == TVAG.ABGRU
Model ID Code
  • Model ID Code
  • Client
Order Priority
Order Number
  • Order Number
  • Client
  • VBAP.AUFNR == AUFK.AUFNR
  • VBAP.MANDT == AUFK.MANDT
Requirements type
  • VBAP.MANDT == T459A.MANDT
  • VBAP.BEDAE == T459A.BEDAE
Volume rebate group
  • Volume rebate group
  • Client
  • VBAP.BONUS == TVBO.BONUS
  • VBAP.MANDT == TVBO.MANDT
Business Partner Number
  • VBAP.MANDT == T880.MANDT
  • VBAP.BPN == T880.RCOMP
Valuation Type
  • VBAP.MANDT == T149D.MANDT
  • VBAP.BWTAR == T149D.BWTAR
Sales District
  • VBAP.MANDT == T171.MANDT
  • VBAP.BZIRK_ANA == T171.BZIRK
Batch Number
  • Material Number
  • Batch Number
  • Plant (Own or External)
  • VBAP.MANDT == MCHA.MANDT
  • VBAP.MATNR == MCHA.MATNR
  • VBAP.CHARG == MCHA.CHARG
  • VBAP.WERKS == MCHA.WERKS
Internal Class Number
  • VBAP.MANDT == KLAH.MANDT
  • VBAP.CLINT == KLAH.CLINT
Equipment Type
  • VBAP.MANDT == T370K.MANDT
  • VBAP.EQART == T370K.EQART
Equipment Number
  • Equipment Number
  • Client
  • VBAP.EQUNR == EQUI.EQUNR
  • VBAP.MANDT == EQUI.MANDT
Billing Block for Item
  • VBAP.MANDT == TVFS.MANDT
  • VBAP.FAKSP == TVFS.FAKSP
Regulatory indicator
  • Regulatory indicator
  • Client
Fashion Collection
  • Season Year
  • Season
  • Client
  • Fashion Collection
Season
  • Season Year
  • Season
Season Year
  • Season Year
  • Season
Fashion Theme
  • Season
  • Fashion Collection
  • Fashion Theme
  • Client
  • Season Year
Weight Unit
  • VBAP.MANDT == T006.MANDT
  • VBAP.GEWEI == T006.MSEHI
Business Area
  • VBAP.MANDT == TGSB.MANDT
  • VBAP.GSBER == TGSB.GSBER
Foreign key for movement key
  • CFOP Code and Extension
  • Client
Foreign key for Brazilian tax ICMS
Foreign key for Brazilian tax IPI
Foreign Key for Brazilian Tax ISS
  • ISS Tax Law
  • Client
Foreign Key for Brazilian Tax COFINS
Foreign Key for Brazilian Tax PIS
Foreign key for SD tax code
Activity Type
  • Activity Type
  • Client
Costing Sheet
  • ?
  • Costing Sheet
  • ?
  • VBAP.MANDT == T683.MANDT
  • VBAP.[column in domain "KAPPL"] == T683.KAPPL
  • VBAP.KALSM_K == T683.KALSM
  • VBAP.[column in domain "KVEWE"] == T683.KVEWE
Costing Variant
  • VBAP.MANDT == TCK03.MANDT
  • VBAP.KALVAR == TCK03.KLVAR
Customer Group
  • Customer Group
  • Client
  • VBAP.KDGRP_ANA == T151.KDGRP
  • VBAP.MANDT == T151.MANDT
Condition Unit
  • VBAP.MANDT == T006.MANDT
  • VBAP.KMEIN == T006.MSEHI
Account Assignment Category
  • VBAP.MANDT == T163K.MANDT
  • VBAP.KNTTP == T163K.KNTTP
Sales Deal
  • Sales Deal
  • Client
  • VBAP.KNUMA_AG == KONA.KNUMA
  • VBAP.MANDT == KONA.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • VBAP.KNUMA_PI == KONA.KNUMA
  • VBAP.MANDT == KONA.MANDT
Material Price Group
  • VBAP.MANDT == T178.MANDT
  • VBAP.KONDM == T178.KONDM
Product allocation determination procedure
  • VBAP.MANDT == T190S.MANDT
  • VBAP.KOSCH == T190S.KOSCH
Account Assignment Group for Material
  • VBAP.MANDT == TVKM.MANDT
  • VBAP.KTGRM == TVKM.KTGRM
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • VBAP.LGORT == T001L.LGORT
  • VBAP.MANDT == T001L.MANDT
  • VBAP.WERKS == T001L.WERKS
Delivery Priority
  • VBAP.MANDT == TPRIO.MANDT
  • VBAP.LPRIO == TPRIO.LPRIO
Material Group: Packaging Materials
  • VBAP.MANDT == TVEGR.MANDT
  • VBAP.MAGRV == TVEGR.MAGRV
Client VBAP.MANDT == T000.MANDT
Material Group
  • VBAP.MANDT == T023.MANDT
  • VBAP.MATKL == T023.MATKL
Material: order item
  • Material Number
  • Client
  • VBAP.MATNR == MARA.MATNR
  • VBAP.MANDT == MARA.MANDT
Material Entered
  • Material Entered
  • Client
  • VBAP.MATWA == MARA.MATNR
  • VBAP.MANDT == MARA.MANDT
Base Unit of Measure
  • VBAP.MANDT == T006.MANDT
  • VBAP.MEINS == T006.MSEHI
Foreign key for material freight group
  • Material freight group
  • Client
  • VBAP.MFRGR == TMFG.MFRGR
  • VBAP.MANDT == TMFG.MANDT
Returns Refund Code
Return Reason
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • VBAP.MTVFP == TMVF.MTVFP
  • VBAP.MANDT == TMVF.MANDT
Material Group 1
  • Material Group 1
  • Client
  • VBAP.MVGR1 == TVM1.MVGR1
  • VBAP.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • VBAP.MVGR2 == TVM2.MVGR2
  • VBAP.MANDT == TVM2.MANDT
Material Group 3
  • VBAP.MANDT == TVM3.MANDT
  • VBAP.MVGR3 == TVM3.MVGR3
Material Group 4
  • VBAP.MANDT == TVM4.MANDT
  • VBAP.MVGR4 == TVM4.MVGR4
Material Group 5
  • VBAP.MANDT == TVM5.MANDT
  • VBAP.MVGR5 == TVM5.MVGR5
Instruction for Planning Delivery Schedule
  • VBAP.MANDT == TVZP.MANDT
  • VBAP.PLAVO == TVZP.PLAVO
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • VBAP.PMATN == MARA.MATNR
  • VBAP.MANDT == MARA.MANDT
Base unit of measure for product group
  • VBAP.MANDT == T006.MANDT
  • VBAP.PRBME == T006.MSEHI
Product hierarchy: order item
  • Product hierarchy
  • Client
  • VBAP.PRODH == T179.PRODH
  • VBAP.MANDT == T179.MANDT
Commission Group
  • Commission Group
  • Client
  • VBAP.PROVG == TVPR.PROVG
  • VBAP.MANDT == TVPR.MANDT
Profile for Comparison of JIT Del.Sched. with JIT Del.Sched.
Profile for Comp. of JIT Del.Sched. with Forecast Del.Sched.
Profile for Comparison of Frcst.DelSched with Frcst.DelSched
Sales document item category
  • Sales document item category
  • Client
  • VBAP.PSTYV == TVPT.PSTYV
  • VBAP.MANDT == TVPT.MANDT
Route
  • VBAP.MANDT == TVRO.MANDT
  • VBAP.ROUTE == TVRO.ROUTE
Serial no. profile
  • VBAP.MANDT == T377P.MANDT
  • VBAP.SERAIL == T377P.SERAIL
BOM explosion number
  • BOM explosion number
  • Client
  • VBAP.SERNR == SNUM.SERNR
  • VBAP.MANDT == SNUM.MANDT
Service Document Type
Assortment module
  • VBAP.MANDT == WSOH.MANDT
  • VBAP.SKOPF == WSOH.SKOPF
Special Stock Indicator
  • VBAP.MANDT == T148.MANDT
  • VBAP.SOBKZ == T148.SOBKZ
Division
  • VBAP.MANDT == TSPA.MANDT
  • VBAP.SPART == TSPA.SPART
Reason for material substitution
  • Reason for material substitution
  • Client
  • VBAP.SUGRD == TVSU.SUGRD
  • VBAP.MANDT == TVSU.MANDT
Material pricing group of main item
  • VBAP.MANDT == T178.MANDT
  • VBAP.UKONM == T178.KONDM
Pricing reference material of main item
  • Pricing reference material of main item
  • Client
  • VBAP.UPMAT == MARA.MATNR
  • VBAP.MANDT == MARA.MANDT
Usage Indicator
  • Usage Indicator
  • Client
  • VBAP.VKAUS == TVLV.ABRVW
  • VBAP.MANDT == TVLV.MANDT
Repair Processing: Classification of Items
Volume unit
  • VBAP.MANDT == T006.MANDT
  • VBAP.VOLEH == T006.MSEHI
Planning material
  • Planning material
  • Client
  • VBAP.VPMAT == MARA.MATNR
  • VBAP.MANDT == MARA.MANDT
Planning plant
  • VBAP.MANDT == T001W.MANDT
  • VBAP.VPWRK == T001W.WERKS
Sales unit
  • VBAP.MANDT == T006.MANDT
  • VBAP.VRKME == T006.MSEHI
Shipping Type
  • Shipping Type
  • Client
  • VBAP.VSART_ANA == T173.VSART
  • VBAP.MANDT == T173.MANDT
Shipping Point / Receiving Point
  • VBAP.MANDT == TVST.MANDT
  • VBAP.VSTEL == TVST.VSTEL
SD Document Currency
  • VBAP.MANDT == TCURC.MANDT
  • VBAP.WAERK == TCURC.WAERS
Annexing package key
  • Annexing package key
  • Extended key for annexing package
Target Quantity UoM
  • VBAP.MANDT == T006.MANDT
  • VBAP.ZIEME == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Dynamic Item Processor Profile
  • ?
  • Client
  • Dynamic Item Processor Profile
Interchangeability Code
  • Interchangeability Code
  • ?
  • VBAP.MANDT == CSPCICC.MANDT
  • VBAP.ADICC == CSPCICC.ADICC
  • VBAP.[column in domain "SPC2K"] == CSPCICC.SPC2K