I_SalesSchedgAgrmtItem

Sales Scheduling Agreement Item | view: ISDSCHEDGAGRMTI | ATTR | Extraction: Not supported | Component: Customer Scheduling Agreement
Tables used: VBAP, VBAK, VBKD, VEDA
Column Name Description
SalesSchedulingAgreement FK Sales Scheduling Agreement
SalesSchedulingAgreementItem Sales Scheduling Agreement Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
BillingDocumentDate Billing Date
Column Name Description
SalesSchedgAgrmtItemType Item Type Show values
QuantityIsFixed Quantity is fixed Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
MaterialByCustomer Material Number Used by Customer IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
Plant Plant (Own or External) WERKS
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProductConfiguration Configuration CUOBJ
BillOfMaterial Bill of Material STNUM
MRPArea MRP Area BERID
SalesSchedgAgrmtItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
UnderlyingPurchaseOrderItem Item Number of the Underlying Purchase Order POSEX
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
ProductTaxClassification3 Tax Classification for Material TAXKD
ProductTaxClassification4 Tax Classification for Material TAXKD
ProductTaxClassification5 Tax Classification for Material TAXKD
ProductTaxClassification6 Tax Classification for Material TAXKD
ProductTaxClassification7 Tax Classification for Material TAXKD
ProductTaxClassification8 Tax Classification for Material TAXKD
ProductTaxClassification9 Tax Classification for Material TAXKD
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
AdditionalValueDays Additional Value Days TAGE2
CustomerPaymentTerms Terms of payment key ZTERM
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVM1.MANDT
  • I_SALESSCHEDGAGRMTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVM2.MANDT
  • I_SALESSCHEDGAGRMTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_SALESSCHEDGAGRMTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • I_SALESSCHEDGAGRMTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVM4.MANDT
Material Group 5
  • Client
  • Material Group 5
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVM5.MANDT
  • I_SALESSCHEDGAGRMTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_SALESSCHEDGAGRMTITEM.BASEUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Material Number
  • Product Number
  • Client
  • Plant (Own or External)
  • I_SALESSCHEDGAGRMTITEM.BATCH == MCHA.CHARG
  • I_SALESSCHEDGAGRMTITEM.MATERIAL == MCHA.MATNR
  • I_SALESSCHEDGAGRMTITEM.PRODUCT == MCHA.MATNR
  • I_SALESSCHEDGAGRMTITEM.MANDT == MCHA.MANDT
  • I_SALESSCHEDGAGRMTITEM.PLANT == MCHA.WERKS
Business Area
  • Business Area
  • Client
  • I_SALESSCHEDGAGRMTITEM.BUSINESSAREA == TGSB.GSBER
  • I_SALESSCHEDGAGRMTITEM.MANDT == TGSB.MANDT
Customer Group
  • Customer Group
  • Client
  • I_SALESSCHEDGAGRMTITEM.CUSTOMERGROUP == T151.KDGRP
  • I_SALESSCHEDGAGRMTITEM.MANDT == T151.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_SALESSCHEDGAGRMTITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SALESSCHEDGAGRMTITEM.MANDT == TPRIO.MANDT
Division
  • Client
  • Division
  • I_SALESSCHEDGAGRMTITEM.MANDT == TSPA.MANDT
  • I_SALESSCHEDGAGRMTITEM.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SALESSCHEDGAGRMTITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SALESSCHEDGAGRMTITEM.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SALESSCHEDGAGRMTITEM.INCOTERMSVERSION == TINCV.INCOV
  • I_SALESSCHEDGAGRMTITEM.MANDT == TINCV.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_SALESSCHEDGAGRMTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • I_SALESSCHEDGAGRMTITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • I_SALESSCHEDGAGRMTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIAL == MARA.MATNR
  • I_SALESSCHEDGAGRMTITEM.PRODUCT == MARA.MATNR
  • I_SALESSCHEDGAGRMTITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Product Group
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIALGROUP == T023.MATKL
  • I_SALESSCHEDGAGRMTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESSCHEDGAGRMTITEM.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • I_SALESSCHEDGAGRMTITEM.MANDT == T178.MANDT
Reason for material substitution
  • Reason for material substitution
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVSU.MANDT
Condition Unit
  • Condition Unit
  • Client
  • I_SALESSCHEDGAGRMTITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Order Number
  • Order Number
  • Client
  • I_SALESSCHEDGAGRMTITEM.ORDERID == AUFK.AUFNR
  • I_SALESSCHEDGAGRMTITEM.MANDT == AUFK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_SALESSCHEDGAGRMTITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Material Entered
  • Material Entered
  • Client
  • I_SALESSCHEDGAGRMTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • I_SALESSCHEDGAGRMTITEM.MANDT == MARA.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • I_SALESSCHEDGAGRMTITEM.[column in domain "LAND1"] == T042Z.LAND1
  • I_SALESSCHEDGAGRMTITEM.MANDT == T042Z.MANDT
  • I_SALESSCHEDGAGRMTITEM.PAYMENTMETHOD == T042Z.ZLSCH
Instruction for Planning Delivery Schedule
  • Instruction for Planning Delivery Schedule
  • Client
  • I_SALESSCHEDGAGRMTITEM.PLNGDELIVSCHEDINSTRN == TVZP.PLAVO
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVZP.MANDT
Checking Group for Availability Check
  • Client
  • Checking Group for Availability Check
  • I_SALESSCHEDGAGRMTITEM.MANDT == TMVF.MANDT
  • I_SALESSCHEDGAGRMTITEM.PRODAVAILABILITYCHECKGROUP == TMVF.MTVFP
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIAL == MARA.MATNR
  • I_SALESSCHEDGAGRMTITEM.PRODUCT == MARA.MATNR
  • I_SALESSCHEDGAGRMTITEM.MANDT == MARA.MANDT
Product Group
  • Material Group
  • Product Group
  • Client
  • I_SALESSCHEDGAGRMTITEM.MATERIALGROUP == T023.MATKL
  • I_SALESSCHEDGAGRMTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESSCHEDGAGRMTITEM.MANDT == T023.MANDT
Route
  • Route
  • Client
  • I_SALESSCHEDGAGRMTITEM.ROUTE == TVRO.ROUTE
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVRO.MANDT
Sales District
  • Sales District
  • Client
  • I_SALESSCHEDGAGRMTITEM.SALESDISTRICT == T171.BZIRK
  • I_SALESSCHEDGAGRMTITEM.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_SALESSCHEDGAGRMTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVAG.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_SALESSCHEDGAGRMTITEM.SALESSCHEDGAGRMTITEMCATEGORY == TVPT.PSTYV
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVPT.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SALESSCHEDGAGRMTITEM.SHIPPINGPOINT == TVST.VSTEL
  • I_SALESSCHEDGAGRMTITEM.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • I_SALESSCHEDGAGRMTITEM.SHIPPINGTYPE == T173.VSART
  • I_SALESSCHEDGAGRMTITEM.MANDT == T173.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • I_SALESSCHEDGAGRMTITEM.STORAGELOCATION == T001L.LGORT
  • I_SALESSCHEDGAGRMTITEM.MANDT == T001L.MANDT
  • I_SALESSCHEDGAGRMTITEM.PLANT == T001L.WERKS
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • I_SALESSCHEDGAGRMTITEM.TARGETQUANTITYUNIT == T006.MSEHI
  • I_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESSCHEDGAGRMTITEM.MANDT == TCURC.MANDT
  • I_SALESSCHEDGAGRMTITEM.TRANSACTIONCURRENCY == TCURC.WAERS