SAP Table CMS_CAG_SA

Special Arrangements

The table CMS_CAG_SA (Special Arrangements) is a standard table in SAP ERP. It belongs to the package CMS_CORE.

Technical Information

Table	CMS_CAG_SA
Short Text	Special Arrangements
Package	CMS_CORE
Table Type	Transparent Table

Fields for Table CMS_CAG_SA

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
CAG_SA_GUID	✔	Primary key for CMS_CAG_SA	CMS_DTE_CAG_SA_GUID	RAW	16
REF_GUID		Link Key for CMS_CAG_SA	CMS_DTE_CAG_SA_REF_GUID	RAW	16
SA_TYPE		Special Arrangement Type	CMS_DTE_CAG_SA_TYP	CHAR	6	TCMS_CAG_SA_TY
SA_ID		Special Arrangement ID	CMS_DTE_CAG_SA_ID	CHAR	40
PROC_STAT		Processing Status of Special Arrangement	CMS_DTE_CAG_SA_PROC_STAT	CHAR	2
LEGAL_STAT		Special Arrangement Legal Status	CMS_DTE_CAG_SA_LEGAL_STAT	CHAR	2
VALID_FROM		Date from which Special Arrangement Stands Valid	CMS_DTE_CAG_SA_VALID_FROM	DATS	8
VALID_TO		Date from which Special Arrangement Stands Valid	CMS_DTE_CAG_SA_VALID_TO	DATS	8
NOM_VALUE		Special Arrangement Nominal Value	CMS_DTE_CAG_SA_NOM_VALUE	CURR	17
NOM_VALUE_CURR		Currency of Special Arrangement: Nominal Value	CMS_DTE_CAG_SA_NOM_CURR	CUKY	5	TCURC
ASMT_AMT		Special Arrangement Assessment Amount	CMS_DTE_CAG_SA_ASMT_AMT	CURR	17
ASMT_AMT_CURR		Currency of Special Arrangement: Assessment Amount	CMS_DTE_CAG_SA_ASMT_CURR	CUKY	5	TCURC
BANK_CTRY		Bank country key	BANKS	CHAR	3	T005
BANK_KEY		Bank Keys	BANKK	CHAR	15
BANK_ACCT		Bank account number	BANKN35	CHAR	35
BANK_CTRL_KEY		Bank Control Key	BKONT	CHAR	2
REF_AGMT_ID		Pruchase Agreement ID of a Special Arrangement	CMS_DTE_CAG_SA_REFAGMT_ID	CHAR	40
REF_AGMT_DATE		Purchase Agreement Date of Special Arrangement	CMS_DTE_CAG_SA_REFAGMT_DATE	DATS	8
DESCRIPTION		Description for Special Arrangement	CMS_DTE_CAG_SA_DESC	CHAR	30
CREATED_BY		Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12
CREATED_AT		Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15
CHANGED_BY		Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12
CHANGED_AT		Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15
SOURCEOFENTRY		Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32