P_ACMTradingContractDetails

Private View for Trading Contract Header Details | view: PTRDGCONTRCTDTLS | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: /ACCGO/T_CAKHDR, WBGT, /ACCGO/T_CON_TRD, /ACCGO/T_CAKHDR, WBHK, WBHD, T024E, TB2BE, TVTW, TVTWT, TINCT, T024, TVKOV, TB2BAT, TVTA, TSPAT, TVKO, TVKOT, KNA1, LFA1, TB2BE, TB2BET, ADCP, ADRC, ADRP, USR02, USR21, /ACCGO/T_CAK_TYP, /ACCGO/T_CAK_TYP, USCOMPANY
Column Name Description
TradingContractNumber Trading Contract
Column Name Description
Column Name Description
Column Name Description
DocumentDate Date on which the record was created
TradingContractChangedOnDate Last Changed On
Column Name Description
TrdgContractCategory Contract Type Show values
TradingContractCreditSales Credit Sale Indicator Show values
ACMSignedStatus Signed Status Show values
Column Name Description Domain name
TradingContractTypeName Name of Trading Contract Type TEXT40
Side null
TrdgContrApplStsName Trading Contract: Name of Application Status TEXT40
PaymentTerms Incoterms Version INCOV
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
resp_trader_id Amending Trader ID /ACCGO/D_TRADER_ID
orig_resp_trader_id Responsible Trader ID /ACCGO/D_TRADER_ID
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
ACMYourReference Your Reference TEXT12
ACMCustomerReference Customer Reference BSTKD
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.COMPANYCODE == T001.BUKRS
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == T001.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.CONTRACTSTATUS == TB2BA.BTBSTA
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == TB2BA.MANDT
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.SALESORGANIZATION == TVKOV.VKORG
  • P_ACMTRADINGCONTRACTDETAILS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == TVKOV.MANDT
Check Division
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_ACMTRADINGCONTRACTDETAILS.SALESORGANIZATION == TVTA.VKORG
  • P_ACMTRADINGCONTRACTDETAILS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == TVTA.MANDT
  • P_ACMTRADINGCONTRACTDETAILS.DIVISION == TVTA.SPART
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == T024.MANDT
  • P_ACMTRADINGCONTRACTDETAILS.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Purchasing organization
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.SALESORGANIZATION == TVKO.VKORG
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == TVKO.MANDT
Trade Office
  • Trade Office
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.TRADINGCONTRACTTRADEOFFICE == BUT000.PARTNER
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == BUT000.CLIENT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • P_ACMTRADINGCONTRACTDETAILS.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • P_ACMTRADINGCONTRACTDETAILS.MANDT == TB2BE.MANDT