PACTLGD

Transparent Table Application Table
21 Fields 1 CDS Views

I_PRODALLOCCHARCCATALOGTP I_PRODALLOCCHARCCATALOGTP

PACTLGD is an SAP database table in S/4HANA. I_PRODALLOCCHARCCATALOGTP I_PRODALLOCCHARCCATALOGTP. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProdAllocCharcCatalog view_entity union_all COMPOSITE Product Alloc. Charc. Catalog with Draft

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prodalloccharccataloguuid PRODALLOCCHARCCATALOGUUID Product Allocation Characteristic Catalog UUID
prodalloccharccatalogtype PRODALLOCCHARCCATALOGTYPE Catalog Type
prodalloccharccatalogusetype PRODALLOCCHARCCATALOGUSETYPE Catalog Use Type
lastgenerationutcdatetime LASTGENERATIONUTCDATETIME Generation Date Time
creationdatetime PAL_CREATIONDATETIME Creation Date Time
creationdate PAL_CREATIONDATE Creation Date
createdbyuser PAL_CREATEDBYUSER Created by User
lastchangedatetime PAL_LASTCHANGEDATETIME Last Change Date Time
lastchangedate PAL_LASTCHANGEDATE Last Change Date
lastchangedbyuser PAL_LASTCHANGEDBYUSER Last Changed by User
charcctlgisenbldforsalesorder CHARCCTLGISENBLDFORSALESORDER Enabled for Sales
charcctlgisenbldforstktranspt CHARCCTLGISENBLDFORSTKTRANSPT Enabled for Stock Transport
charcctlgisenbldforpurgdoc CHARCCTLGISENBLDFORPURGDOC Enabled for Purchasing
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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_PRODALLOCCHARCCATALOGTP I_PRODALLOCCHARCCATALOGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PACTLGD (
    MANDT,                          -- Client [MANDT]
    PRODALLOCCHARCCATALOGUUID,      -- Product Allocation Characteristic Catalog UUID [PRODALLOCCHARCCATALOGUUID]
    PRODALLOCCHARCCATALOGTYPE,      -- Catalog Type [PRODALLOCCHARCCATALOGTYPE]
    PRODALLOCCHARCCATALOGUSETYPE,   -- Catalog Use Type [PRODALLOCCHARCCATALOGUSETYPE]
    LASTGENERATIONUTCDATETIME,      -- Generation Date Time [LASTGENERATIONUTCDATETIME]
    CREATIONDATETIME,               -- Creation Date Time [PAL_CREATIONDATETIME]
    CREATIONDATE,                   -- Creation Date [PAL_CREATIONDATE]
    CREATEDBYUSER,                  -- Created by User [PAL_CREATEDBYUSER]
    LASTCHANGEDATETIME,             -- Last Change Date Time [PAL_LASTCHANGEDATETIME]
    LASTCHANGEDATE,                 -- Last Change Date [PAL_LASTCHANGEDATE]
    LASTCHANGEDBYUSER,              -- Last Changed by User [PAL_LASTCHANGEDBYUSER]
    CHARCCTLGISENBLDFORSALESORDER,  -- Enabled for Sales [CHARCCTLGISENBLDFORSALESORDER]
    CHARCCTLGISENBLDFORSTKTRANSPT,  -- Enabled for Stock Transport [CHARCCTLGISENBLDFORSTKTRANSPT]
    CHARCCTLGISENBLDFORPURGDOC,     -- Enabled for Purchasing [CHARCCTLGISENBLDFORPURGDOC]
    ACTIVEUUID,                     -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, PRODALLOCCHARCCATALOGUUID)
);

Learn More