C_ACMTrdgContrQuantitiesQuery

Consumption Query for Trdg Contr Qty | view: CTRDGCONTRQTY | 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
ContrOverFillSettledQuantity null
RevenueRecognizedQuantity null
ContrItemSoftAssignedQuantity null
Master Data Relations Join Conditions
Commodity
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.COMPANYCODE == T001.BUKRS
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == T001.MANDT
Check Material
  • Material Number
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.CONTRACTMATERIAL == MARA.MATNR
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == MARA.MANDT
Check Plant
  • Client
  • Plant
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == T001W.MANDT
  • C_ACMTRDGCONTRQUANTITIESQUERY.CONTRACTPLANT == T001W.WERKS
Check Customer Number
  • Sold-to Party
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.CUSTOMERNAME == KNA1.KUNNR
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == KNA1.MANDT
Check Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • C_ACMTRDGCONTRQUANTITIESQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == TVKOV.MANDT
  • C_ACMTRDGCONTRQUANTITIESQUERY.SALESORGANIZATION == TVKOV.VKORG
Check Division
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • C_ACMTRDGCONTRQUANTITIESQUERY.DIVISION == TVTA.SPART
  • C_ACMTRDGCONTRQUANTITIESQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == TVTA.MANDT
  • C_ACMTRDGCONTRQUANTITIESQUERY.SALESORGANIZATION == TVTA.VKORG
Check Purchasing Group
  • Purchasing Group
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.PURCHASINGGROUP == T024.EKGRP
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == T024.MANDT
Check Purchasing Organization
  • Client
  • Purchasing organization
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == T024E.MANDT
  • C_ACMTRDGCONTRQUANTITIESQUERY.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == TVKO.MANDT
  • C_ACMTRDGCONTRQUANTITIESQUERY.SALESORGANIZATION == TVKO.VKORG
Check Vendor
  • Vendor's account number
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.SUPPLIERNAME == LFA1.LIFNR
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • C_ACMTRDGCONTRQUANTITIESQUERY.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • C_ACMTRDGCONTRQUANTITIESQUERY.MANDT == TB2BE.MANDT