P_INSURANCEOPENAPPLICATIONJRNL
P_INSURANCEOPENAPPLICATIONJRNL is a CDS View in S/4HANA. It contains 6 fields. 28 CDS views read from this table.
CDS Views using this table (28)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurPlcyPlndDateProcessing | view_entity | union_all | COMPOSITE | Planned Date Processing in Insur Policy |
| P_InsOpApSpecialEquipment | view_entity | inner | COMPOSITE | |
| P_InsOpApTypeRegionalClass | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplBeneficiary | view_entity | inner | COMPOSITE | Insurance Open Application Beneficiary |
| P_InsurOpenApplBnMlClmSrrndr | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplBonusMalus | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplBonusMalusCert | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplBonusMalusOwner | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplClaimComparison | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplClause | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplContract | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplCoverage | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplCoveragePackage | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplDeductible | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplicationPremium | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplInsrdPersn | view_entity | inner | COMPOSITE | Open Application - Insured Person Data |
| P_InsurOpenApplInsuredBuilding | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplInsuredObject | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplInsuredVehicle | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplLimit | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplNamedDriver | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplPolicyHolder | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplPremComparison | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplPremPayer | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplSubCoverage | view_entity | inner | COMPOSITE | |
| P_InsurOpenApplSurchrgDiscount | view_entity | inner | COMPOSITE | |
| P_InsurPlcyApplJrnlLatest | view_entity | inner | COMPOSITE | Application Journal Latest entry |
| P_InsurPlcyPremPayer | view_entity | inner | COMPOSITE | Premium Payer |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsuranceApplication | InsuranceApplication | 25 |
| KEY | InsurPlcyApplUUID | InsurPlcyApplUUID | 26 |
| KEY | InsurPlcyContrDataDetnJrnlNmbr | InsurPlcyContrDataDetnJrnlNmbr | 25 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 1 |
| InsuranceApplicationStatus | InsuranceApplicationStatus | 4 | |
| InsurPlcyUUID | InsurPlcyUUID | 25 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_INSURANCEOPENAPPLICATIONJRNL (
INSURANCEAPPLICATION,
INSURPLCYAPPLUUID,
INSURPLCYCONTRDATADETNJRNLNMBR,
INSURPLCYINSURCONTR,
INSURANCEAPPLICATIONSTATUS,
INSURPLCYUUID,
PRIMARY KEY (INSURANCEAPPLICATION, INSURPLCYAPPLUUID, INSURPLCYCONTRDATADETNJRNLNMBR, INSURPLCYINSURCONTR)
);
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