CMS_CAG_SA

Special Arrangements | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
CAG_SA_GUID Primary key for CMS_CAG_SA
Column Name Description
💲 Currency of Special Arrangement: Nominal Value (NOM_VALUE_CURR):
NOM_VALUE Special Arrangement Nominal Value
💲 Currency of Special Arrangement: Assessment Amount (ASMT_AMT_CURR):
ASMT_AMT Special Arrangement Assessment Amount
Column Name Description
Column Name Description
VALID_FROM Date from which Special Arrangement Stands Valid
VALID_TO Date from which Special Arrangement Stands Valid
REF_AGMT_DATE Purchase Agreement Date of Special Arrangement
Column Name Description
PROC_STAT Processing Status of Special Arrangement Show values
LEGAL_STAT Special Arrangement Legal Status Show values
Column Name Description Domain name
REF_GUID Link Key for CMS_CAG_SA SYSUUID
SA_ID Special Arrangement ID CMS_CAG_SA_ID
BANK_KEY Bank Keys BANKK
BANK_ACCT Bank account number BANKN35
BANK_CTRL_KEY Bank Control Key BKONT
REF_AGMT_ID Pruchase Agreement ID of a Special Arrangement CMS_CAG_SA_REFAGMT_ID
DESCRIPTION Description for Special Arrangement CMS_DSC
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
Master Data Relations Join Conditions
Currency of Special Arrangement: Assessment Amount
  • CMS_CAG_SA.MANDT == TCURC.MANDT
  • CMS_CAG_SA.ASMT_AMT_CURR == TCURC.WAERS
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • CMS_CAG_SA.BANK_CTRY == T005.LAND1
  • CMS_CAG_SA.MANDT == T005.MANDT
Client CMS_CAG_SA.MANDT == T000.MANDT
Currency of Special Arrangement: Nominal Value
  • CMS_CAG_SA.MANDT == TCURC.MANDT
  • CMS_CAG_SA.NOM_VALUE_CURR == TCURC.WAERS
Special Arrangement Type CMS_CAG_SA.MANDT == TCMS_CAG_SA_TY.MANDT