P_CMPLRQVERSUNIONNAMEONLIST

CDS View

P_CMPLRQVERSUNIONNAMEONLIST is a CDS View in S/4HANA. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SubstanceNameOnList view from BASIC Substance Name on List View

Fields (7)

KeyField CDS FieldsUsed in Views
KEY db_key SubstanceNameOnListUUID 1
language Language 1
listed_substance_name_uuid ListedSubstanceNameUUID 1
listsub_id ListedSubstance 1
name_sequence SubstanceNameOnListSequence 1
parent_key SubstanceListUUID 1
root_key CmplRqVersUUID 1

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_CMPLRQVERSUNIONNAMEONLIST (
    DB_KEY,
    LANGUAGE,
    LISTED_SUBSTANCE_NAME_UUID,
    LISTSUB_ID,
    NAME_SEQUENCE,
    PARENT_KEY,
    ROOT_KEY,
    PRIMARY KEY (DB_KEY)
);