MAPL

Transparent Table Application Table
30 Fields 5 CDS Views

Assignment of Task Lists to Materials

MAPL is an SAP database table in S/4HANA. Assignment of Task Lists to Materials. It contains 30 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BOOMaterialAssgmtChangeState view from BASIC Change State of Material Assgmt to BOO
I_MfgEngShopFloorRtgMatlBasic view_entity inner BASIC Shop Floor Rtg with Material Assignment
I_RoutingMaterialSearchModel view_entity from BASIC Material assgmt. to BOO
P_ProdnRoutingMatlAssgmtDEX view_entity from BASIC
sdm_task_list view inner SDM: All Task List Tables

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnal PLNAL Group Counter
KEY zkriz DZKRIZ Add. Crit. Cntr
KEY zaehl CIM_COUNT Counter
datuv DATUV Valid From
techv TECHV Tech st from
aennr AENNR Change Number
loekz LKENZ Deletion Ind.
parkz PARKZ Inactive
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
lifnr ELIFN Supplier
kunr CPKUNR Customer
suchfeld QSUCHFELD Search Field
vbeln VBELN_VA Sales Document
posnr POSNR_VA Item
pspnr CS_PSPNR WBS Element
valid_to DATUB to
loekz_inherited LKENZ Deletion Ind.
versn PLNVERSN Routing Version
versn_source PLNVERSN_SOURCE_VERSN Source Version
versn_source_zkriz PLNVERSN_SOURCE_ZKRIZ Src. Assgnment No.
ms_object Q_MS_OBJECT Obj.(MultSpecs)
ms_objtype Q_MS_OBJTYPE Object Type

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.

-- Assignment of Task Lists to Materials
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAPL (
    MANDT,               -- Client [MANDT]
    MATNR,               -- Material [MATNR]
    WERKS,               -- Plant [WERKS_D]
    PLNTY,               -- Task List Type [PLNTY]
    PLNNR,               -- Group [PLNNR]
    PLNAL,               -- Group Counter [PLNAL]
    ZKRIZ,               -- Add. Crit. Cntr [DZKRIZ]
    ZAEHL,               -- Counter [CIM_COUNT]
    DATUV,               -- Valid From [DATUV]
    TECHV,               -- Tech st from [TECHV]
    AENNR,               -- Change Number [AENNR]
    LOEKZ,               -- Deletion Ind. [LKENZ]
    PARKZ,               -- Inactive [PARKZ]
    ANDAT,               -- Created On [ANDAT]
    ANNAM,               -- Created by [ANNAM]
    AEDAT,               -- Changed On [AEDAT]
    AENAM,               -- Changed By [AENAM]
    LIFNR,               -- Supplier [ELIFN]
    KUNR,                -- Customer [CPKUNR]
    SUCHFELD,            -- Search Field [QSUCHFELD]
    VBELN,               -- Sales Document [VBELN_VA]
    POSNR,               -- Item [POSNR_VA]
    PSPNR,               -- WBS Element [CS_PSPNR]
    VALID_TO,            -- to [DATUB]
    LOEKZ_INHERITED,     -- Deletion Ind. [LKENZ]
    VERSN,               -- Routing Version [PLNVERSN]
    VERSN_SOURCE,        -- Source Version [PLNVERSN_SOURCE_VERSN]
    VERSN_SOURCE_ZKRIZ,  -- Src. Assgnment No. [PLNVERSN_SOURCE_ZKRIZ]
    MS_OBJECT,           -- Obj.(MultSpecs) [Q_MS_OBJECT]
    MS_OBJTYPE,          -- Object Type [Q_MS_OBJTYPE]
    PRIMARY KEY (MANDT, MATNR, WERKS, PLNTY, PLNNR, PLNAL, ZKRIZ, ZAEHL)
);

Learn More