V_ICLPART_ROLES
Generated Table for View
V_ICLPART_ROLES is an SAP database table in S/4HANA. Generated Table for View. It contains 15 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SHSM_V_ICLPART_ROLES | view | from | CDS View als Ersatz für V_ICLPART_ROLES |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | active | ICL_ACTIVE | Active/Suspense | |||
| KEY | claim | ICL_CLAIM | Claim Number | |||
| KEY | subobjcat | ICL_SUBOBJCAT | Subobject Cat. | |||
| KEY | subobject | ICL_SUBOBJECT | Claim Subobject | |||
| KEY | role | ICL_ROLE | ParticipantRole | |||
| KEY | participant | ICL_PART | Participant | |||
| KEY | client2 | MANDT | Client | |||
| KEY | partner | BU_PARTNER | Busn. Partner | |||
| KEY | client3 | MANDT | Client | |||
| KEY | langu | LANGU | Language | |||
| role2 | ICL_ROLE | ParticipantRole | ||||
| name | ICL_ROLEN | Participant Role | ||||
| name_last | BU_NAMEP_L | Last Name | ||||
| name_first | BU_NAMEP_F | First Name |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_ICLPART_ROLES (
CLIENT, -- Client [MANDT]
ACTIVE, -- Active/Suspense [ICL_ACTIVE]
CLAIM, -- Claim Number [ICL_CLAIM]
SUBOBJCAT, -- Subobject Cat. [ICL_SUBOBJCAT]
SUBOBJECT, -- Claim Subobject [ICL_SUBOBJECT]
ROLE, -- ParticipantRole [ICL_ROLE]
PARTICIPANT, -- Participant [ICL_PART]
CLIENT2, -- Client [MANDT]
PARTNER, -- Busn. Partner [BU_PARTNER]
CLIENT3, -- Client [MANDT]
LANGU, -- Language [LANGU]
ROLE2, -- ParticipantRole [ICL_ROLE]
NAME, -- Participant Role [ICL_ROLEN]
NAME_LAST, -- Last Name [BU_NAMEP_L]
NAME_FIRST, -- First Name [BU_NAMEP_F]
PRIMARY KEY (CLIENT, ACTIVE, CLAIM, SUBOBJCAT, SUBOBJECT, ROLE, PARTICIPANT, CLIENT2, PARTNER, CLIENT3, LANGU)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA