ATP_RESULT_SCHED

Transparent Table Application Table
29 Fields 1 CDS Views

Scheduling information of the item details of the ATP check

ATP_RESULT_SCHED is an SAP database table in S/4HANA. Scheduling information of the item details of the ATP check. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ATPResultShippingDates view from BASIC ATP Result Shipping Dates

Fields (29)

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
KEY resind atp_result_detail_resind Result Ind.
KEY atpdate mbdat Mat.Avail.Date
mat_avail_date mbdat Mat.Avail.Date
mat_avail_time mbuhr Matl Staging Tme
mat_avail_timezone tznzone Time Zone
trans_dispo_date tddat_d TranspPlngDate
trans_dispo_time tduhr Tr. Plan. Time
trans_dispo_timezone tznzone Time Zone
loading_date lddat Loading Date
loading_time lduhr Loading Time
loading_timezone tznzone Time Zone
goods_issue_date wadat Goods Issue
goods_issue_time wauhr GI Time
goods_issue_timezone tznzone Time Zone
delivery_date lfdat Delivery date
delivery_time lfuhr TimeOfDelivery
delivery_timezone tznzone Time Zone
unloading_date eldat GR End Date
unloading_time eluhr GR End Time
unloading_timezone tznzone Time Zone

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.

-- Scheduling information of the item details of the ATP check
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATP_RESULT_SCHED (
    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]
    RESIND,                -- Result Ind. [atp_result_detail_resind]
    ATPDATE,               -- Mat.Avail.Date [mbdat]
    MAT_AVAIL_DATE,        -- Mat.Avail.Date [mbdat]
    MAT_AVAIL_TIME,        -- Matl Staging Tme [mbuhr]
    MAT_AVAIL_TIMEZONE,    -- Time Zone [tznzone]
    TRANS_DISPO_DATE,      -- TranspPlngDate [tddat_d]
    TRANS_DISPO_TIME,      -- Tr. Plan. Time [tduhr]
    TRANS_DISPO_TIMEZONE,  -- Time Zone [tznzone]
    LOADING_DATE,          -- Loading Date [lddat]
    LOADING_TIME,          -- Loading Time [lduhr]
    LOADING_TIMEZONE,      -- Time Zone [tznzone]
    GOODS_ISSUE_DATE,      -- Goods Issue [wadat]
    GOODS_ISSUE_TIME,      -- GI Time [wauhr]
    GOODS_ISSUE_TIMEZONE,  -- Time Zone [tznzone]
    DELIVERY_DATE,         -- Delivery date [lfdat]
    DELIVERY_TIME,         -- TimeOfDelivery [lfuhr]
    DELIVERY_TIMEZONE,     -- Time Zone [tznzone]
    UNLOADING_DATE,        -- GR End Date [eldat]
    UNLOADING_TIME,        -- GR End Time [eluhr]
    UNLOADING_TIMEZONE,    -- Time Zone [tznzone]
    PRIMARY KEY (MANDT, CID, DELNR, DELPS, DELET, ATPCAT, ITEM_TYPE, RBA_STRATEGY_ID, POS, RESIND, ATPDATE)
);

Learn More