CACS_S_CS_DOCSE SAP (Commission Document: Line Items) Structure details
Description: Commission Document: Line Items
Related tables to CACS_S_CS_DOCSE
Access table CACS_S_CS_DOCSE
Structure field list including key, data, relationships and ABAP select examples
CACS_S_CS_DOCSE 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 Document: Line Items" 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_S_CS_DOCSE TYPE CACS_S_CS_DOCSE.
The CACS_S_CS_DOCSE table consists of various fields, each holding specific information or linking keys about Commission Document: Line Items data available in SAP. These include MANDT (Client), POST_YEAR (Assignment Year of Commission Case/Document), DOC_ID (Document Identification), SETTL_POS (Identification of a Settlement Item).. 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_S_CS_DOCSE 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_DOCSE | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
POST_YEAR | Assignment Year of Commission Case/Document | CACSPSTYEAR | NUMC | 4 | KJAHR | CACSPSTYEAR | |||
DOC_ID | Document Identification | CACSDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | CACSDOCID | ||
SETTL_POS | Identification of a Settlement Item | CACSSETTLPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | CACSFLGREV | CHAR | 1 | FLAG | ||||
STATUS_POS | Status of Object/Subobject | CACSSTATUSPOS | CHAR | 1 | CACSSTATUSVERS | ||||
STATUS_WORK | Object Processing Status (Replica) | CACSSTATUSWORKP | CHAR | 1 | CACSSTATUSWORK | ||||
CTRTBU_ID | Commission Contract Number | CACS_CTRTBU_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACSCTBU | CACS | |
GPART | Business Partner to Receive Commission | CACS_GPART_INV | CHAR | 10 | ALPHA | BU_PARTNER | |||
DUE_DATE | Due Date of Line Item | CACSDUEDAT | DATS | 8 | DATUM | ||||
DUE_YEAR | Year Due: Document Item | CACSDUEYEAR | NUMC | 4 | KJAHR | ||||
DUE_MONTH | Period in Year Due | CACSDUEMON | NUMC | 2 | MONAT | ||||
STMTYPE_ID | Identification of Settlement Type | CACS_STMTYPE_ID | CHAR | 4 | CACSSTMTY | ||||
REMUNERATION | Remuneration Type | CACSREM | CHAR | 4 | CACSREM | CACS_REM | |||
SETTLE_GROUP | Settlement Item Grouping in Document | CACSSETTLEGROUP | CHAR | 4 | ALPHA | CACSDOCLINE | |||
FLG_INTSETTLE | Settlement Item Serves Immediate Clearing | CACSINTSETTLEMENT | CHAR | 1 | BOOLEAN_FLG | ||||
DET_GRP | Grouping of Due Line Item Detail in Document | CACSSETTLEDETGRP | CHAR | 4 | ALPHA | CACSDETGRP | |||
CON_CURR | Contract Currency Key | CACSCONCURR | CUKY | 5 | WAERS | FWS | |||
DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | CACSDUECONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
LED_CURR | Currency Key | CACSLEDCURR | CUKY | 5 | WAERS | ||||
DUE_LEDAMNT | Disbursable Partial Remuner.Amount in Comm. Model Currency | CACSDUELEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REM_UNIT | Remuneration Unit | CACSREMUUNIT | UNIT | 3 | CUNIT | MEINS | |||
DUE_QUAN | Remuneration Quantity Ready for Disbursement | CACSDUEQUAN | QUAN | 11(2) | CACSREMUQUAN | ||||
SETTLE_DATE | Settlement Date | CACSSETTLEDATE | DATS | 8 | DATUM | ||||
SETTLE_POST_YEAR | Posting Year of Settlement Document | CACSDOCYEARSETTLE | NUMC | 4 | KJAHR | ||||
SETTLE_DOC_ID | Settlement Document Number | CACSDOCIDSETTLE | CHAR | 10 | ALPHA | CACSOBJID10 | |||
PMNT_BLOCK | Payment Block Key | DZLSPR | CHAR | 1 | ZAHLS | SPE | |||
REM_CASE_TXT | Short Text for Settlement Item | CACSSETTLCASETXT | CHAR | 40 | CACSSHORTTXT | ||||
REV_POS | Reversing Row of Related Reversal Document | CACSREVPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
SETT_LOCK | Indicator: Item Waiting for Subsequent Process | CACSSETTLOCK | CHAR | 1 | CACSITMLCK | ||||
UPD_TIMESTAMP | Last Change of Objects | CACSUPDTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
WA_DOCRE | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
POST_YEAR | Assignment Year of Commission Case/Document | CACSPSTYEAR | NUMC | 4 | KJAHR | CACSPSTYEAR | |||
DOC_ID | Document Identification | CACSDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | CACSDOCID | ||
REMUN_POS | ID of Remuneration Row for Referenced Document | CACSREMUNPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
FLG_COMPL | Indicator: Document Part Created by Complete Update | CACSFLGCOMPL | CHAR | 1 | BOOLEAN_FLG | ||||
FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | CACSFLGREV | CHAR | 1 | FLAG | ||||
STATUS_POS | Status of Object/Subobject | CACSSTATUSPOS | CHAR | 1 | CACSSTATUSVERS | ||||
STATUS_WORK | Object Processing Status (Replica) | CACSSTATUSWORKP | CHAR | 1 | CACSSTATUSWORK | ||||
PART_POS | Position of Participation in a Commission Case | CACSPARTID | CHAR | 4 | ALPHA | CACSDOCLINE | |||
INV_POS | Participant Position in a Participation | CACSINVPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
CTRTBU_ID | Commission Contract Number | CACS_CTRTBU_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACSCTBU | CACS | |
BUCAGR_ID | Agreement Number | CACS_BUCAGR_ID | CHAR | 12 | CHAR12 | ||||
CLAIM_OBJTYPE | Entitlement Object Type | CACSCLAIMOBJTYPE | CHAR | 1 | CACSCLAIMOBJTYPE | ||||
CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | CACSCLAIMOBJID | CHAR | 30 | CACSOBJID30NOCONV | ||||
REM_IMP_YEAR | Year Commission Case Reported | CACSIMPYEAR | NUMC | 4 | KJAHR | CACSIMPYEAR | |||
REM_CASE_ID | Identification of a Case Resulting in Remuneration | CACSREMCASEID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
REM_CASE_VERS | Commission Case Version | CACSCASEVERS | NUMC | 6 | CACSVERSION | CACSCASEVERS | |||
POW_OBJ_TYPE | Subobject Type Where Activity Originates | CACSPOWOBJ | CHAR | 5 | CACSOBTYID | ||||
POW_OBJ_ID | Identification of Subobject of Activity Provided | CACSPOWOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
ACTIVITY | Activity Type | CACSACT | CHAR | 4 | CACSACT | ||||
ACT_POS | Identification of an Activity Line | CACSACTPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
ACTGRP | Role | CACSACTGRP | CHAR | 4 | CACSACTGRP | CACS_TCACS_ACTGRP | |||
REM_OBJ_TYPE | Remunerating Subobject Type | CACSREMOBJ | CHAR | 5 | CACSOBTYID | CACS_OBJDAT | |||
REM_OBJ_ID | Identification of Subobject Resulting in Remuneration | CACSREMOBJID | CHAR | 12 | ALPHA | CACSOBJID12 | |||
VALUE | Valuation Type | CACSVAL | CHAR | 4 | CACSVAL | CACS_VAL | |||
VALUE_TYPE | Valuation Result Category | CACSVALTYPE | NUMC | 1 | CACSVALTYPE | ||||
VALUE_POS | Valuation Row Identification | CACSVALUEPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
REMVAL_LEDAMNT | Remuneration Value in Commission Model Currency | CACSREMVALAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REMVAL_QUAN | Remuneration Value (Volume) | CACSREMVALQUAN | QUAN | 11(2) | CACSEVALQUAN | ||||
VALUE_UNIT | Valuation Unit | CACSEVALUNIT | UNIT | 3 | CUNIT | MEINS | |||
ROLE | Participant Role | CACSROLE | CHAR | 3 | CACSROLE | CACSROLE | |||
ROLE_REMUSHAR | Share of Remuneration (in Percent) | CACSREMUSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
CONSTELL | Constellation of Participants | CACSCONS | CHAR | 4 | CHAR4 | ||||
DIST_TYPE | Remuneration Participation Category | CACSDISTTYPE | CHAR | 1 | CACSDISTTYPE | ||||
CON_CURR | Contract Currency Key | CACSCONCURR | CUKY | 5 | WAERS | FWS | |||
LED_CURR | Currency Key | CACSLEDCURR | CUKY | 5 | WAERS | ||||
ALLOCATION | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | CACSALLOC | CHAR | 1 | CACSALLOC | ||||
REMUNERATION | Remuneration Type | CACSREM | CHAR | 4 | CACSREM | CACS_REM | |||
REM_VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | CACSVERSION | ||||
REM_RATE | Remuneration Record (For Example, Percentage) | CACSREMRATE | DEC | 8(3) | CACSPERCENT | ||||
REM_CONAMNT | Remuneration Entitlement, Amount in Contract Currency | CACSREMUCONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | CACSDUECONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REM_LEDAMNT | Remunerat. Entitlement, Amount in Commission Model Currency | CACSREMULEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
DUE_LEDAMNT | Disbursable Partial Remuner.Amount in Comm. Model Currency | CACSDUELEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
REM_UNIT | Remuneration Unit | CACSREMUUNIT | UNIT | 3 | CUNIT | MEINS | |||
REM_QUAN | Remuneration Entitlement as Quantity | CACSREMUQUAN | QUAN | 11(2) | CACSREMUQUAN | ||||
DUE_QUAN | Remuneration Quantity Ready for Disbursement | CACSDUEQUAN | QUAN | 11(2) | CACSREMUQUAN | ||||
OFFSET_END_DATE | End of Offsetting | CACSOFFSEDAT | DATS | 8 | DATUM | ||||
OFFSET_RULE_ID | Offsetting Type | CACSOFFSETRULE | CHAR | 4 | CACSOFFSETRULE | ||||
OFFSET_CONAMNT | Remaining Offset Amount in Contract Currency | CACSOFFSCONAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
OFFSET_LEDAMNT | Offsetting/Secondary Liability Amt Remaining in ComModCurr. | CACSOFFSLEDAMNT | CURR | 15(2) | CACSAMNTITEM | ||||
OFFSET_QUAN | Offsetting/Remaining Secondary Liability Quantity | CACSOFFSQUAN | QUAN | 11(2) | CACSRESPQUAN | ||||
CORRBY_DOC_ID | Document Used to Correct This Row | CACSCORRBYDOCID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
CORRBY_PST_YEAR | Assignment Year Document Used for Correcting Row | CACSCORRBYPSTYEAR | NUMC | 4 | KJAHR | ||||
CORRBY_PST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | CACSPSTDAT | DATS | 8 | DATUM | ||||
CORRTO_DOC_ID | ID of Corrected Document | CACSCORRTODOCID | CHAR | 10 | ALPHA | CACSOBJID10 | |||
CORRTO_PST_YEAR | Assignment Year Document That Corrected This Row | CACSCORRTOPSTYEAR | NUMC | 4 | KJAHR | ||||
CORRTO_REMUN_POS | ID of Remuneration Row in Corrected Document | CACSCORRTOREMUNPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
FLG_CORR | Indicator: Document Part Created by a Correction | CACSFLGCORR | CHAR | 1 | BOOLEAN_FLG | ||||
SETTLE_GROUP | Settlement Item Grouping in Document | CACSSETTLEGROUP | CHAR | 4 | ALPHA | CACSDOCLINE | |||
UPD_TIMESTAMP | Last Change of Objects | CACSUPDTSTMP | NUMC | 14 | TSTPS | CACSTIMESTAMP |
Key field | Non-key field |
How do I retrieve data from SAP structure CACS_S_CS_DOCSE using ABAP code?
As CACS_S_CS_DOCSE 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_S_CS_DOCSE as there is no data to select.How to access SAP table CACS_S_CS_DOCSE
Within an ECC or HANA version of SAP you can also view further information about CACS_S_CS_DOCSE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects