I_SalesContractItemCube

Sales Contract Item - Cube | view: ISDSLSCONTRITMC | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, TVKO
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
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
SalesContractTargetValue Sales Contract Target Value
SalesContractTargetAmount Sales Contract Target Value
IncomingSlsContractNetAmount Incoming Sales Contracts Net Value in Transaction Currency
SalesContractReleasedAmount Released Value in Sales Contracts in Transaction Currency
💲 Display Currency (DisplayCurrency):
SalesContractTargetValueInDC Target Value of Sales Contracts in Display Currency
SalesContractTargetAmountInDC Target Value of Sales Contracts in Display Currency
IncomingSlsContractNetAmtInDC Incoming Sales Contracts Net Value in Display Currency
SalesContractReleasedAmtInDC Released Value in Sales Contracts in Display Currency
Column Name Description
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
📏 Base Unit of Measure (BaseUnit):
SalesContractTargetQuantity Target Quantity of Sales Contract Items
IncomingSlsContractQuantity Quantity of Incoming Sales Contract Items
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesContractDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
ContractPartnerCanclnDocDate Date of Cancellation Document from Contract Partner
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
SalesContractItemType Item Type Show values
SalesContractCanclnParty Cancellation Party Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block 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
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
Column Name Description Domain name
SalesContractType Sales Document Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
PurchaseOrderByCustomer Customer Reference BSTKD
SalesContractItemText Short text for sales order item TEXT40
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_SALESCONTRACTITEMCUBE.MANDT == TVM1.MANDT
  • I_SALESCONTRACTITEMCUBE.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_SALESCONTRACTITEMCUBE.MANDT == TVM2.MANDT
  • I_SALESCONTRACTITEMCUBE.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_SALESCONTRACTITEMCUBE.MANDT == TVM3.MANDT
  • I_SALESCONTRACTITEMCUBE.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_SALESCONTRACTITEMCUBE.MANDT == TVM4.MANDT
  • I_SALESCONTRACTITEMCUBE.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_SALESCONTRACTITEMCUBE.MANDT == TVM5.MANDT
  • I_SALESCONTRACTITEMCUBE.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESCONTRACTITEMCUBE.MANDT == T006.MANDT
  • I_SALESCONTRACTITEMCUBE.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SALESCONTRACTITEMCUBE.MANDT == T001.MANDT
  • I_SALESCONTRACTITEMCUBE.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Business Area
  • Client
  • I_SALESCONTRACTITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • I_SALESCONTRACTITEMCUBE.MANDT == TGSB.MANDT
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • I_SALESCONTRACTITEMCUBE.MANDT == TVKT.MANDT
  • I_SALESCONTRACTITEMCUBE.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Client
  • Customer Group
  • I_SALESCONTRACTITEMCUBE.MANDT == T151.MANDT
  • I_SALESCONTRACTITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Division
  • Client
  • Division
  • I_SALESCONTRACTITEMCUBE.MANDT == TSPA.MANDT
  • I_SALESCONTRACTITEMCUBE.DIVISION == TSPA.SPART
Billing Block for Item
  • Client
  • Billing Block for Item
  • I_SALESCONTRACTITEMCUBE.MANDT == TVFS.MANDT
  • I_SALESCONTRACTITEMCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Volume unit
  • Client
  • Volume unit
  • I_SALESCONTRACTITEMCUBE.MANDT == T006.MANDT
  • I_SALESCONTRACTITEMCUBE.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_SALESCONTRACTITEMCUBE.ITEMWEIGHTUNIT == T006.MSEHI
  • I_SALESCONTRACTITEMCUBE.MANDT == T006.MANDT
Material: order item
  • Client
  • Product Number
  • Material Number
  • I_SALESCONTRACTITEMCUBE.MANDT == MARA.MANDT
  • I_SALESCONTRACTITEMCUBE.PRODUCT == MARA.MATNR
  • I_SALESCONTRACTITEMCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Product Group
  • I_SALESCONTRACTITEMCUBE.MANDT == T023.MANDT
  • I_SALESCONTRACTITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_SALESCONTRACTITEMCUBE.PRODUCTGROUP == T023.MATKL
Payment Method
  • Client
  • Payment Method
  • ?
  • I_SALESCONTRACTITEMCUBE.MANDT == T042Z.MANDT
  • I_SALESCONTRACTITEMCUBE.PAYMENTMETHOD == T042Z.ZLSCH
  • I_SALESCONTRACTITEMCUBE.[column in domain "LAND1"] == T042Z.LAND1
Material: order item
  • Client
  • Product Number
  • Material Number
  • I_SALESCONTRACTITEMCUBE.MANDT == MARA.MANDT
  • I_SALESCONTRACTITEMCUBE.PRODUCT == MARA.MATNR
  • I_SALESCONTRACTITEMCUBE.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Material Group
  • Product Group
  • I_SALESCONTRACTITEMCUBE.MANDT == T023.MANDT
  • I_SALESCONTRACTITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_SALESCONTRACTITEMCUBE.PRODUCTGROUP == T023.MATKL
Reason for Cancellation of Contract
  • Client
  • Reason for Cancellation of Contract
  • I_SALESCONTRACTITEMCUBE.MANDT == TVKG.MANDT
  • I_SALESCONTRACTITEMCUBE.SALESCONTRACTCANCLNREASON == TVKG.KUEGRU
Action at end of contract
  • Client
  • Action at end of contract
  • I_SALESCONTRACTITEMCUBE.MANDT == TVAS.MANDT
  • I_SALESCONTRACTITEMCUBE.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
Sales document item category
  • Client
  • Sales document item category
  • I_SALESCONTRACTITEMCUBE.MANDT == TVPT.MANDT
  • I_SALESCONTRACTITEMCUBE.SALESCONTRACTITEMCATEGORY == TVPT.PSTYV
Sales District
  • Client
  • Sales District
  • I_SALESCONTRACTITEMCUBE.MANDT == T171.MANDT
  • I_SALESCONTRACTITEMCUBE.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_SALESCONTRACTITEMCUBE.MANDT == TVAG.MANDT
  • I_SALESCONTRACTITEMCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • I_SALESCONTRACTITEMCUBE.MANDT == T001L.MANDT
  • I_SALESCONTRACTITEMCUBE.STORAGELOCATION == T001L.LGORT
  • I_SALESCONTRACTITEMCUBE.PLANT == T001L.WERKS
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • I_SALESCONTRACTITEMCUBE.MANDT == T006.MANDT
  • I_SALESCONTRACTITEMCUBE.TARGETQUANTITYUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESCONTRACTITEMCUBE.MANDT == TCURC.MANDT
  • I_SALESCONTRACTITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS