I_ACMTrdgContrQuantitiesCube

Interface Layer for Trdg Cntr Quantities - Cube | view: ITRDCONTQTYCUBE | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: /ACCGO/T_EVTREG, WB2_D_ASSGMT, JEST, /ACCGO/T_STLITEM, WB2_D_SHD_ITEM, /ACCGO/T_CAKASGT, /ACCGO/T_SHDITEM, WBHD, WBHI, WBHK, /ACCGO/T_APPDATA, /ACCGO/T_CAS_CAI, /ACCGO/T_STLHEAD, /ACCGO/T_QTOL_HD, /ACCGO/T_PR_ASP, /ACCGO/T_STLSTAT, MARA, /ACCGO/T_CAK_TYP, /ACCGO/T_PRASP
Column Name Description
ContractNum FK Trading Contract
ContractItem Item Number of Trading Contract
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (TrdgContractItemUnitOfMeasure):
TradingContractItemQuantity Cumulative Order Quantity in Sales Units
TrdgContrItemOverFillQuantity null
FinalSettledQuantity null
TotalFinalSettledQuantity null
TradingContractItemOpenQty null
ContrOverFillFixationQuantity null
Column Name Description
DocumentDate Date on which the record was created
Column Name Description
Column Name Description Domain name
TradingContractCreatedBy Name of Person Responsible for Creating the Object USNAM
ContractItemConsumedQuantity null
LogisticallyAdjustedQuantity null
TrdgContrItemCancelledQuantity null
TrdgContrItemWashoutQuantity null
TrdgContrItemReturnQuantity null
ProvisionalApplicationQuantity null
FinalApplicationQuantity null
ContrItmPrvsnlUnderFillQty null
ContrItmProvisionalOverFillQty null
TrdgContrItemUnderFillQuantity null
ProvisionalSettledQuantity null
NonAppliedPrvsnlSettledQty null
RevenueRecognizedQuantity null
ContrOverFillSettledQuantity null
ContrItemSoftAssignedQuantity null
Master Data Relations Join Conditions
Commodity
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.COMPANYCODE == T001.BUKRS
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == T001.MANDT
Check Material
  • Material Number
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.CONTRACTMATERIAL == MARA.MATNR
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == MARA.MANDT
Check Plant
  • Plant
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.CONTRACTPLANT == T001W.WERKS
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == T001W.MANDT
Check Customer Number
  • Sold-to Party
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.CUSTOMERNAME == KNA1.KUNNR
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == KNA1.MANDT
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_ACMTRDGCONTRQUANTITIESCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == TVKOV.MANDT
Check Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.SALESORGANIZATION == TVTA.VKORG
  • I_ACMTRDGCONTRQUANTITIESCUBE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_ACMTRDGCONTRQUANTITIESCUBE.DIVISION == TVTA.SPART
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == TVTA.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == TVKO.MANDT
Check Vendor
  • Vendor's account number
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.SUPPLIERNAME == LFA1.LIFNR
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • I_ACMTRDGCONTRQUANTITIESCUBE.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • I_ACMTRDGCONTRQUANTITIESCUBE.MANDT == TB2BE.MANDT