T418

Transparent Table Customizing (protected)
18 Fields 4 CDS Views

Item Categories

T418 is an SAP database table in S/4HANA. Item Categories. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BillOfMaterialItemCategory view from BASIC Bill of Material Item Category
I_EAMMaterialItemCategory view from BASIC Material Item Category
I_MaintComponentItemCategory view from BASIC Maintenance Component Item Category
I_ProdnModCompItemCategory view_entity inner BASIC Production Moel Bill of Material Item Category

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY postp POSTP Item Category
matin MATIN Material entry
kzbsf KZBSF Inventory mgmt
txpos TXPOS Text item
rtpos RTPOS Var-size item
klpos KLPOS Class item
btpos BTPOS PM structure
dkpos DKPOS Document item
mngvz MNGVZ Qty +/- sign
kzups KZUPS Subitem
pstrg PSTRG Item Control
inpos INPOS Intra Material
itmcatserviceprocmtusagecode ITMCATSERVICEPROCMTUSAGECODE Lean Service
itemcatisusedforenhancedlimits ITEMCATISUSEDFORENHANCEDLIMITS Enhanced Limit
cs_preliminary CS_PRELIMINARY Preliminary item
cs_reference CS_REFERENCE Reference Item
cs_nonplant CS_NONPLANT Non-Plant Item

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.

-- Item Categories
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T418 (
    MANDT,                           -- Client [MANDT]
    POSTP,                           -- Item Category [POSTP]
    MATIN,                           -- Material entry [MATIN]
    KZBSF,                           -- Inventory mgmt [KZBSF]
    TXPOS,                           -- Text item [TXPOS]
    RTPOS,                           -- Var-size item [RTPOS]
    KLPOS,                           -- Class item [KLPOS]
    BTPOS,                           -- PM structure [BTPOS]
    DKPOS,                           -- Document item [DKPOS]
    MNGVZ,                           -- Qty +/- sign [MNGVZ]
    KZUPS,                           -- Subitem [KZUPS]
    PSTRG,                           -- Item Control [PSTRG]
    INPOS,                           -- Intra Material [INPOS]
    ITMCATSERVICEPROCMTUSAGECODE,    -- Lean Service [ITMCATSERVICEPROCMTUSAGECODE]
    ITEMCATISUSEDFORENHANCEDLIMITS,  -- Enhanced Limit [ITEMCATISUSEDFORENHANCEDLIMITS]
    CS_PRELIMINARY,                  -- Preliminary item [CS_PRELIMINARY]
    CS_REFERENCE,                    -- Reference Item [CS_REFERENCE]
    CS_NONPLANT,                     -- Non-Plant Item [CS_NONPLANT]
    PRIMARY KEY (MANDT, POSTP)
);

Learn More