A_SalesContractItem

Sales Contract Item | view: ASCITEM | TRAN | Extraction: Not supported | Component: Outline Agreements (Customer)
Tables used: VBAP, VBAK, VBAK, VBAP, VBKD, VEDA
Column Name Description
SalesContract FK Sales Contract
SalesContractItem Sales Contract Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OutlineAgreementTargetAmount Target Value for Outline Agreement in Document Currency
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 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
PricingDate Date for Pricing and Exchange Rate
SalesContractValidityStartDate Contract Start Date
SalesContractValidityEndDate Contract End Date
SalesContractSignedDate Date on Which Contract Is Signed
SlsContractFollowUpActionDate Date for Action
Column Name Description
SDProcessStatus Overall Processing Status (Item) Show values
SalesContractValidityPerdUnit Unit of Validity Period of Contract Show values
Column Name Description Domain name
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesContractItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
MaterialByCustomer Material Number Used by Customer IDNEX
ProductionPlant Plant (Own or External) WERKS
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
ProfitCenter Profit Center PRCTR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
NmbrOfSalesContractValdtyPerd Validity Period of Contract NUM3
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • Plant (Own or External)
  • A_SALESCONTRACTITEM.MATERIAL == MCHA.MATNR
  • A_SALESCONTRACTITEM.BATCH == MCHA.CHARG
  • A_SALESCONTRACTITEM.MANDT == MCHA.MANDT
  • A_SALESCONTRACTITEM.PRODUCTIONPLANT == MCHA.WERKS
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • A_SALESCONTRACTITEM.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESCONTRACTITEM.MANDT == TVKOV.MANDT
  • A_SALESCONTRACTITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_SALESCONTRACTITEM.MANDT == TINC.MANDT
  • A_SALESCONTRACTITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
Billing Block for Item
  • Billing Block for Item
  • Client
  • A_SALESCONTRACTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • A_SALESCONTRACTITEM.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • A_SALESCONTRACTITEM.MANDT == T006.MANDT
  • A_SALESCONTRACTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • A_SALESCONTRACTITEM.MANDT == T006.MANDT
  • A_SALESCONTRACTITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Material Number
  • Client
  • A_SALESCONTRACTITEM.MATERIAL == MARA.MATNR
  • A_SALESCONTRACTITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • A_SALESCONTRACTITEM.MANDT == T023.MANDT
  • A_SALESCONTRACTITEM.MATERIALGROUP == T023.MATKL
Material Price Group
  • Client
  • Material Price Group
  • A_SALESCONTRACTITEM.MANDT == T178.MANDT
  • A_SALESCONTRACTITEM.MATERIALPRICINGGROUP == T178.KONDM
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • A_SALESCONTRACTITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESCONTRACTITEM.SALESORGANIZATION == TVTA.VKORG
  • A_SALESCONTRACTITEM.MANDT == TVTA.MANDT
  • A_SALESCONTRACTITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Action at end of contract
  • Client
  • Action at end of contract
  • A_SALESCONTRACTITEM.MANDT == TVAS.MANDT
  • A_SALESCONTRACTITEM.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
Sales document item category
  • Sales document item category
  • Client
  • A_SALESCONTRACTITEM.SALESCONTRACTITEMCATEGORY == TVPT.PSTYV
  • A_SALESCONTRACTITEM.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • A_SALESCONTRACTITEM.SALESCONTRACTTYPE == TVAK.AUART
  • A_SALESCONTRACTITEM.MANDT == TVAK.MANDT
Validity Period Category of Contract
  • Validity Period Category of Contract
  • Client
  • A_SALESCONTRACTITEM.SALESCONTRACTVALIDITYPERDCAT == TVLZ.VLAUFK
  • A_SALESCONTRACTITEM.MANDT == TVLZ.MANDT
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • A_SALESCONTRACTITEM.MANDT == TVAG.MANDT
  • A_SALESCONTRACTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESCONTRACTITEM.SALESORGANIZATION == TVKO.VKORG
  • A_SALESCONTRACTITEM.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • A_SALESCONTRACTITEM.SHIPPINGPOINT == TVST.VSTEL
  • A_SALESCONTRACTITEM.MANDT == TVST.MANDT
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • A_SALESCONTRACTITEM.MANDT == T001L.MANDT
  • A_SALESCONTRACTITEM.STORAGELOCATION == T001L.LGORT
  • A_SALESCONTRACTITEM.PRODUCTIONPLANT == T001L.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • A_SALESCONTRACTITEM.MANDT == TCURC.MANDT
  • A_SALESCONTRACTITEM.TRANSACTIONCURRENCY == TCURC.WAERS