ATP_PLAF

Generated Table for View

ATP_PLAF is an SAP database table in S/4HANA. Generated Table for View. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Atpc_Cds_Plaf view from CDS View on PLAF Table for ATP

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnum PLNUM Planned Order
matnr PLMAT Material
plwrk PLWRK Planning Plant
pwwrk PWWRK Production Plant
gsmng GSMNG Order Quantity
avmng AVMNG Scrap Quantity
psttr PSTTR Order Start
pedtr PEDTR Order End Date
webaz PLWEZ GR Proc. Time
auffx PLAFX Firming Ind.
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
lgort LGORT_D Location
sobkz SOBKZ Special Stock
pspel PS_POSNR WBS Element
verto SA_VERTO Distribution
meins MEINS Base Unit
mdpbv MDPBV Avail.confirm.
wemng WEMNG Received
emlif EMLIF Supplier
lblkz LBLKZ SC Supplier
arsnr ARSNR Settle.reser.No
sobes SOBES Spec. procuremt
vrpla VRPLA W/o final assy
sgt_scat SGT_SCAT Stock Segment

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATP_PLAF (
    MANDT,     -- Client [MANDT]
    PLNUM,     -- Planned Order [PLNUM]
    MATNR,     -- Material [PLMAT]
    PLWRK,     -- Planning Plant [PLWRK]
    PWWRK,     -- Production Plant [PWWRK]
    GSMNG,     -- Order Quantity [GSMNG]
    AVMNG,     -- Scrap Quantity [AVMNG]
    PSTTR,     -- Order Start [PSTTR]
    PEDTR,     -- Order End Date [PEDTR]
    WEBAZ,     -- GR Proc. Time [PLWEZ]
    AUFFX,     -- Firming Ind. [PLAFX]
    KDAUF,     -- Sales Order [KDAUF]
    KDPOS,     -- Sales Ord. Item [KDPOS]
    LGORT,     -- Location [LGORT_D]
    SOBKZ,     -- Special Stock [SOBKZ]
    PSPEL,     -- WBS Element [PS_POSNR]
    VERTO,     -- Distribution [SA_VERTO]
    MEINS,     -- Base Unit [MEINS]
    MDPBV,     -- Avail.confirm. [MDPBV]
    WEMNG,     -- Received [WEMNG]
    EMLIF,     -- Supplier [EMLIF]
    LBLKZ,     -- SC Supplier [LBLKZ]
    ARSNR,     -- Settle.reser.No [ARSNR]
    SOBES,     -- Spec. procuremt [SOBES]
    VRPLA,     -- W/o final assy [VRPLA]
    SGT_SCAT,  -- Stock Segment [SGT_SCAT]
    PRIMARY KEY (MANDT, PLNUM)
);