PACTLG_PATH

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 Path
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PACTLG_PATH (
    CLIENT,                          -- Client [mandt]
    PRODALLOCCHARCCTLGPATHUUID,      -- Product Allocation Characteristic Catalog Path UUID [prodalloccharcctlgpathuuid]
    PRODALLOCCHARCCTLGPATHINTID,     -- Catalog Path Internal ID [prodalloccharcctlgpathintid]
    PRODALLOCCHARCCATALOGUUID,       -- Product Allocation Characteristic Catalog UUID [prodalloccharccataloguuid]
    PRODALLOCCHARCCATALOGTYPE,       -- Catalog Type [prodalloccharccatalogtype]
    PRODALLOCCHARCCATALOGUSETYPE,    -- Catalog Use Type [prodalloccharccatalogusetype]
    PRODALLOCCHARCCTLGPARPATHINTID,  -- Catalog Parent Path Internal ID [prodalloccharcctlgparpathintid]
    PRODALLOCCHARCCATALOGCHARCTYPE,  -- Characteristic Type [prodalloccharccatalogcharctype]
    PRODALLOCCHARCCATALOGPATHTYPE,   -- Characteristic Path Type [prodalloccharccatalogpathtype]
    CLFNCHARACTERISTICUSETYPE,       -- Type [clfncharacteristicusetype]
    CHARCCATALOGPATHHIERARCHYTYPE,   -- Hierarchy Type [charccatalogpathhierarchytype]
    ABAPDATAELEMENT,                 -- Data Element [rollname]
    PRODALLOCCHARCCTLGPATHSELNAME,   -- Path Selection Name [prodalloccharcctlgpathselname]
    PRODALLOCCHARCCTLGPATHSEL,       -- Characteristic Catalog Path Selection [prodalloccharcctlgpathsel]
    PRODALLOCCHARCCATALOGPATH,       -- Charc Catalog Path [prodalloccharccatalogpath]
    PRODALLOCCHARCCTLGALTVPATH,      -- Alternative Path [prodalloccharcctlgaltvpath]
    PRODALLOCCHARCCTLGLEGACYPATH,    -- Legacy Path [prodalloccharcctlglegacypath]
    PRODALLOCCHARCVALUEHELP,         -- Value Help [prodalloccharcvaluehelp]
    PRODALLOCCHARCVALHELPTBLFIELD,   -- Value Help Field [prodalloccharcvalhelptblfield]
    PRODALLOCCHARCVALHELPTEXTLINK,   -- Value Help Text Link [prodalloccharcvalhelptextlink]
    PRODALLOCCHARCVALHELPTXTTBLFLD,  -- Value Help Text Field [prodalloccharcvalhelptxttblfld]
    PRODALLOCCHARCCTLGLEGACYTABLE,   -- Legacy Table [prodalloccharcctlglegacytable]
    PRODALLOCCHARCCTLGCHARC,         -- Characteristic [prodalloccharcctlgcharc]
    PRODALLOCCHARCCTLGPATHISHIDDEN,  -- Catalog Characteristic Path Is Hidden [prodalloccharcctlgpathishidden]
    PRODALLOCCHARCCTLGPATHISROOT,    -- Catalog Characteristic Path Is Root [prodalloccharcctlgpathisroot]
    CHARACTERISTICUNITPATHINTID,     -- Unit Internal Identifier [characteristicunitpathintid]
    CHARCVALEXISTENCECHECKTYPE,      -- Value Existence Check Type [charcvalexistencechecktype]
    ABAPDICTIONARYDATATYPE,          -- Data Type [datatype_d]
    ABAPDICTIONARYDATATYPELENGTH,    -- No. of Characters [ddleng]
    ABAPDICTIONARYDATATYPEDECIMALS,  -- Decimal Places [decimals]
    ABAPOUTPUTLENGTHVALUE,           -- Output Length [outputlen]
    CHARCVALUEISCASESENSITIVE,       -- Case Sensitive [charcvalueiscasesensitive]
    CHARCVALUECONVERSIONROUTINE,     -- Conversion Routine [charcvalueconversionroutine]
    CHARCINTERNALID,                 -- Characteristic Internal ID [atinn_no_conv]
    CHARACTERISTICUNIT,              -- Characteristic Unit [characteristicunit]
    CHARACTERISTICVALUEGROUPUNIT,    -- Value Group Unit [characteristicvaluegroupunit]
    CHARACTERISTICVALUEGROUPTYPE,    -- Value Group Type [characteristicvaluegrouptype]
    CHARCISONLYUSABLEINVALUEGROUPS,  -- Value Group Only [charcisonlyusableinvaluegroups]
    CHARCCATALOGCHARACTERISTICNAME,  -- Characteristic Name [charccatalogcharacteristicname]
    PRIMARY KEY (CLIENT, PRODALLOCCHARCCTLGPATHUUID)
);