/PM0/ABDADISTREL
Distribution Plan Relationship
/PM0/ABDADISTREL is an SAP database table in S/4HANA. Distribution Plan Relationship. It contains 20 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_InsurPlcyDistrPlnRelshp | view_entity | from | EXTENSION | Insur Distribution Plan - Extension |
| I_InsurPlcyDistrPlnRelshpBasic | view_entity | from | BASIC | Distr Plan Relshp in Insurance Policy |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | policy_id | /PM0/ABD_POLICY_ID | Policy Key | |||
| KEY | policyproduct_id | /PM0/ABD_POLPR_ID | Contract Key | |||
| KEY | journalendno_id | /PM0/ABJ_JOURNALENDNO_ID | Term. Jour. No. | |||
| KEY | journalno_id | /PM0/ABJ_JOURNALNO_ID | Journal Number | |||
| KEY | covpac_id | /PM0/ABD_COVPAC_ID | Cov.Package ID | |||
| KEY | coverage_id | /PM0/ABD_COVERAGE_ID | Coverage Key | |||
| KEY | distrel_id | /PM0/ABD_DISTREL_ID | DPR Key | |||
| ppdpac_id | /PM0/ABD_PPDPAC_ID | Prod. Pckg. Key | ||||
| cancel_fg | /PM0/ABD_CANCEL_FG | Rev. Flag | ||||
| distribplannr_tt | /PM0/ABD_DISTRIBPLANNR_TT | DP Number | ||||
| templnr_tt | /PM0/ABD_TEMPLNR_TT | DistPl.Templ.No | ||||
| pm_id | /PM0/ABD_MODELPM_ID | Template ID | ||||
| cointp_cd | /PM0/ABD_COINSURANCETP_CD | Coins. Type | ||||
| dpjournalno_id | /PM0/ABD_DPJOURNALNO_ID | Journal Number | ||||
| dc_gd | /PM0/ABD_CON_ID | Container ID | ||||
| customer_pb_ci | CHAR1 | Single-Character Flag | ||||
| delete_ex | /PMG/DEL_BF_UPD | Delete existing Co. | ||||
| bo_cd | /PM0/ABD_BO_CD | BObj. Flag | ||||
| change_ts | /PM0/ABD_CHANGE_TS | Time Stamp |
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.
-- Distribution Plan Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PM0/ABDADISTREL (
CLIENT, -- Client [MANDT]
POLICY_ID, -- Policy Key [/PM0/ABD_POLICY_ID]
POLICYPRODUCT_ID, -- Contract Key [/PM0/ABD_POLPR_ID]
JOURNALENDNO_ID, -- Term. Jour. No. [/PM0/ABJ_JOURNALENDNO_ID]
JOURNALNO_ID, -- Journal Number [/PM0/ABJ_JOURNALNO_ID]
COVPAC_ID, -- Cov.Package ID [/PM0/ABD_COVPAC_ID]
COVERAGE_ID, -- Coverage Key [/PM0/ABD_COVERAGE_ID]
DISTREL_ID, -- DPR Key [/PM0/ABD_DISTREL_ID]
PPDPAC_ID, -- Prod. Pckg. Key [/PM0/ABD_PPDPAC_ID]
CANCEL_FG, -- Rev. Flag [/PM0/ABD_CANCEL_FG]
DISTRIBPLANNR_TT, -- DP Number [/PM0/ABD_DISTRIBPLANNR_TT]
TEMPLNR_TT, -- DistPl.Templ.No [/PM0/ABD_TEMPLNR_TT]
PM_ID, -- Template ID [/PM0/ABD_MODELPM_ID]
COINTP_CD, -- Coins. Type [/PM0/ABD_COINSURANCETP_CD]
DPJOURNALNO_ID, -- Journal Number [/PM0/ABD_DPJOURNALNO_ID]
DC_GD, -- Container ID [/PM0/ABD_CON_ID]
CUSTOMER_PB_CI, -- Single-Character Flag [CHAR1]
DELETE_EX, -- Delete existing Co. [/PMG/DEL_BF_UPD]
BO_CD, -- BObj. Flag [/PM0/ABD_BO_CD]
CHANGE_TS, -- Time Stamp [/PM0/ABD_CHANGE_TS]
PRIMARY KEY (CLIENT, POLICY_ID, POLICYPRODUCT_ID, JOURNALENDNO_ID, JOURNALNO_ID, COVPAC_ID, COVERAGE_ID, DISTREL_ID)
);
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