R_ACMSettlementUnitDetTP

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
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
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
Commodity Commodity TBA_STOEFFCHEN
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
ContractMaterial Material Number MATNR
ContractPlant Plant WERKS
ACMScaleTicketNumber Scale Ticket Number /ACCGO/D_SCALE_TKT_NO
ACMSettlementUnitStatus Object status J_STATUS
ACMSettlementUnitIsPaid null
Master Data Relations Join Conditions
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • R_ACMSETTLEMENTUNITDETTP.MANDT == TVKOV.MANDT
  • R_ACMSETTLEMENTUNITDETTP.SALESORGANIZATION == TVKOV.VKORG
  • R_ACMSETTLEMENTUNITDETTP.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • R_ACMSETTLEMENTUNITDETTP.MANDT == TVTA.MANDT
  • R_ACMSETTLEMENTUNITDETTP.DIVISION == TVTA.SPART
  • R_ACMSETTLEMENTUNITDETTP.SALESORGANIZATION == TVTA.VKORG
  • R_ACMSETTLEMENTUNITDETTP.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Check Purchasing Organization
  • Purchasing organization
  • Client
  • R_ACMSETTLEMENTUNITDETTP.PURCHASINGORGANIZATION == T024E.EKORG
  • R_ACMSETTLEMENTUNITDETTP.MANDT == T024E.MANDT
Check Sales Organization
  • Client
  • Sales Organization
  • R_ACMSETTLEMENTUNITDETTP.MANDT == TVKO.MANDT
  • R_ACMSETTLEMENTUNITDETTP.SALESORGANIZATION == TVKO.VKORG
Currency Key
  • Client
  • Currency Key
  • R_ACMSETTLEMENTUNITDETTP.MANDT == TCURC.MANDT
  • R_ACMSETTLEMENTUNITDETTP.SETTLEMENTCURRENCY == TCURC.WAERS