I_ACMMntnTrdgContrPrcgOvwSts

Trading Contract Pricing Statistics | view: IACMPRCNGSTS | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: /ACCGO/T_CAKITM, /ACCGO/T_CAKHDR, WBGT, WBHK, /ACCGO/T_CAKHDR, WBHK, WB2_D_COMSUB, /ACCGO/T_PR_ASP, CPED_FORMDOC, CPED_KNUMVTOGUID, WBHI, WBHD, CPED_TERMGRPOUT, CPED_TERMINPUT, WBHD, MARA, /ACCGO/T_PRIAPTX, T024E, TBAC_PHYSCOMMT, T001, TKA02, TBAC_DCST, TVTW, TVTWT, TINCT, TBAC_MICT, MAKT, T024, TVKOV, TB2BAT, TVTA, TSPAT, TVKO, TVKOT, KNA1, LFA1, TB2BE, TB2BET, ADCP, ADRC, ADRP, USR02, USR21, /ACCGO/T_CPE_BRI, TBAC_DCS_LOF, /ACCGO/T_CAK_TYP, USCOMPANY
Column Name Description
TrdgContrPrcgAspectSrceLotID Source Lot ID
Column Name Description
Column Name Description
📏 Unit of Measure of Trade Quantity (UnitOfMeasure):
Quantity Quantity in Trade UoM Send by 3PT
Column Name Description
DocumentDate Date on which the record was created
MaturityKeyDate Maturity Key Date
CmmdtyDealDetEffectiveFromDate Date From
CmmdtyDealDetEffectiveToDate Date To
Column Name Description
Side Side Show values
PricingStatus Future/Basis Price Fixation Status Show values
ACMPrcgIntendedPrcType Intended price type Show values
DocumentSide Side Show values
Column Name Description Domain name
TradingContractNumber Trading Contract TKONN
TradingContractTypeName Name of Trading Contract Type TEXT40
PricingConditionTerm CPE Term - Number in Formula NUMC5
TrdgContrApplStsName Trading Contract: Name of Application Status TEXT40
SalesOrganizationText Name TEXT20
DistributionChannelText Distribution Channel Description TEXT20
DivisionName Name TEXT20
PurchasingOrganizationName Description of purchasing organization TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
TradingContractExternalID External Identifier in Trading Contract TKONN_EX
MaterialName Material Description TEXT40
TradingContractItem Item Number of Trading Contract TPOSN
PricingApproach Pricing Approach /ACCGO/CPE_D_PRICING_APPROACH
CommodityName Commodity Description TEXT40
Counterparty Customer Number KUNNR
CounterpartyFullName null
ACMCounterpartyFirstName Name 1 NAME
ACMCounterpartyLastName Name 2 NAME
Incoterms Incoterms Part 1 Sales INCO1
IncotermsLocation1 Incoterms Location 1 INCO_L
TrdgContrPurgIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrSlsIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrPersonResponsible Trading Contract: Person Responsible UNAME
TrdgContrPersonResponsibleName Full Name of Person TEXT80
TradingContractCreatedBy Name of Person Responsible for Creating the Object USNAM
TradingContractCreatedByName Full Name of Person TEXT80
TradingContractChangedBy Name of Person Who Changed Object USNAM
TradingContractChangedByName Full Name of Person TEXT80
IncotermsClassificationName Description TEXT30
ACMPricingAreFlatPriceRecords null
ACMPrcgAreNoBaseEstblmtRecords null
ACMPrcgAreNoFutrEstblmtRecords null
ACMPrcgAreNoPrcEstblmtRecords null
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
ACMPrcgIntendedPrcTypeDesc Short Text for Fixed Values DDTEXT
PricingTypeName Description TEXT40
PricingStatusText Short Text for Fixed Values DDTEXT
CompanyCodeName Name of Company Code or Company TEXT25
ACMDerivativeContrSpecsTxt Description of Derivative Contract Specification TEXT40
ACMMarketIdentifierCodeTxt Market Identifier Code Description TEXT40
ACMYourReference Your Reference TEXT12
ACMCustomerReference Customer Reference BSTKD
Master Data Relations Join Conditions
Commodity
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.COMPANYCODE == T001.BUKRS
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == T001.MANDT
Check Material
  • Client
  • Material Number
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == MARA.MANDT
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.CONTRACTMATERIAL == MARA.MATNR
Check Plant
  • Plant
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.CONTRACTPLANT == T001W.WERKS
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == T001W.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.CONTRACTSTATUS == TB2BA.BTBSTA
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == TB2BA.MANDT
Check Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == TVKOV.MANDT
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.SALESORGANIZATION == TVKOV.VKORG
Check Division
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == TVTA.MANDT
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.DIVISION == TVTA.SPART
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.SALESORGANIZATION == TVTA.VKORG
Check Purchasing Group
  • Purchasing Group
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.PURCHASINGGROUP == T024.EKGRP
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.PURCHASINGORGANIZATION == T024E.EKORG
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == T024E.MANDT
Check Sales Organization
  • Client
  • Sales Organization
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == TVKO.MANDT
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.SALESORGANIZATION == TVKO.VKORG
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • I_ACMMNTNTRDGCONTRPRCGOVWSTS.MANDT == TB2BE.MANDT