SAP Tabel TCACS_TGCLC (Target Agreement: Classification Category)

SAP table TCACS_TGCLC has 4 primary key fields being MANDT,APPL,CATEG,VERSION.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
APPL Commission Application (ICM) CHAR 6 0 TCACS_APPLDEF CACSAPPL
CATEG Target Agreements: Target Classification Category CHAR 4 0 CACS_TGTCLFCATEG
VERSION Version of Master Data or Customizing Object NUMC 6 0 CACSVERSION
BUSI_BEGIN Effective from NUMC 14 0 CACS_BUSITIME_B
BUSI_END Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) NUMC 14 0 CACS_BUSITIME_E
TECH_BEGIN Technically Valid From NUMC 14 0 CACS_TECHTIME_B
TECH_END Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) NUMC 14 0 CACS_TECHTIME_E
FLG_CANCEL_OBJ Indicator: Object is Invalid CHAR 1 0 CACSCANCOBJ
FLG_CANCEL_VERS Indicator: Version is Invalid CHAR 1 0 CACSCANCVERS
CHG_TCODE Transaction in Which the Change Was Made CHAR 20 0 * CACSCDTC
CHG_USR Last user to change object CHAR 12 0 CACSCHUSR
TRI_METH_TYP Triggering Method CHAR 1 0 CACSTRIMETHTYP
TRI_METH_TARGET Processing Target of Triggering Method CHAR 1 0 CACSTRIMETHTAR
STATUS_VERSION Object Version Status CHAR 1 0 TCACS_VALSTAT1 CACSSTATUSVERS
/ Unknown
0 Inconsistent (incorrect)
1 Consistent (o.k. - not double checked)
2 Checked consistent (o.k. - double checked)
3 Consistency checked (ok - approved)
4 Consistent (ok - not approved)
STATUS_WORK Object Version Processing Status CHAR 1 0 TCACS_VALSTAT1 CACSSTATUSWORK
$ Simulated (Not Used in this Release)
- Rejected (Not Stored on DB)
/ Unknown
0 Accepted
1 For Checking (Dual Check)
2 Waiting f. Predecess.
3 Parked
4 To be approved
5 Not approved after examination
6 For Checking (Triggered by Predec.)
8 Rejected (After Dual Check)
9 Released for Subseq.Processes

TCACS_TGCLC foreign key relationships

Table Field Check Table Check Field
0 TCACS_TGCLC APPL TCACS_APPLDEF All Commission Applications APPL
1 TCACS_TGCLC STATUS_VERSION TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUSCLASS
1 TCACS_TGCLC STATUS_VERSION TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_WORK
0 TCACS_TGCLC STATUS_WORK TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUSCLASS
0 TCACS_TGCLC STATUS_WORK TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_WORK