I_SettlementGroupOverview

Interface Layer For Settlement Group Overview | view: ISTLMNTGRPOVW | 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
SettlementScenario Settlement Scenario Show values
DPQSinSettlementIndicator Ignore DPQS Premium/Discount Flag Show values
SettlmtDocCat Settlement Document Category Show values
Side Side Show values
StopSettlementIsRelease Stop Settlement Show values
Column Name Description Domain name
SettlementDocHeaderUUID Settlement Header GUID SYSUUID
ABDNumber Document Number WBELN
ThresholdPercentage Threshold Percentage DEC5_2
SettlementScenarioName Short Text for Fixed Values DDTEXT
DocumentCategoryText Short Text for Fixed Values DDTEXT
Counterparty Counterparty BU_PARTNER
CustomerName Name of Customer TEXT80
CounterpartyFullName null
ACMCounterpartyFirstName Name 1 NAME
ACMCounterpartyLastName Name 2 NAME
DocumentSide Short Text for Fixed Values DDTEXT
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
ContractPlant Plant WERKS
ReferenceVendor Account Number of Supplier LIFNR
CustomerNum Customer Number KUNNR
SettlementStatusObject null
SystemStatus Object status J_STATUS
SystemStatusName Object status TEXT30
ACMSemanticColor 4 Byte Signed Integer INT4
ReferenceDocumentNumber Reference Document /ACCGO/D_REFDOC
ApplicationDocument Application Document Number /ACCGO/D_APPLDOC
ContractApplicationDocument Application Document Number /ACCGO/D_APPLDOC
PredecessorDocumentNumber CA Reference Document 3 WLF_GENERIC_DOC_NUM
ACMPredecessorDocumentNumber Application Document Number /ACCGO/D_APPLDOC
SalesOrder Sales and Distribution Document Number VBELN
PurchaseOrder Purchasing Document Number EBELN
LoadDataCaptureObjId Load Data Capture Object ID /ACCGO/D_UIS_ID
LDCId Load Data Capture Object ID /ACCGO/D_UIS_ID
ContractNum Trading Contract TKONN
TradingContract Trading Contract TKONN
TradingContractNumber 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
Master Data Relations Join Conditions
Check Material
  • Client
  • Material Number
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == MARA.MANDT
  • I_SETTLEMENTGROUPOVERVIEW.CONTRACTMATERIAL == MARA.MATNR
Check Distribution Channel
  • Distribution Channel
  • Sales Organization
  • Client
  • I_SETTLEMENTGROUPOVERVIEW.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVKOV.VKORG
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == TVKOV.MANDT
Check Division
  • Distribution Channel
  • Sales Organization
  • Client
  • Division
  • I_SETTLEMENTGROUPOVERVIEW.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVTA.VKORG
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == TVTA.MANDT
  • I_SETTLEMENTGROUPOVERVIEW.DIVISION == TVTA.SPART
Check Purchasing Group
  • Client
  • Purchasing Group
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == T024.MANDT
  • I_SETTLEMENTGROUPOVERVIEW.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == T024E.MANDT
  • I_SETTLEMENTGROUPOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Sales Organization
  • Client
  • I_SETTLEMENTGROUPOVERVIEW.SALESORGANIZATION == TVKO.VKORG
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == TVKO.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • I_SETTLEMENTGROUPOVERVIEW.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • I_SETTLEMENTGROUPOVERVIEW.MANDT == TB2BE.MANDT