PACTLG

Transparent Table Application Table

Product Allocation Characteristic Catalog

PACTLG is an SAP database table in S/4HANA. Product Allocation Characteristic Catalog. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdAllocCharcCatalog view from BASIC Product Allocation Characteristic Catalog
P_ProdAllocAuthznGroupVH view_entity inner BASIC Value Help View for Product Allocation Authorization Groups

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client 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
createdbyuser pal_createdbyuser Created by User
lastchangedatetime pal_lastchangedatetime Last Change Date Time
lastchangedbyuser pal_lastchangedbyuser Last Changed by User
charcctlgisenbldforsalesorder charcctlgisenbldforsalesorder Enabled for Sales
charcctlgisenbldforstktranspt charcctlgisenbldforstktranspt Enabled for Stock Transport
charcctlgisenbldforpurgdoc charcctlgisenbldforpurgdoc Enabled for Purchasing

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.

-- Product Allocation Characteristic Catalog
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PACTLG (
    CLIENT,                         -- 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]
    CREATEDBYUSER,                  -- Created by User [pal_createdbyuser]
    LASTCHANGEDATETIME,             -- Last Change Date Time [pal_lastchangedatetime]
    LASTCHANGEDBYUSER,              -- Last Changed by User [pal_lastchangedbyuser]
    CHARCCTLGISENBLDFORSALESORDER,  -- Enabled for Sales [charcctlgisenbldforsalesorder]
    CHARCCTLGISENBLDFORSTKTRANSPT,  -- Enabled for Stock Transport [charcctlgisenbldforstktranspt]
    CHARCCTLGISENBLDFORPURGDOC,     -- Enabled for Purchasing [charcctlgisenbldforpurgdoc]
    PRIMARY KEY (CLIENT, PRODALLOCCHARCCATALOGUUID)
);