C_TradingContractApprovalQueue

Consumption Query for Trading Contract Approval Queue | view: CTRDGCTRAPPQUEUE | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: /ACCGO/T_CAKHDR, /ACCGO/T_QTOL_HD, WBHK, /ACCGO/T_CAKHDR, WBGT, /ACCGO/T_CON_TRD, /ACCGO/T_CAKHDR, WBHK, /ACCGO/T_DPQS_OH, /ACCGO/T_DPQS_OH, WBHP, WB2_D_COMSUB, /ACCGO/T_CAKITM, WBHI, WBHD, /ACCGO/T_SNPHD1, /ACCGO/T_TRADIDT, /ACCGO/T_TLTYP, /ACCGO/T_TLTYPT, MARA, T024E, TB2BE, /ACCGO/T_BP_TYPE, /ACCGO/T_DPQS_H, TVTW, TVTWT, TINCT, MAKT, MARA, TPART, T001W, T024, TVKOV, /ACCGO/T_TSCHT, TB2BAT, ADRC, TB2BET, TB2BE, TVTA, TSPAT, TVKO, TVKOT, KNA1, LFA1, TB2BE, TB2BET, ADCP, ADRC, ADRP, USR02, USR21, /ACCGO/T_CAK_TYP, /ACCGO/T_ACM_TCP, /ACCGO/T_CAK_TYP, /ACCGO/T_STATUS, /ACCGO/T_CAK_TYP, USCOMPANY
Column Name Description
SalesContract Trading Contract
Column Name Description
Column Name Description
Column Name Description
TradingContractChangedOnDate Last Changed On
TradingContrCreatedOnDate Date on which the record was created
DocumentDate Document Date
ACMTrdgContrQuotesValidDate Quotes Valid Till Date
Column Name Description
ACMTrdgContractOutputProcess Output Processing Show values
ACMTrdgContrSignatureStatus Signature Status Show values
Column Name Description Domain name
TradingContractNumber Trading Contract
TradingContractTypeName Name of Trading Contract Type TEXT40
Side null
DocumentSide Short Text for Fixed Values DDTEXT
TrdgContrApplStsName Trading Contract: Name of Application Status TEXT40
ContractMaterial null
SalesOrganizationText Name TEXT20
DistributionChannelText Distribution Channel Description TEXT20
DivisionName Name TEXT20
PurchasingOrganizationName Description of purchasing organization TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
Counterparty Customer Number
CounterpartyFullName null
ACMCounterpartyFirstName Name 1 NAME
ACMCounterpartyLastName Name 2 NAME
CustomerName Name of Customer TEXT80
Incoterms Incoterms Part 1 Sales
IncotermsClassificationName Description TEXT30
IncotermsLocation1 Incoterms Location 1
TrdgContrPurgIncotermsLoc1Text Incoterms Location 1 INCO_L
TrdgContrSlsIncotermsLoc1Text Incoterms Location 1 INCO_L
TradingContractExternalID External Identifier in Trading Contract
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
TradingContractChangedBy Name of Person Who Changed Object USNAM
TradingContractChangedByName Full Name of Person
ACMSemanticColor 4 Byte Signed Integer INT4
ACMTrdgContrOutpProcText Short Text for Fixed Values DDTEXT
ACMTrdgContrSgntrStsText Short Text for Fixed Values DDTEXT
ConditionCount null
ACMOriginalTraderID Responsible Trader ID
ACMOriginalTraderIDText Trader ID Text /ACCGO/D_TRADER_ID_TEXT
ACMAmendingTraderID Amending Trader ID
ACMAmendingTraderIDText Trader ID Text /ACCGO/D_TRADER_ID_TEXT
TrdgContrCreditSalesVals null
TradingContractCreditSales null
ACMSignedStatus Signed Status
ApplicationIsVehicleContrRlvt null
ACMCustomerReference Customer Reference
ACMYourReference Your Reference
TransactingCtpty Reference to other supplier
ACMTransactingCustomerName Name of Customer TEXT80
ACMTransCounterpartyFullName null
ACMTransCounterpartyFirstName Name 1 NAME
ACMTransCounterpartyLastName Name 2 NAME
AlternatePaymentTerm Terms of Payment Key Purchasing
PaymentTermsDescription null
ACMTargetTrdgContrTypeName Name of Trading Contract Type TEXT40
ACMTradingContractCategory Contract Type
Master Data Relations Join Conditions
Check Purchasing Grouping
  • Control Group Purchasing for Trading Contracts
  • Client
  • C_TRADINGCONTRACTAPPROVALQUEUE.ACMTRDGCONTRPURGCONTROLGROUP == TB2BC.TDTPV
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TB2BC.MANDT
Commodity
  • Commodity
  • Client
Company Code
  • Client
  • Company Code
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == T001.MANDT
  • C_TRADINGCONTRACTAPPROVALQUEUE.COMPANYCODE == T001.BUKRS
Check Plant
  • Plant
  • Client
  • C_TRADINGCONTRACTAPPROVALQUEUE.CONTRACTPLANT == T001W.WERKS
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == T001W.MANDT
Check Application Status
  • Application Status of Trading Contract
  • Client
  • C_TRADINGCONTRACTAPPROVALQUEUE.CONTRACTSTATUS == TB2BA.BTBSTA
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TB2BA.MANDT
Check Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • C_TRADINGCONTRACTAPPROVALQUEUE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TVKOV.MANDT
  • C_TRADINGCONTRACTAPPROVALQUEUE.SALESORGANIZATION == TVKOV.VKORG
Check Division
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • C_TRADINGCONTRACTAPPROVALQUEUE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TVTA.MANDT
  • C_TRADINGCONTRACTAPPROVALQUEUE.DIVISION == TVTA.SPART
  • C_TRADINGCONTRACTAPPROVALQUEUE.SALESORGANIZATION == TVTA.VKORG
Check Purchasing Group
  • Client
  • Purchasing Group
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == T024.MANDT
  • C_TRADINGCONTRACTAPPROVALQUEUE.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Purchasing organization
  • Client
  • C_TRADINGCONTRACTAPPROVALQUEUE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == T024E.MANDT
Check Sales Organization
  • Client
  • Sales Organization
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TVKO.MANDT
  • C_TRADINGCONTRACTAPPROVALQUEUE.SALESORGANIZATION == TVKO.VKORG
Trade Office
  • Client
  • Trade Office
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == BUT000.CLIENT
  • C_TRADINGCONTRACTAPPROVALQUEUE.TRADINGCONTRACTTRADEOFFICE == BUT000.PARTNER
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • C_TRADINGCONTRACTAPPROVALQUEUE.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • C_TRADINGCONTRACTAPPROVALQUEUE.MANDT == TB2BE.MANDT