TCACS_PCINV SAP (Participation Construction: Participants Template) Table details
Dictionary Type: Table
Description: Participation Construction: Participants Template
Description: Participation Construction: Participants Template
Table field list including key, data, relationships and ABAP select examples
TCACS_PCINV is a standard SAP Table which is used to store Participation Construction: Participants Template data and is available within R/3 SAP systems depending on the version and release level.
The TCACS_PCINV table consists of various fields, each holding specific information or linking keys about Participation Construction: Participants Template data available in SAP. These include APPL (Commission Application (ICM)), METHOD (Participation Construction: Method), INV_POS (Participant Position in a Participation), 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: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TCACS_PCINV 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 |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| APPL | Commission Application (ICM) | CACSAPPL | CHAR | 6 | TCACS_APPLDEF | CACSAPPL | CACSAPPL | CACS_APPLCL | |
| METHOD | Participation Construction: Method | CACSPCMETHOD | CHAR | 5 | TCACS_PCMET | CACSPCMETHOD | |||
| INV_POS | Participant Position in a Participation | CACSINVPOS | CHAR | 4 | ALPHA | CACSDOCLINE | |||
| VERSION | Version of Master Data or Customizing Object | CACSVERSION | NUMC | 6 | CACSVERSION | ||||
| GPART | Business Partner to Receive Commission | CACS_GPART_INV | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
| CTRTBU_ID | Commission Contract Number | CACS_CTRTBU_ID | CHAR | 20 | ALPHA | ISIS_CONTRACT_ID | CACSCTBU | CACS | |
| ROLE | Participant Role | CACSROLE | CHAR | 3 | Assigned to domain | CACSROLE | CACSROLE | ||
| ROLE_COMMSHAR | Share of Direct Remuneration (in Percent) | CACSCOMMSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
| ROLE_PRODSHAR | Share of Indirect Remuneration (in Percent) | CACSPRODSHARE | DEC | 10(5) | CACSPERCENT5 | ||||
| DISTRIBUTE | Distribution Key for the Activity Share | CACSDISTRIBUTE | INT4 | 10 | |||||
| FLG_CONSTELL | Indicator: Ignore Commissions Contract in Constellation | CACSFLGCONS | CHAR | 1 | BOOLEAN_FLG | ||||
| ROLETYPE | Entitlement Category | CACSCLAIMTYPE | CHAR | 1 | TCACS_CLT | CACSCLAIMTYPEDO | |||
| CLAIM_OBJTYPE | Entitlement Object Type | CACSCLAIMOBJTYPE | CHAR | 1 | CACSCLAIMOBJTYPE | ||||
| CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | CACSCLAIMOBJID | CHAR | 30 | CACSOBJID30NOCONV | ||||
| INV_POS_PARENT | Position of a Higher-Level Participant in a Participation | CACSINVPOSPARENT | CHAR | 4 | ALPHA | CACSDOCLINE | |||
| BUSI_BEGIN | Effective from | CACS_BUSITIME_B | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
| BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | CACS_BUSITIME_E | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
| TECH_BEGIN | Technically Valid From | CACS_TECHTIME_B | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
| TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | CACS_TECHTIME_E | NUMC | 14 | TSTPS | CACSTIMESTAMP | |||
| FLG_CANCEL_OBJ | Indicator: Object is Invalid | CACSCANCOBJ | CHAR | 1 | BOOLEAN_FLG | ||||
| FLG_CANCEL_VERS | Indicator: Version is Invalid | CACSCANCVERS | CHAR | 1 | BOOLEAN_FLG | ||||
| CHG_TCODE | Transaction in Which the Change Was Made | CACSCDTC | CHAR | 20 | Assigned to domain | TCODE | |||
| CHG_USR | Last user to change object | CACSCHUSR | CHAR | 12 | USNAM | ||||
| TRI_METH_TYP | Triggering Method | CACSTRIMETHTYP | CHAR | 1 | CACSOPTYPE | ||||
| TRI_METH_TARGET | Processing Target of Triggering Method | CACSTRIMETHTAR | CHAR | 1 | CACSTRITARGET | ||||
| STATUS_VERSION | Object Version Status | CACSSTATUSVERS | CHAR | 1 | TCACS_VALSTAT1 | CACSSTATUSVERS | |||
| STATUS_WORK | Object Version Processing Status | CACSSTATUSWORK | CHAR | 1 | TCACS_VALSTAT1 | CACSSTATUSWORK |
| Key field | Non-key field |
How do I retrieve data from SAP table TCACS_PCINV using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCACS_PCINV to SELECT all data from the tableDATA: WA_TCACS_PCINV TYPE TCACS_PCINV.
SELECT SINGLE *
FROM TCACS_PCINV
INTO CORRESPONDING FIELDS OF WA_TCACS_PCINV
WHERE...
How to access SAP table TCACS_PCINV
Within an ECC or HANA version of SAP you can also view further information about TCACS_PCINV 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