I_ACMSettlementUnitDet

Column Name Description
SettlmtDoc Settlement Unit
SettlmtDocYear Settlement Unit Year
Column Name Description
💲 Currency Key (SettlementCurrency):
ACMSettlementUnitGrossAmount Gross Amount
ACMSettlementUnitNetAmount Net Amount
Column Name Description
📏 Per Unit UoM (ACMDocumentUnitOfMeasure):
ACMDocumentQuantity Quantity in Base UoM
Column Name Description
SettlementPostingDate Settlement Posting Date
Column Name Description
ACMTrdgContrSettlementType Settlement Type Show values
ACMDocumentSide Side Show values
ACMReferenceSettlementCategory Settlement Document Category Show values
Column Name Description Domain name
SettlementGroupId Settlement Group /ACCGO/D_STL_CTNR
SettlementGroupYear Settlement Group Year /ACCGO/D_STL_GRP_YR
SettlementDocGroupUUID Settlement Group GUID SYSUUID
SettlementCounterparty Counterparty BU_PARTNER
SettlementDocHeaderUUID Settlement Header GUID SYSUUID
TradingContractNumber Trading Contract TKONN
TradingContractItem Item Number of Trading Contract TPOSN
ACMTradingContractType Trading Contract Type TCTYP
LoadDataCaptureObjectID Load Data Capture Object ID /ACCGO/D_UIS_ID
ACMScaleTicketNumber Scale Ticket Number /ACCGO/D_SCALE_TKT_NO
ContractMaterial Material Number MATNR
ContractPlant Plant WERKS
ContractApplicationDocument Application Document Number /ACCGO/D_APPLDOC
SuccessorItem Application Document Item Number WLF_GENERIC_ITEM_NUM
Incoterms Incoterms (Part 1) INCO1
IncotermsPart2 Incoterms (Part 2) INCO2
Commodity Commodity TBA_STOEFFCHEN
ACMSettlementUnitIsPaid null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_ACMSETTLEMENTUNITDET.COMPANYCODE == T001.BUKRS
  • I_ACMSETTLEMENTUNITDET.MANDT == T001.MANDT
Check Distribution Channel
  • Distribution Channel
  • Sales Organization
  • Client
  • I_ACMSETTLEMENTUNITDET.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ACMSETTLEMENTUNITDET.SALESORGANIZATION == TVKOV.VKORG
  • I_ACMSETTLEMENTUNITDET.MANDT == TVKOV.MANDT
Check Division
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • I_ACMSETTLEMENTUNITDET.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_ACMSETTLEMENTUNITDET.DIVISION == TVTA.SPART
  • I_ACMSETTLEMENTUNITDET.SALESORGANIZATION == TVTA.VKORG
  • I_ACMSETTLEMENTUNITDET.MANDT == TVTA.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • I_ACMSETTLEMENTUNITDET.PURCHASINGORGANIZATION == T024E.EKORG
  • I_ACMSETTLEMENTUNITDET.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • I_ACMSETTLEMENTUNITDET.SALESORGANIZATION == TVKO.VKORG
  • I_ACMSETTLEMENTUNITDET.MANDT == TVKO.MANDT
Currency Key
  • Currency Key
  • Client
  • I_ACMSETTLEMENTUNITDET.SETTLEMENTCURRENCY == TCURC.WAERS
  • I_ACMSETTLEMENTUNITDET.MANDT == TCURC.MANDT