EHFNDW_CCI_BPNC

Transparent Table Application Table
15 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 15 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 (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY chmlcmplncbrnddprodcntryuuid EHFND_CCI_BPNC_UUID Branded Product Name Country
chmlcmplncbrnddprodnameuuid EHFND_CCI_BPN_UUID Branded Product Name
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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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,   -- Branded Product Name Country [EHFND_CCI_BPNC_UUID]
    CHMLCMPLNCBRNDDPRODNAMEUUID,    -- Branded Product Name [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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CHMLCMPLNCBRNDDPRODCNTRYUUID)
);

Learn More