C_TradingContrPricingOverview

Column Name Description
TrdgContrPrcgAspectSrceLotID Source Lot ID
Column Name Description
💲 Condition Unit (Currency or Percentage) (ACMPrcgCndnCumltvBasisCrcy):
ACMPrcgCndnCumltvBasisPrice Condition amount or percentage where no scale exists
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
CmmdtyDealDetEffectiveToDate Date To
CmmdtyDealDetEffectiveFromDate Date From
Column Name Description
Column Name Description Domain name
TradingContractNumber Trading Contract
PricingConditionTerm CPE Term - Number in Formula
TradingContractTypeName Name of Trading Contract Type TEXT40
Side null
DocumentSide Short Text for Fixed Values DDTEXT
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
MaterialName Material Description TEXT40
TradingContractItem Item Number of Trading Contract
PricingApproach Pricing Approach
PricingTypeName Description TEXT40
CommodityName Commodity Description TEXT40
Counterparty Customer Number
CounterpartyFullName null
ACMCounterpartyFirstName Name 1 NAME
ACMCounterpartyLastName Name 2 NAME
Incoterms Incoterms Part 1 Sales
IncotermsClassificationName Description TEXT30
IncotermsLocation1 Incoterms Location 1
TrdgContrPurgIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrSlsIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrPersonResponsible Trading Contract: Person Responsible
TrdgContrPersonResponsibleName Full Name of Person TEXT80
TradingContractCreatedBy Name of Person Responsible for Creating the Object
TradingContractCreatedByName Full Name of Person TEXT80
TradingContractChangedBy Name of Person Who Changed Object
TradingContractChangedByName Full Name of Person TEXT80
CompanyCodeName Name of Company Code or Company TEXT25
DerivativeContrSpecification Derivative Contract Specification ID
ACMDerivativeContrSpecsTxt Description of Derivative Contract Specification TEXT40
ACMPricingMarketIdentifierCode Market Identifier Code
ACMMarketIdentifierCodeTxt Market Identifier Code Description TEXT40
DerivativeContractMaturityCode null
PrcgCndnTradingContrCurrency Total Amount /ACCGO/CPE_D_TOTAL_PRICE
ACMPrcgIntendedPrcType Intended price type
ACMPrcgIntendedPrcTypeDesc Short Text for Fixed Values DDTEXT
ACMReferencePO Customer Reference BSTKD
ACMCustomerReference Customer Reference
ACMYourReference Your Reference
ACMPrcgCndnFuturePrice CPE Term - Fixed Rate (up to 14 decimals)
ACMPrcgCndnBasisPrc CPE Term - Fixed Rate (up to 14 decimals)
ACMPrcgCndnFlatPrice Total Amount
Master Data Relations Join Conditions
Foreign key for currency of fix term rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.PRCGCONDITIONTERMFIXEDRATECRCY == TCURC.WAERS
  • C_TRADINGCONTRPRICINGOVERVIEW.ACMPRCGCNDNFUTURETERMCRCY == TCURC.WAERS
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TCURC.MANDT
Commodity
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.COMPANYCODE == T001.BUKRS
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == T001.MANDT
Check Material
  • Material Number
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.CONTRACTMATERIAL == MARA.MATNR
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == MARA.MANDT
Check Plant
  • Plant
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.CONTRACTPLANT == T001W.WERKS
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == T001W.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.CONTRACTSTATUS == TB2BA.BTBSTA
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TB2BA.MANDT
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.SALESORGANIZATION == TVKOV.VKORG
  • C_TRADINGCONTRPRICINGOVERVIEW.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TVKOV.MANDT
Check Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.SALESORGANIZATION == TVTA.VKORG
  • C_TRADINGCONTRPRICINGOVERVIEW.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_TRADINGCONTRPRICINGOVERVIEW.DIVISION == TVTA.SPART
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TVTA.MANDT
Foreign key for currency of fix term rate
  • CPE - Currency for Fixed Rate
  • CPE - Currency for Fixed Rate
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.PRCGCONDITIONTERMFIXEDRATECRCY == TCURC.WAERS
  • C_TRADINGCONTRPRICINGOVERVIEW.ACMPRCGCNDNFUTURETERMCRCY == TCURC.WAERS
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TCURC.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.PURCHASINGGROUP == T024.EKGRP
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • C_TRADINGCONTRPRICINGOVERVIEW.SALESORGANIZATION == TVKO.VKORG
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TVKO.MANDT
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • C_TRADINGCONTRPRICINGOVERVIEW.MANDT == TB2BE.MANDT
  • C_TRADINGCONTRPRICINGOVERVIEW.TRADINGCONTRACTTYPE == TB2BE.TCTYP