ATP_RESULT_ITEM

Transparent Table Application Table

Information about the items which are part of ATP check

ATP_RESULT_ITEM is an SAP database table in S/4HANA. Information about the items which are part of ATP check. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ATPResultRequirement view from BASIC ATP Result Requirement

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cid atp_cid Check ID
KEY delnr delnr MRP element number
KEY delps delps MRP elemnt item
KEY delet delet Scheduling
KEY atpcat delkz MRP Elmnt Ind.
KEY item_type atp_item_type Item type
KEY rba_strategy_id abap.char
KEY pos atp_tabix Index
delps_main delps MRP elemnt item
material matnr Material
plant werks_d Plant
sobkz sobkz Special Stock
lgort lgort_d Location
batch charg_d Batch
prreg prreg Checking rule
trtyp trtyp Transact. type
bop_strategy atp_bop_confirmation_strategy Confirmation Strategy
bop_segment_id atp_bop_segment_uuid BOP Segment UUID
status atp_item_status Status
sequence atp_sequence Sequence Number
base_uom meins Base Unit

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.

-- Information about the items which are part of ATP check
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATP_RESULT_ITEM (
    MANDT,            -- Client [mandt]
    CID,              -- Check ID [atp_cid]
    DELNR,            -- MRP element number [delnr]
    DELPS,            -- MRP elemnt item [delps]
    DELET,            -- Scheduling [delet]
    ATPCAT,           -- MRP Elmnt Ind. [delkz]
    ITEM_TYPE,        -- Item type [atp_item_type]
    RBA_STRATEGY_ID,  -- abap.char
    POS,              -- Index [atp_tabix]
    DELPS_MAIN,       -- MRP elemnt item [delps]
    MATERIAL,         -- Material [matnr]
    PLANT,            -- Plant [werks_d]
    SOBKZ,            -- Special Stock [sobkz]
    LGORT,            -- Location [lgort_d]
    BATCH,            -- Batch [charg_d]
    PRREG,            -- Checking rule [prreg]
    TRTYP,            -- Transact. type [trtyp]
    BOP_STRATEGY,     -- Confirmation Strategy [atp_bop_confirmation_strategy]
    BOP_SEGMENT_ID,   -- BOP Segment UUID [atp_bop_segment_uuid]
    STATUS,           -- Status [atp_item_status]
    SEQUENCE,         -- Sequence Number [atp_sequence]
    BASE_UOM,         -- Base Unit [meins]
    PRIMARY KEY (MANDT, CID, DELNR, DELPS, DELET, ATPCAT, ITEM_TYPE, RBA_STRATEGY_ID, POS)
);