CACS_CTRTBU SAP (Commission Contract) Table details

Dictionary Type: Table
Description: Commission Contract




ABAP Code to SELECT data from CACS_CTRTBU
Related tables to CACS_CTRTBU
Access table CACS_CTRTBU




Table field list including key, data, relationships and ABAP select examples

CACS_CTRTBU is a standard SAP Table which is used to store Commission Contract data and is available within R/3 SAP systems depending on the version and release level.

The CACS_CTRTBU table consists of various fields, each holding specific information or linking keys about Commission Contract data available in SAP. These include APPL (Commission Application (ICM)), CTRTBU_ID (Commission Contract Number), VERSION (Version of Master Data or Customizing Object), CTRTST_ID (Number of Standard Commission Contract).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CACS_CTRTBU table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
APPLCommission Application (ICM) CACSAPPLCHAR6TCACS_APPLDEFCACSAPPLCACSAPPLCACS_APPLCL
CTRTBU_IDCommission Contract Number CACS_CTRTBU_IDCHAR20CACS_CONTRALPHAISIS_CONTRACT_IDCACSCTBUCACS
VERSIONVersion of Master Data or Customizing Object CACSVERSIONNUMC6CACSVERSION
CTRTST_IDNumber of Standard Commission Contract CACS_CTRTST_IDCHAR20CACS_CTRTSTALPHAISIS_CONTRACT_IDCACST
GPARTNumber of Commission Contract Partner CACS_GPARTCHAR10BUT000ALPHABU_PARTNER
CTRTBU_BDATEStart Date of Commission Contract CACS_CTRTBU_BDDATS8DATS
CTRTBU_EDATEEnd Date of Commission Contract CACS_CTRTBU_EDDATS8DATS
ENTR_DATEEntry Date of Commission Recipient CACS_ENTR_DATEDATS8DATS
LEAV_DATECommission Recipient's Leaving Date CACS_LEAV_DATEDATS8DATS
CON_CURRContract Currency Key CACSCONCURRCUKY5TCURCWAERSFWS
CHG_REASONReason for Changing Contract CACSCHGREASONCHAR3TCACS_CTRCHCACSCHGREASON
BUSI_BEGINEffective from CACS_BUSITIME_BNUMC14TSTPSCACSTIMESTAMP
BUSI_ENDEffective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) CACS_BUSITIME_ENUMC14TSTPSCACSTIMESTAMP
TECH_BEGINTechnically Valid From CACS_TECHTIME_BNUMC14TSTPSCACSTIMESTAMP
TECH_ENDTechnically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) CACS_TECHTIME_ENUMC14TSTPSCACSTIMESTAMP
FLG_CANCEL_OBJIndicator: Object is Invalid CACSCANCOBJCHAR1BOOLEAN_FLG
FLG_CANCEL_VERSIndicator: Version is Invalid CACSCANCVERSCHAR1BOOLEAN_FLG
CHG_TCODETransaction in Which the Change Was Made CACSCDTCCHAR20Assigned to domainTCODE
CHG_USRLast user to change object CACSCHUSRCHAR12USNAM
TRI_METH_TYPTriggering Method CACSTRIMETHTYPCHAR1CACSOPTYPE
TRI_METH_TARGETProcessing Target of Triggering Method CACSTRIMETHTARCHAR1CACSTRITARGET
STATUS_VERSIONObject Version Status CACSSTATUSVERSCHAR1TCACS_VALSTAT1CACSSTATUSVERS
STATUS_WORKObject Version Processing Status CACSSTATUSWORKCHAR1TCACS_VALSTAT1CACSSTATUSWORK
RECEIVERCorrespondence Recipient ID CORR_PARTNER_KKCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RECEIVER_DSCCorrespondence Recipient: Description CACS_PARTNER_KKCHAR50CHAR50
IND_RECEIVCorrespondence - Activity Key CORR_ACKEY_KKCHAR4TFK070LCORR_ACKEY_KK
COPRCCorrespondence Variant COPRC_KKCHAR4TFK070BCOPRC_KK
INT_TITLEInternal Title CACS_ITITLECHAR3TCACS_ITITLECHAR3
TERM_OF_NOTPeriod of notice CACS_TERM_OF_NOTCHAR3TCACS_TOFNCHAR3
TERM_DATECancellation Date CACS_TERM_DATECHAR3TCACS_TERMDCHAR3
FLG_STOPCASEContract Means Commission Case is Set to Pending (Obsolete) CACS_FLG_STOPCASECHAR1BOOLEAN_FLG
XDELECentral Archiving Flag CACS_XDELECHAR1XFELD
FILTERIDIdentification of an Activity Filter CACSACTFILTERCHAR8Assigned to domainALPHACACSFILTERIDDO
CTRTBU_ID_EXTExternal Identification of Commission Contract CACS_CTRTBU_ID_EXTCHAR20ISIS_CONTRACT_ID_EXT
LVRSIDTermination Reason CACSLVRSIDCHAR2CHAR02
.INCLU--AP 0
.INCLU--AP 0
.INCLU--AP 0
.INCLU--AP 0

Key field Non-key field



How do I retrieve data from SAP table CACS_CTRTBU using ABAP code

The following ABAP code Example will allow you to do a basic selection on CACS_CTRTBU to SELECT all data from the table
DATA: WA_CACS_CTRTBU TYPE CACS_CTRTBU.

SELECT SINGLE *
FROM CACS_CTRTBU
INTO CORRESPONDING FIELDS OF WA_CACS_CTRTBU
WHERE...

How to access SAP table CACS_CTRTBU

Within an ECC or HANA version of SAP you can also view further information about CACS_CTRTBU and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!