PLAF

Transparent Table Application Table
140 Fields 22 CDS Views

Planned Order

PLAF is an SAP database table in S/4HANA. Planned Order. It contains 140 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
arun_i_plaf view from Planned order selection
ARUN_SSD_PREV view left_outer Get supply specific SO preview
ATPC_CDS_PLPW view from CDS view on PLPW/PLAF for ATP
atpc_dvol_peak_creation_tstmp view left_outer Data Volume for Peaks with Creation Timestamp
E_PlannedOrder view from EXTENSION Planned Order - Extension
I_PlannedOrder view from BASIC Planned Order
I_PlndOrdCustCoByPlant view_entity from BASIC Planned Order Customer Company By Plant
I_PlndOrdSupplierCoByPlant view_entity from BASIC Planned Order Supplier Company By Plant
I_SupDmndAllDocPlndOrdBsc view from BASIC Basic View for Planned Order
I_SupDmndAllDocPlndOrdComp view inner BASIC View for Planned Order Components
I_SupDmndOvwPlannedOrder view from BASIC Basic View for Planned Order
MDCV_E_ATP_PLPW view from Compatibility View for view ATP_PLPW
MDCV_E_KDPL view from Compatibility View for table KDPL
MDCV_E_MDUP view from Compatibility View for view MDUP
MDCV_E_PLIX view from Compatibility View for view PLIX
MDCV_E_PLPW view from Compatibility View for table PLPW
MDCV_E_PSPL view from Compatibility View for table PSPL
pp_mrp_read_planned_order_comp view left_outer Read Planned Order Components
PPH_E_PLAF_PW view from
pph_e_Plaf_rg view from
PPH_E_PLAF_UL view from
SHSM_PLAF view from CDS Search Help for Planned Order replacing PLAF

Fields (140)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnum PLNUM Planned Order
matnr PLMAT Material
plwrk PLWRK Planning Plant
pwwrk PWWRK Production Plant
paart PAART Planned Order Type
beskz BESKZ Procurement
sobes SOBES Spec. procuremt
gsmng GSMNG Order Quantity
tlmng TLMNG Partial Lot Qty
avmng AVMNG Scrap Quantity
bdmng BDMNG Requirement qty
psttr PSTTR Order Start
pedtr PEDTR Order End Date
pertr PERTR Opening Date
webaz PLWEZ GR Proc. Time
dispo DISPO MRP Controller
umskz PLUMS Conversion Ind.
auffx PLAFX Firming Ind.
stlfx PLSFX Fixed Explosion
knttp KNTTP Acct Assgmt Cat
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
kdein KDEIN SOrder schedule
projn PROJN not in use
rsnum RSNUM Reservation
qunum QUNUM Quota arr.
qupos QUPOS Quota arr. item
flief FLIEF Fixed Vendor
konnr KONNR Agreement
ktpnr KTPNR Agreement Item
ekorg EKORG Purchasing Org.
lgort LGORT_D Location
numvr NUMVR Version number
kzvbr KZVBR Consumption
sobkz SOBKZ Special Stock
pspel PS_POSNR WBS Element
sernr SERNR BOM expl.number
paltr PALTR Explosion Date
techs TECHS StandardVariant
stlan STLAN Usage
stalt STALT Alternative
ststa STLST BOM Status
aennr AENNR Change Number
arsnr ARSNR Settle.reser.No
arsps ARSPS Settle.item no.
verto SA_VERTO Distribution
verid VERID Prod. Version
aufnr SA_AUFNR RS header
trart TRART Scheduling Type
plgrp FEVOR Prodn Supervisor
terst TERST Production Start Dte
tered TERED Production End Date
bedid BEDID Capacity Requirement
aufpl CO_AUFPL Plan No.f.Oper.
linid SP_OPID Number
trmkz TRMFL Scheduling
trmer TRMER Schedul. Error
redkz REDKZ Reduction Ind.
trmhk TRMHK Schedul. Source
plnnr PLNNR Group
plnal PLNAL Group Counter
plnty PLNTY Task List Type
frthw FRTHW Production note
rgekz CO_RGEKZ Backflushing
meins MEINS Base Unit
cuobj CUOBJ Int. object no.
revlv REVLV Revision Level
abmng ABMNG Reduced Qty
ratid RATID Rate ID
groid GROID Rough sched. ID
rater RATER SchedError rate
groer GROER Sched.error
obart OBART Object type
plscn PLSCN Planning Scenario
sbnum SBNUM Sim.requmts no.
kbnkz KBNKZ Kanban Indicat.
kapfx KAPFX Cap. Dispatched
seqnr CY_SEQNR Sequence Number
pstti PSTTI Order Start Time
pedti PEDTI Order End Time
monkz MONKZ Assembly Orders
prnkz PRNKZ Coll. Order
mdpbv MDPBV Avail.confirm.
vfmng VFMNG Committed Qty
mdach MDACH Action Control
mdacc MDACC Action(PlndOrd)
mdacd MDACD Action Date
mdact MDACT Action Time
gsbtr GSBTR_PLAF Commitment Date
pletx PLETX Shift qties
prsch MD_PRSCHED By prod. dates
lvsch MD_LVSCHED Scheduling lvl
kzavc KZAVC Type avail.chck
vrpla VRPLA W/o final assy
pbdnr PBDNR Requirements Plan
agreq AGREQ Aggregate reqmts
umrez UMREZ Numerator
umren UMREN Denominator
erfmg ERFMG Quantity in UnE
erfme ERFME Unit of Entry
rqnum RQNUM Requirement
kzbws KZBWS Valuation
wemng WEMNG Received
wamng WAMNG Issued
edgno EDGNO Edge obj. dep.
lblkz LBLKZ SC Supplier
emlif EMLIF Supplier
berid BERID MRP Area
uberi UBERI from MRP area
ematn EMATN MPN: Material
remfl REMFL Repetitive Mfg
pstmp PSTMP Time Stamp
puser PUSER User
badi MD_BADI BADI
staex MD_STAEX Status
reslo RESLO Iss. Stor. Loc.
srm_contract_id SRM_CONTRACT_ID Central Contract
srm_contract_itm SRM_CONTRACT_ITEM Cent. Contract Item
org_req_date DAT00 Planned dates
ptext PP_PLORD_TEXT Planned Order Text
dummy_plaf_incl_eew_ps CFD_DUMMY Dummy
medkz MEDKZ Distributed
cnfqty MD_MES_CNF_QTY Confirmed Qty
sgt_scat SGT_SCAT Stock Segment
plifz PLIFZ Pl. Deliv. Time
bom_versn CS_VERSN BOM Version
dac_pp_component EPP_COMPONENT_ID Component
dac_indirect_access DAC_INDIRECT_ACCESS Indirect
dac_creation_date SYDATUM Current Date
m_mrp XFELD Checkbox
kunnr KUNNR Customer
flg_bundle FLG_BUNDLE Bundle
fsh_mplnd_ord FSH_MPLO_ORD Master Plnd Ord.
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
atrkz ATRKZ Request ID
dps_handover_time SYPP_DPS_HANDOVER_TIME DPS Handover Time

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.

-- Planned Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PLAF (
    MANDT,                   -- Client [MANDT]
    PLNUM,                   -- Planned Order [PLNUM]
    MATNR,                   -- Material [PLMAT]
    PLWRK,                   -- Planning Plant [PLWRK]
    PWWRK,                   -- Production Plant [PWWRK]
    PAART,                   -- Planned Order Type [PAART]
    BESKZ,                   -- Procurement [BESKZ]
    SOBES,                   -- Spec. procuremt [SOBES]
    GSMNG,                   -- Order Quantity [GSMNG]
    TLMNG,                   -- Partial Lot Qty [TLMNG]
    AVMNG,                   -- Scrap Quantity [AVMNG]
    BDMNG,                   -- Requirement qty [BDMNG]
    PSTTR,                   -- Order Start [PSTTR]
    PEDTR,                   -- Order End Date [PEDTR]
    PERTR,                   -- Opening Date [PERTR]
    WEBAZ,                   -- GR Proc. Time [PLWEZ]
    DISPO,                   -- MRP Controller [DISPO]
    UMSKZ,                   -- Conversion Ind. [PLUMS]
    AUFFX,                   -- Firming Ind. [PLAFX]
    STLFX,                   -- Fixed Explosion [PLSFX]
    KNTTP,                   -- Acct Assgmt Cat [KNTTP]
    KDAUF,                   -- Sales Order [KDAUF]
    KDPOS,                   -- Sales Ord. Item [KDPOS]
    KDEIN,                   -- SOrder schedule [KDEIN]
    PROJN,                   -- not in use [PROJN]
    RSNUM,                   -- Reservation [RSNUM]
    QUNUM,                   -- Quota arr. [QUNUM]
    QUPOS,                   -- Quota arr. item [QUPOS]
    FLIEF,                   -- Fixed Vendor [FLIEF]
    KONNR,                   -- Agreement [KONNR]
    KTPNR,                   -- Agreement Item [KTPNR]
    EKORG,                   -- Purchasing Org. [EKORG]
    LGORT,                   -- Location [LGORT_D]
    NUMVR,                   -- Version number [NUMVR]
    KZVBR,                   -- Consumption [KZVBR]
    SOBKZ,                   -- Special Stock [SOBKZ]
    PSPEL,                   -- WBS Element [PS_POSNR]
    SERNR,                   -- BOM expl.number [SERNR]
    PALTR,                   -- Explosion Date [PALTR]
    TECHS,                   -- StandardVariant [TECHS]
    STLAN,                   -- Usage [STLAN]
    STALT,                   -- Alternative [STALT]
    STSTA,                   -- BOM Status [STLST]
    AENNR,                   -- Change Number [AENNR]
    ARSNR,                   -- Settle.reser.No [ARSNR]
    ARSPS,                   -- Settle.item no. [ARSPS]
    VERTO,                   -- Distribution [SA_VERTO]
    VERID,                   -- Prod. Version [VERID]
    AUFNR,                   -- RS header [SA_AUFNR]
    TRART,                   -- Scheduling Type [TRART]
    PLGRP,                   -- Prodn Supervisor [FEVOR]
    TERST,                   -- Production Start Dte [TERST]
    TERED,                   -- Production End Date [TERED]
    BEDID,                   -- Capacity Requirement [BEDID]
    AUFPL,                   -- Plan No.f.Oper. [CO_AUFPL]
    LINID,                   -- Number [SP_OPID]
    TRMKZ,                   -- Scheduling [TRMFL]
    TRMER,                   -- Schedul. Error [TRMER]
    REDKZ,                   -- Reduction Ind. [REDKZ]
    TRMHK,                   -- Schedul. Source [TRMHK]
    PLNNR,                   -- Group [PLNNR]
    PLNAL,                   -- Group Counter [PLNAL]
    PLNTY,                   -- Task List Type [PLNTY]
    FRTHW,                   -- Production note [FRTHW]
    RGEKZ,                   -- Backflushing [CO_RGEKZ]
    MEINS,                   -- Base Unit [MEINS]
    CUOBJ,                   -- Int. object no. [CUOBJ]
    REVLV,                   -- Revision Level [REVLV]
    ABMNG,                   -- Reduced Qty [ABMNG]
    RATID,                   -- Rate ID [RATID]
    GROID,                   -- Rough sched. ID [GROID]
    RATER,                   -- SchedError rate [RATER]
    GROER,                   -- Sched.error [GROER]
    OBART,                   -- Object type [OBART]
    PLSCN,                   -- Planning Scenario [PLSCN]
    SBNUM,                   -- Sim.requmts no. [SBNUM]
    KBNKZ,                   -- Kanban Indicat. [KBNKZ]
    KAPFX,                   -- Cap. Dispatched [KAPFX]
    SEQNR,                   -- Sequence Number [CY_SEQNR]
    PSTTI,                   -- Order Start Time [PSTTI]
    PEDTI,                   -- Order End Time [PEDTI]
    MONKZ,                   -- Assembly Orders [MONKZ]
    PRNKZ,                   -- Coll. Order [PRNKZ]
    MDPBV,                   -- Avail.confirm. [MDPBV]
    VFMNG,                   -- Committed Qty [VFMNG]
    MDACH,                   -- Action Control [MDACH]
    MDACC,                   -- Action(PlndOrd) [MDACC]
    MDACD,                   -- Action Date [MDACD]
    MDACT,                   -- Action Time [MDACT]
    GSBTR,                   -- Commitment Date [GSBTR_PLAF]
    PLETX,                   -- Shift qties [PLETX]
    PRSCH,                   -- By prod. dates [MD_PRSCHED]
    LVSCH,                   -- Scheduling lvl [MD_LVSCHED]
    KZAVC,                   -- Type avail.chck [KZAVC]
    VRPLA,                   -- W/o final assy [VRPLA]
    PBDNR,                   -- Requirements Plan [PBDNR]
    AGREQ,                   -- Aggregate reqmts [AGREQ]
    UMREZ,                   -- Numerator [UMREZ]
    UMREN,                   -- Denominator [UMREN]
    ERFMG,                   -- Quantity in UnE [ERFMG]
    ERFME,                   -- Unit of Entry [ERFME]
    RQNUM,                   -- Requirement [RQNUM]
    KZBWS,                   -- Valuation [KZBWS]
    WEMNG,                   -- Received [WEMNG]
    WAMNG,                   -- Issued [WAMNG]
    EDGNO,                   -- Edge obj. dep. [EDGNO]
    LBLKZ,                   -- SC Supplier [LBLKZ]
    EMLIF,                   -- Supplier [EMLIF]
    BERID,                   -- MRP Area [BERID]
    UBERI,                   -- from MRP area [UBERI]
    EMATN,                   -- MPN: Material [EMATN]
    REMFL,                   -- Repetitive Mfg [REMFL]
    PSTMP,                   -- Time Stamp [PSTMP]
    PUSER,                   -- User [PUSER]
    BADI,                    -- BADI [MD_BADI]
    STAEX,                   -- Status [MD_STAEX]
    RESLO,                   -- Iss. Stor. Loc. [RESLO]
    SRM_CONTRACT_ID,         -- Central Contract [SRM_CONTRACT_ID]
    SRM_CONTRACT_ITM,        -- Cent. Contract Item [SRM_CONTRACT_ITEM]
    ORG_REQ_DATE,            -- Planned dates [DAT00]
    PTEXT,                   -- Planned Order Text [PP_PLORD_TEXT]
    DUMMY_PLAF_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    MEDKZ,                   -- Distributed [MEDKZ]
    CNFQTY,                  -- Confirmed Qty [MD_MES_CNF_QTY]
    SGT_SCAT,                -- Stock Segment [SGT_SCAT]
    PLIFZ,                   -- Pl. Deliv. Time [PLIFZ]
    BOM_VERSN,               -- BOM Version [CS_VERSN]
    DAC_PP_COMPONENT,        -- Component [EPP_COMPONENT_ID]
    DAC_INDIRECT_ACCESS,     -- Indirect [DAC_INDIRECT_ACCESS]
    DAC_CREATION_DATE,       -- Current Date [SYDATUM]
    M_MRP,                   -- Checkbox [XFELD]
    KUNNR,                   -- Customer [KUNNR]
    FLG_BUNDLE,              -- Bundle [FLG_BUNDLE]
    FSH_MPLND_ORD,           -- Master Plnd Ord. [FSH_MPLO_ORD]
    FSH_SEASON_YEAR,         -- Season Year [FSH_SAISJ]
    FSH_SEASON,              -- Season [FSH_SAISO]
    FSH_COLLECTION,          -- Collection [FSH_COLLECTION]
    FSH_THEME,               -- Theme [FSH_THEME]
    ATRKZ,                   -- Request ID [ATRKZ]
    DPS_HANDOVER_TIME,       -- DPS Handover Time [SYPP_DPS_HANDOVER_TIME]
    PRIMARY KEY (MANDT, PLNUM)
);

Learn More