C_TrdgContrCreditSalesDet

Consumption Query for Trading Contract Credit Sales Details | view: CTRDGCONTRCS | TRAN | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Tables used: WBHK, WBHD, /ACCGO/T_CS_IDET
Column Name Description
TradingContractNumber FK Trading Contract
ACMTrdgContrAuditSequenceNmbr Audit Sequence Number
TradingContractItem Item Number of Trading Contract
TradingContractTradeOffice FK Trade Office
TradingContractGovRgnCode FK Governing Region Code
Column Name Description
Column Name Description
Column Name Description
TrdgContrCreditSalesFromDate UTC Valid from Date
TrdgContrCreditSalesFromTime UTC Valid from Time
TrdgContractCreditSalesToDate UTC Valid to Date
TrdgContractCreditSalesToTime UTC Valid to Time
Column Name Description
Column Name Description Domain name
TradingContractCreditSales Credit Sale Indicator
ACMTrdgContrGovRgnCodeStatus GRC Status
ACMTrdgContrGovRgnCodeStsName Short Text for Fixed Values DDTEXT
TrdgContrCrdtSlsTypeOfAssgmt Type Of Assignment
ProcessedTimeZone Time Zone
Master Data Relations Join Conditions
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • C_TRDGCONTRCREDITSALESDET.SALESORGANIZATION == TVKOV.VKORG
  • C_TRDGCONTRCREDITSALESDET.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_TRDGCONTRCREDITSALESDET.MANDT == TVKOV.MANDT
Check Division
  • Sales Organization
  • Division
  • Distribution Channel
  • Client
  • C_TRDGCONTRCREDITSALESDET.SALESORGANIZATION == TVTA.VKORG
  • C_TRDGCONTRCREDITSALESDET.DIVISION == TVTA.SPART
  • C_TRDGCONTRCREDITSALESDET.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_TRDGCONTRCREDITSALESDET.MANDT == TVTA.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • C_TRDGCONTRCREDITSALESDET.PURCHASINGGROUP == T024.EKGRP
  • C_TRDGCONTRCREDITSALESDET.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • C_TRDGCONTRCREDITSALESDET.PURCHASINGORGANIZATION == T024E.EKORG
  • C_TRDGCONTRCREDITSALESDET.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • C_TRDGCONTRCREDITSALESDET.SALESORGANIZATION == TVKO.VKORG
  • C_TRDGCONTRCREDITSALESDET.MANDT == TVKO.MANDT
Governing Region Code
  • Governing Region Code
  • Client
  • C_TRDGCONTRCREDITSALESDET.TRADINGCONTRACTGOVRGNCODE == /ACCGO/T_GRC.GOV_REG_CODE
  • C_TRDGCONTRCREDITSALESDET.MANDT == /ACCGO/T_GRC.MANDT
Trade Office
  • Trade Office
  • Client
  • C_TRDGCONTRCREDITSALESDET.TRADINGCONTRACTTRADEOFFICE == BUT000.PARTNER
  • C_TRDGCONTRCREDITSALESDET.MANDT == BUT000.CLIENT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • C_TRDGCONTRCREDITSALESDET.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • C_TRDGCONTRCREDITSALESDET.MANDT == TB2BE.MANDT