I_SalesContractItem

Sales Contract Item | view: ISDSLSCONTRITEM | ATTR | Extraction: Not supported | Component: Customer Contract
Tables used: VBAP, 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
NetPriceAmount Net Price
TaxAmount Tax Amount in Document Currency
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
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Base Unit of Measure (BaseUnit):
RequestedQuantityInBaseUnit Requested Order 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
ServicesRenderedDate Date on which services are rendered
SalesContractValidityStartDate Contract Start Date
SalesContractValidityEndDate Contract End Date
SalesContractSignedDate Date on Which Contract Is Signed
EquipmentInstallationDate Installation Date
EquipmentDeliveryAccptcDate Agreement Acceptance Date
EquipmentDismantlingDate Dismantling Date
RequestedCancellationDate Requested Cancellation Date
SlsContractCanclnReqRcptDate Date on Which Cancellation Request Was Received
ContractPartnerCanclnDocDate Date of Cancellation Document from Contract Partner
SlsContractFollowUpActionDate Date for Action
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
SalesDocumentItemType Item Type Show values
IsReturnsItem Returns Item Show values
CompletionRule Completion Rule for Quotation / Contract Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
SalesContractValidityPerdUnit Unit of Validity Period of Contract Show values
SalesContractCanclnParty Cancellation Party Show values
SalesDocumentItemProcgCode Item Processing Code Show values
StatisticalValueControl Statistical Values Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDProcessStatus Overall Processing Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
ContractItemDownPaymentStatus Down Payment Status 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
ProductConfiguration Configuration CUOBJ
SalesContractItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
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
NmbrOfSalesContractValdtyPerd Validity Period of Contract NUM3
CanclnDocByContrPartner Cancellation Document Number of Contract Partner CHAR20
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
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
AdditionalValueDays Additional Value Days TAGE2
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
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • I_SALESCONTRACTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_SALESCONTRACTITEM.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • I_SALESCONTRACTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • I_SALESCONTRACTITEM.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • I_SALESCONTRACTITEM.MANDT == TVM3.MANDT
  • I_SALESCONTRACTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_SALESCONTRACTITEM.MANDT == TVM4.MANDT
  • I_SALESCONTRACTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_SALESCONTRACTITEM.MANDT == TVM5.MANDT
  • I_SALESCONTRACTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Product Number
  • Material Number
  • Client
  • Plant (Own or External)
  • I_SALESCONTRACTITEM.BATCH == MCHA.CHARG
  • I_SALESCONTRACTITEM.PRODUCT == MCHA.MATNR
  • I_SALESCONTRACTITEM.MATERIAL == MCHA.MATNR
  • I_SALESCONTRACTITEM.MANDT == MCHA.MANDT
  • I_SALESCONTRACTITEM.PLANT == MCHA.WERKS
Business Area
  • Client
  • Business Area
  • I_SALESCONTRACTITEM.MANDT == TGSB.MANDT
  • I_SALESCONTRACTITEM.BUSINESSAREA == TGSB.GSBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • I_SALESCONTRACTITEM.MANDT == TVKT.MANDT
  • I_SALESCONTRACTITEM.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Customer Group
  • Client
  • I_SALESCONTRACTITEM.CUSTOMERGROUP == T151.KDGRP
  • I_SALESCONTRACTITEM.MANDT == T151.MANDT
Division
  • Client
  • Division
  • I_SALESCONTRACTITEM.MANDT == TSPA.MANDT
  • I_SALESCONTRACTITEM.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SALESCONTRACTITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SALESCONTRACTITEM.MANDT == TINC.MANDT
Incoterms Version
  • Client
  • Incoterms Version
  • I_SALESCONTRACTITEM.MANDT == TINCV.MANDT
  • I_SALESCONTRACTITEM.INCOTERMSVERSION == TINCV.INCOV
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_SALESCONTRACTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SALESCONTRACTITEM.MANDT == TVFS.MANDT
Volume unit
  • Client
  • Volume unit
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Product Number
  • Material Number
  • Client
  • I_SALESCONTRACTITEM.PRODUCT == MARA.MATNR
  • I_SALESCONTRACTITEM.MATERIAL == MARA.MATNR
  • I_SALESCONTRACTITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Product Group
  • Material Group
  • I_SALESCONTRACTITEM.MANDT == T023.MANDT
  • I_SALESCONTRACTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESCONTRACTITEM.MATERIALGROUP == T023.MATKL
Material Price Group
  • Material Price Group
  • Client
  • I_SALESCONTRACTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • I_SALESCONTRACTITEM.MANDT == T178.MANDT
Reason for material substitution
  • Reason for material substitution
  • Client
  • I_SALESCONTRACTITEM.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • I_SALESCONTRACTITEM.MANDT == TVSU.MANDT
Condition Unit
  • Client
  • Condition Unit
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
Order Number
  • Client
  • Order Number
  • I_SALESCONTRACTITEM.MANDT == AUFK.MANDT
  • I_SALESCONTRACTITEM.ORDERID == AUFK.AUFNR
Sales unit
  • Client
  • Sales unit
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.ORDERQUANTITYUNIT == T006.MSEHI
Material Entered
  • Client
  • Material Entered
  • I_SALESCONTRACTITEM.MANDT == MARA.MANDT
  • I_SALESCONTRACTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • Client
  • ?
  • Payment Method
  • I_SALESCONTRACTITEM.MANDT == T042Z.MANDT
  • I_SALESCONTRACTITEM.[column in domain "LAND1"] == T042Z.LAND1
  • I_SALESCONTRACTITEM.PAYMENTMETHOD == T042Z.ZLSCH
Material: order item
  • Product Number
  • Material Number
  • Client
  • I_SALESCONTRACTITEM.PRODUCT == MARA.MATNR
  • I_SALESCONTRACTITEM.MATERIAL == MARA.MATNR
  • I_SALESCONTRACTITEM.MANDT == MARA.MANDT
Product Catalog
  • Client
  • Product catalog number
  • I_SALESCONTRACTITEM.MANDT == WWMI.MANDT
  • I_SALESCONTRACTITEM.PRODUCTCATALOG == WWMI.WMINR
Product Group
  • Client
  • Product Group
  • Material Group
  • I_SALESCONTRACTITEM.MANDT == T023.MANDT
  • I_SALESCONTRACTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESCONTRACTITEM.MATERIALGROUP == T023.MATKL
Product hierarchy: order item
  • Client
  • Product hierarchy
  • I_SALESCONTRACTITEM.MANDT == T179.MANDT
  • I_SALESCONTRACTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
Retail promotion
  • Client
  • Promotion
  • I_SALESCONTRACTITEM.MANDT == WAKH.MANDT
  • I_SALESCONTRACTITEM.RETAILPROMOTION == WAKH.AKTNR
Assignment Cancellation Procedure/Cancellation Rule
  • Client
  • Assignment Cancellation Procedure/Cancellation Rule
  • I_SALESCONTRACTITEM.MANDT == TVKS.MANDT
  • I_SALESCONTRACTITEM.SALESCONTRACTCANCLNPROCEDURE == TVKS.VKUESCH
Reason for Cancellation of Contract
  • Reason for Cancellation of Contract
  • Client
  • I_SALESCONTRACTITEM.SALESCONTRACTCANCLNREASON == TVKG.KUEGRU
  • I_SALESCONTRACTITEM.MANDT == TVKG.MANDT
Action at end of contract
  • Action at end of contract
  • Client
  • I_SALESCONTRACTITEM.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
  • I_SALESCONTRACTITEM.MANDT == TVAS.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_SALESCONTRACTITEM.SALESCONTRACTITEMCATEGORY == TVPT.PSTYV
  • I_SALESCONTRACTITEM.MANDT == TVPT.MANDT
Validity Period Category of Contract
  • Client
  • Validity Period Category of Contract
  • I_SALESCONTRACTITEM.MANDT == TVLZ.MANDT
  • I_SALESCONTRACTITEM.SALESCONTRACTVALIDITYPERDCAT == TVLZ.VLAUFK
Sales Deal
  • Client
  • Sales Deal
  • I_SALESCONTRACTITEM.MANDT == KONA.MANDT
  • I_SALESCONTRACTITEM.SALESDEAL == KONA.KNUMA
Sales District
  • Client
  • Sales District
  • I_SALESCONTRACTITEM.MANDT == T171.MANDT
  • I_SALESCONTRACTITEM.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_SALESCONTRACTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_SALESCONTRACTITEM.MANDT == TVAG.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • I_SALESCONTRACTITEM.SALESPROMOTION == KONA.KNUMA
  • I_SALESCONTRACTITEM.MANDT == KONA.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_SALESCONTRACTITEM.MANDT == TVST.MANDT
  • I_SALESCONTRACTITEM.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • I_SALESCONTRACTITEM.MANDT == T001L.MANDT
  • I_SALESCONTRACTITEM.STORAGELOCATION == T001L.LGORT
  • I_SALESCONTRACTITEM.PLANT == T001L.WERKS
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • I_SALESCONTRACTITEM.MANDT == T006.MANDT
  • I_SALESCONTRACTITEM.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESCONTRACTITEM.MANDT == TCURC.MANDT
  • I_SALESCONTRACTITEM.TRANSACTIONCURRENCY == TCURC.WAERS