CACS_CS_CTRTBU SAP (Commission Contract) Structure details

Dictionary Type: Structure
Description: Commission Contract




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




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

CACS_CS_CTRTBU is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Commission Contract" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CACS_CS_CTRTBU TYPE CACS_CS_CTRTBU.

The CACS_CS_CTRTBU table consists of various fields, each holding specific information or linking keys about Commission Contract data available in SAP. These include MANDT (Client), APPL (Commission Application (ICM)), CTRTBU_ID (Commission Contract Number), VERSION (Version of Master Data or Customizing Object).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CACS_CS_CTRTBU structure 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
WA_CONTRACT 0
MANDTClient MANDTCLNT3MANDT
APPLCommission Application (ICM) CACSAPPLCHAR6CACSAPPLCACSAPPLCACS_APPLCL
CTRTBU_IDCommission Contract Number CACS_CTRTBU_IDCHAR20ALPHAISIS_CONTRACT_IDCACSCTBUCACS
VERSIONVersion of Master Data or Customizing Object CACSVERSIONNUMC6CACSVERSION
CTRTST_IDNumber of Standard Commission Contract CACS_CTRTST_IDCHAR20ALPHAISIS_CONTRACT_IDCACST
GPARTNumber of Commission Contract Partner CACS_GPARTCHAR10ALPHABU_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 CACSCONCURRCUKY5WAERSFWS
CHG_REASONReason for Changing Contract CACSCHGREASONCHAR3CACSCHGREASON
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 CACSCDTCCHAR20TCODE
CHG_USRLast user to change object CACSCHUSRCHAR12USNAM
TRI_METH_TYPTriggering Method CACSTRIMETHTYPCHAR1CACSOPTYPE
TRI_METH_TARGETProcessing Target of Triggering Method CACSTRIMETHTARCHAR1CACSTRITARGET
STATUS_VERSIONObject Version Status CACSSTATUSVERSCHAR1CACSSTATUSVERS
STATUS_WORKObject Version Processing Status CACSSTATUSWORKCHAR1CACSSTATUSWORK
RECEIVERCorrespondence Recipient ID CORR_PARTNER_KKCHAR10ALPHABU_PARTNERBPABUPA
RECEIVER_DSCCorrespondence Recipient: Description CACS_PARTNER_KKCHAR50CHAR50
IND_RECEIVCorrespondence - Activity Key CORR_ACKEY_KKCHAR4CORR_ACKEY_KK
COPRCCorrespondence Variant COPRC_KKCHAR4COPRC_KK
INT_TITLEInternal Title CACS_ITITLECHAR3CHAR3
TERM_OF_NOTPeriod of notice CACS_TERM_OF_NOTCHAR3CHAR3
TERM_DATECancellation Date CACS_TERM_DATECHAR3CHAR3
FLG_STOPCASEContract Means Commission Case is Set to Pending (Obsolete) CACS_FLG_STOPCASECHAR1BOOLEAN_FLG
XDELECentral Archiving Flag CACS_XDELECHAR1XFELD
FILTERIDIdentification of an Activity Filter CACSACTFILTERCHAR8ALPHACACSFILTERIDDO
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
WA_BUSPARTNER 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4BU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4BU_JOBGR
NATIONationality BU_NATIOCHAR3LAND1
CNTAXObsolete Field BU_CNTAXCHAR3LAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
LGTYPLegitimation Type BU_LGTYPCHAR4BU_LGTYP
LGNUMIdentification number of legitimation document BU_LGNUMCHAR16BU_LGNUM
INFCTResponsible local court BU_INFCTCHAR30BU_INFCT
COMRGEntry in commercial register BU_COMRGCHAR30CHAR30
CLBRGBP: Entry in register of associations BU_CLBRGCHAR30CHAR30
COPRGEntry in Register of Cooperatives BU_COPRGCHAR30CHAR30
COMREG_DATDate of entry in trade register BU_COMREG_DATDATS8DATUM
.INCLU--AP 0
M_BONIWERTCreditworthiness value set manually BONIWRT_KKNUMC4BONIT_KK
M_BONIDATDate on Which Creditworthiness was Manually Set BONIDAT_KKDATS8DATUM
NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
T_DOCSE 0

Key field Non-key field



How do I retrieve data from SAP structure CACS_CS_CTRTBU using ABAP code?

As CACS_CS_CTRTBU is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CACS_CS_CTRTBU as there is no data to select.

How to access SAP table CACS_CS_CTRTBU

Within an ECC or HANA version of SAP you can also view further information about CACS_CS_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!