1. Home
  2. Resources
  3. SAP Tables
  4. -

SAP Table

() is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link to other SAP tables.

table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
ROLE ID of a Role in Portfolio Assignment (PFO) PFO_ROLE CHAR 4 0
TR_FLAG Transport Indicator for Versioned Tables CACS_TR_FLAG CHAR 1 0
VERSION Version of Master Data or Customizing Object CACSVERSION NUMC 6 0
ROLEKIND Role Type for Business Assignment or Segment Assignment PFO_ROLEKIND CHAR 4 0
GZO Role Between Business Object and Segment
SZO Role Between Assignment Object and Segment
OBJKIND Object Kind (References Entity) PFO_OBJKIND CHAR 4 0
GO Business Object
GZO Business Assignment Object
SG Segment
SZO Segment Assignment Object
ZO Assignment Object
COM Permitted Combinations
OBT Object Type
SGT Segment Types
ROL Roles
OBJTYPE Object Type (Portfolio Assignment) PFO_OBJTYPE CHAR 4 0
DIVIDE Indicator: Role May Be Divided Up PFO_ROLE_DIV CHAR 1 0
X TRUE
NULL FALSE
UNIQUE_ROLE Indicator: Role is Unique PFO_ROLE_UNIQ CHAR 1 0
X TRUE
NULL FALSE
TA_RELEVANT Indicator: Role is Relevant for Target Agreements (TA) PFO_ROLE_TA_REL CHAR 1 0
NULL Not Relevant for TA
X Relevant for TA
MAX_VAL Maximum Value of a Divisible Role PFO_MAX_VAL DEC 15 5
TOL_VAL Tolerance of Divisible Roles PFO_TOL DEC 15 5
BUSI_BEGIN Effective from CACS_BUSITIME_B NUMC 14 0
BUSI_END Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) CACS_BUSITIME_E NUMC 14 0
TECH_BEGIN Technically Valid From CACS_TECHTIME_B NUMC 14 0
TECH_END Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) CACS_TECHTIME_E NUMC 14 0
FLG_CANCEL_OBJ Indicator: Object is Invalid CACSCANCOBJ CHAR 1 0
X True
NULL False
FLG_CANCEL_VERS Indicator: Version is Invalid CACSCANCVERS CHAR 1 0
X True
NULL False
CHG_TCODE Transaction in Which the Change Was Made CACSCDTC CHAR 20 0
CHG_USR Last user to change object CACSCHUSR CHAR 12 0
TRI_METH_TYP Triggering Method CACSTRIMETHTYP CHAR 1 0
1 Create
2 Change
8 Reset
TRI_METH_TARGET Processing Target of Triggering Method CACSTRIMETHTAR CHAR 1 0
0 Accept Only
1 Wait for Check (Double Check Priciple)
2 Wait for Predecessor (Prevents Continuation)
3 Park
6 Wait for Check (Triggered by Predecessor)
8 Reject (After Double Check)
9 Release for Subsequent Processes (Posting)
7 Checked and Released
STATUS_VERSION Object Version Status CACSSTATUSVERS TCACS_VALSTAT1 CHAR 1 0
STATUS_WORK Object Version Processing Status CACSSTATUSWORK TCACS_VALSTAT1 CHAR 1 0

foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TPFO_ROL STATUS_VERSION '1' TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUSCLASS
TPFO_ROL STATUS_VERSION TPFO_ROL STATUS_VERSION TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_VERSION
TPFO_ROL STATUS_VERSION TPFO_ROL STATUS_WORK TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_WORK
TPFO_ROL STATUS_WORK TPFO_ROL STATUS_WORK TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_WORK
TPFO_ROL STATUS_WORK '1' TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUSCLASS
TPFO_ROL STATUS_WORK TPFO_ROL STATUS_VERSION TCACS_VALSTAT1 Allowed Status Combinations Process/Version STATUS_VERSION