P_TradingContractOverview

Private Layer for Trading Ctr Overview | view: PTRDGCTROVW | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Column Name Description
TradingContractNumber Trading Contract
Column Name Description
Column Name Description
Column Name Description
TradingContrCreatedOnDate Date on which the record was created
DocumentDate Document Date
TradingContractChangedOnDate Last Changed On
Column Name Description
TradingContractCreditSales Credit Sale Indicator Show values
ACMSignedStatus Signed Status Show values
ACMTrdgContrIsStatusClosed Contract Closure with CDOTE Indicator Show values
Column Name Description Domain name
TradingContractTypeName Name of Trading Contract Type TEXT40
Side null
TrdgContrApplStsName Trading Contract: Name of Application Status TEXT40
ekotx Description of purchasing organization TEXT20
eknam Purchasing Group Name TEXT18
TradingContractExternalID External Identifier in Trading Contract TKONN_EX
PersonResponsible Trading Contract: Person Responsible UNAME
PersonResponsibleName 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
DistributionChannelDescr Distribution Channel Description TEXT20
SalesDivisionDescr Name TEXT20
SalesOrgDescr Name TEXT20
DocumentSide Short Text for Fixed Values DDTEXT
Counterparty Customer Number KUNNR
Incoterms Incoterms Part 1 Sales INCO1
IncotermsClassificationName Description TEXT30
IncotermsLocation1 Incoterms Location 1 INCO_L
TrdgContrPurgIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrSlsIncotermsLoc1Text Incoterms Location 1 INCO_L
AlternatePaymentTerm Terms of Payment Key Purchasing ZTERM
resp_trader_id Amending Trader ID /ACCGO/D_TRADER_ID
orig_resp_trader_id Responsible Trader ID /ACCGO/D_TRADER_ID
TradingContractTradeOffice Trade Office BU_PARTNER
ACMReferencePO Customer Reference BSTKD
ACMCustomerReference Customer Reference BSTKD
ACMYourReference Your Reference TEXT12
Master Data Relations Join Conditions
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • P_TRADINGCONTRACTOVERVIEW.MANDT == T001W.MANDT
  • P_TRADINGCONTRACTOVERVIEW.ACMSUPPLYINGPLANT == T001W.WERKS
Company Code
  • Company Code
  • Client
  • P_TRADINGCONTRACTOVERVIEW.COMPANYCODE == T001.BUKRS
  • P_TRADINGCONTRACTOVERVIEW.MANDT == T001.MANDT
Check Application Status
  • Client
  • Application Status of Trading Contract
  • P_TRADINGCONTRACTOVERVIEW.MANDT == TB2BA.MANDT
  • P_TRADINGCONTRACTOVERVIEW.CONTRACTSTATUS == TB2BA.BTBSTA
Check Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • P_TRADINGCONTRACTOVERVIEW.SALESORGANIZATION == TVKOV.VKORG
  • P_TRADINGCONTRACTOVERVIEW.MANDT == TVKOV.MANDT
  • P_TRADINGCONTRACTOVERVIEW.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • P_TRADINGCONTRACTOVERVIEW.SALESORGANIZATION == TVTA.VKORG
  • P_TRADINGCONTRACTOVERVIEW.MANDT == TVTA.MANDT
  • P_TRADINGCONTRACTOVERVIEW.DIVISION == TVTA.SPART
  • P_TRADINGCONTRACTOVERVIEW.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_TRADINGCONTRACTOVERVIEW.MANDT == T024.MANDT
  • P_TRADINGCONTRACTOVERVIEW.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Purchasing organization
  • Client
  • P_TRADINGCONTRACTOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • P_TRADINGCONTRACTOVERVIEW.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • P_TRADINGCONTRACTOVERVIEW.SALESORGANIZATION == TVKO.VKORG
  • P_TRADINGCONTRACTOVERVIEW.MANDT == TVKO.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • P_TRADINGCONTRACTOVERVIEW.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • P_TRADINGCONTRACTOVERVIEW.MANDT == TB2BE.MANDT