EHFNDW_CCI_BPNC

Transparent Table Application Table
9 Fields 1 CDS Views

I_CHMLCMPLNCINFOTP I_CHMLCMPLNCBRNDDPRODCNTRYTP

EHFNDW_CCI_BPNC is an SAP database table in S/4HANA. I_CHMLCMPLNCINFOTP I_CHMLCMPLNCBRNDDPRODCNTRYTP. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChmlCmplncBrnddProdCntryDrft view_entity from BASIC Branded Product Country - Draft

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY chmlcmplncbrnddprodcntryuuid ehfnd_cci_bpnc_uuid
chmlcmplncbrnddprodnameuuid ehfnd_cci_bpn_uuid
chmlcmplncinfouuid ehfnd_cci_uuid Chemical Compliance Information
country ehfnd_country_id Country / Region
creationdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangedatetime timestampl Time Stamp
lastchangedbyuser uname User 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.

-- I_CHMLCMPLNCINFOTP I_CHMLCMPLNCBRNDDPRODCNTRYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_CCI_BPNC (
    MANDT,                         -- Client [mandt]
    CHMLCMPLNCBRNDDPRODCNTRYUUID,  -- ehfnd_cci_bpnc_uuid
    CHMLCMPLNCBRNDDPRODNAMEUUID,   -- ehfnd_cci_bpn_uuid
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [ehfnd_cci_uuid]
    COUNTRY,                       -- Country / Region [ehfnd_country_id]
    CREATIONDATETIME,              -- Time Stamp [timestampl]
    CREATEDBYUSER,                 -- User Name [uname]
    LASTCHANGEDATETIME,            -- Time Stamp [timestampl]
    LASTCHANGEDBYUSER,             -- User Name [uname]
    PRIMARY KEY (MANDT, CHMLCMPLNCBRNDDPRODCNTRYUUID)
);

Learn More