C_SettlementGroupOverview

Consumption Query for Settlement Group Overview | view: CSTLMNTGRPOVW | Extraction: Not supported | Component: Commodity Contracts, Expenses, Basic Functions
Column Name Description
SettlementDocGroupUUID Settlement Group GUID
SettlementGroupId Settlement Group
SettlementFiscalYear Settlement Group Year
SettlmtDoc Settlement Unit
Column Name Description
💲 Currency Key (SettlementAmountCurrency):
SettlementAmount Net Amount
Column Name Description
Column Name Description
ApplicationDocAppliedDate Posting Date in the Document
Column Name Description
Column Name Description Domain name
SettlementDocHeaderUUID Settlement Header GUID SYSUUID
ABDNumber Document Number
SettlementScenario Settlement Scenario
SettlementScenarioName Short Text for Fixed Values DDTEXT
SettlmtDocCat Settlement Document Category
DocumentCategoryText Short Text for Fixed Values DDTEXT
Counterparty Counterparty
CounterpartyFullName null
ACMCounterpartyFirstName Name 1 NAME
ACMCounterpartyLastName Name 2 NAME
CustomerName Name of Customer TEXT80
Side Side
DocumentSide Short Text for Fixed Values DDTEXT
CompanyCode Company Code
CompanyCodeName Name of Company Code or Company TEXT25
ContractPlant Plant
SystemStatus Object status
SystemStatusName Object status TEXT30
ContractApplicationDocument Application Document Number
ReferenceDocumentNumber Reference Document /ACCGO/D_REFDOC
ApplicationDocument Application Document Number /ACCGO/D_APPLDOC
SalesOrder Sales and Distribution Document Number
PurchaseOrder Purchasing Document Number
PredecessorDocumentNumber CA Reference Document 3 WLF_GENERIC_DOC_NUM
ACMPredecessorDocumentNumber Application Document Number /ACCGO/D_APPLDOC
LDCId Load Data Capture Object ID
LoadDataCaptureObjId Load Data Capture Object ID /ACCGO/D_UIS_ID
TradingContractNumber Trading Contract
TradingContract Trading Contract TKONN
ContractNum Trading Contract TKONN
TradingContractTypeName Name of Trading Contract Type TEXT40
SalesOrganizationText Name TEXT20
DistributionChannelText Distribution Channel Description TEXT20
DivisionName Name TEXT20
PurchasingOrganizationName Description of purchasing organization TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
ACMSemanticColor 4 Byte Signed Integer INT4
StopSettlementIsRelease Stop Settlement
Master Data Relations Join Conditions
Check Material
  • Material Number
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.CONTRACTMATERIAL == MARA.MATNR
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == MARA.MANDT
Check Distribution Channel
  • Distribution Channel
  • Sales Organization
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVKOV.VKORG
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == TVKOV.MANDT
Check Division
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SETTLEMENTGROUPOVERVIEW.DIVISION == TVTA.SPART
  • C_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVTA.VKORG
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == TVTA.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.PURCHASINGGROUP == T024.EKGRP
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVKO.VKORG
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == TVKO.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • C_SETTLEMENTGROUPOVERVIEW.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • C_SETTLEMENTGROUPOVERVIEW.MANDT == TB2BE.MANDT