A_SalesSchedgAgrmtItem

Sales Scheduling Agreement Item | view: ASDSCHEDGAGRMTI | TRAN | Extraction: Not supported | Component: Customer Scheduling Agreement
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, 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
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
LastChangeDate Last Changed On
PricingDate Date for Pricing and Exchange Rate
Column Name Description
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
Column Name Description Domain name
MaterialByCustomer Material Number Used by Customer IDNEX
ProductionPlant Plant (Own or External) WERKS
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
NetPriceQuantity Condition Pricing Unit KPEIN
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
Master Data Relations Join Conditions
Delivery Priority
  • Delivery Priority
  • Client
  • A_SALESSCHEDGAGRMTITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • A_SALESSCHEDGAGRMTITEM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • A_SALESSCHEDGAGRMTITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESSCHEDGAGRMTITEM.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVKOV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_SALESSCHEDGAGRMTITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_SALESSCHEDGAGRMTITEM.MANDT == TINC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • A_SALESSCHEDGAGRMTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Client
  • A_SALESSCHEDGAGRMTITEM.MATERIAL == MARA.MATNR
  • A_SALESSCHEDGAGRMTITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • A_SALESSCHEDGAGRMTITEM.MATERIALGROUP == T023.MATKL
  • A_SALESSCHEDGAGRMTITEM.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • A_SALESSCHEDGAGRMTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • A_SALESSCHEDGAGRMTITEM.MANDT == T178.MANDT
Condition Unit
  • Condition Unit
  • Client
  • A_SALESSCHEDGAGRMTITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
  • A_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • A_SALESSCHEDGAGRMTITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • A_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • A_SALESSCHEDGAGRMTITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESSCHEDGAGRMTITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESSCHEDGAGRMTITEM.SALESORGANIZATION == TVTA.VKORG
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVTA.MANDT
Material Entered
  • Material Entered
  • Client
  • A_SALESSCHEDGAGRMTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • A_SALESSCHEDGAGRMTITEM.MANDT == MARA.MANDT
Instruction for Planning Delivery Schedule
  • Client
  • Instruction for Planning Delivery Schedule
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVZP.MANDT
  • A_SALESSCHEDGAGRMTITEM.PLNGDELIVSCHEDINSTRN == TVZP.PLAVO
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • A_SALESSCHEDGAGRMTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVAG.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESSCHEDGAGRMTITEM.SALESORGANIZATION == TVKO.VKORG
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVKO.MANDT
Sales document item category
  • Sales document item category
  • Client
  • A_SALESSCHEDGAGRMTITEM.SALESSCHEDGAGRMTITEMCATEGORY == TVPT.PSTYV
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVPT.MANDT
Order type in order header
  • Sales Scheduling Agreement Type
  • Client
  • A_SALESSCHEDGAGRMTITEM.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVAK.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • A_SALESSCHEDGAGRMTITEM.SHIPPINGPOINT == TVST.VSTEL
  • A_SALESSCHEDGAGRMTITEM.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • A_SALESSCHEDGAGRMTITEM.SHIPPINGTYPE == T173.VSART
  • A_SALESSCHEDGAGRMTITEM.MANDT == T173.MANDT
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • A_SALESSCHEDGAGRMTITEM.PRODUCTIONPLANT == T001L.WERKS
  • A_SALESSCHEDGAGRMTITEM.STORAGELOCATION == T001L.LGORT
  • A_SALESSCHEDGAGRMTITEM.MANDT == T001L.MANDT
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • A_SALESSCHEDGAGRMTITEM.MANDT == T006.MANDT
  • A_SALESSCHEDGAGRMTITEM.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • SD Document Currency
  • Client
  • A_SALESSCHEDGAGRMTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_SALESSCHEDGAGRMTITEM.MANDT == TCURC.MANDT