AFRP0

Transparent Table Application Table
100 Fields 1 CDS Views

Table of planned changes for confirmation (PDC)

AFRP0 is an SAP database table in S/4HANA. Table of planned changes for confirmation (PDC). It contains 100 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OrderConfirmationRequest view_entity from BASIC Order Confirmation Request

Fields (100)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pdsnr PDSNR_D Number
KEY counter CIM_COUNT Counter
ernam AUFERFNAM Entered By
ertstamps TZNTSTMPS Time Stamp
ru_pcount RU_PCOUNT Number
ru_orina RU_ORINA Appl. Origin
ru_orini RU_ORINI InterfaceOrigin
ru_vswbn VSWBN GoodsMvtsDetermined
weblnr WEBLNR Doc.gds mvt err
rueck CO_RUECK Confirmation
aufnr AUFNR Order
aplfl PLNFOLGE Sequence
vornr VORNR Activity
uvorn UVORN Suboperation
kapar KAPART Capacity cat.
split CY_SPLIT Split number
aueru AUERU_VS Final Confirmtn
ausor AUSBU Clear Open Res.
budat BUCHDATUM Posting Date
grund CO_AGRND Reason
ltxa1 CO_RTEXT Confirm. text
exnam RU_EXNAM Created by
exerd RU_EXERD Created on
exerz RU_EXERZ Time
meinh RU_VORME Confirmation Unit
lmnga RU_LMNGA Yield Quantity
xmnga RU_XMNGA Scrap Quantity
rmnga RU_RMNGA Rework Quantity
isdd RU_ISDD Start Execution
isdz RU_ISDZ Act. Start Time
ierd RU_IERD Finish Setup
ierz RU_IERZ Finish Setup
isbd RU_ISBD Start of Proc.
isbz RU_ISBZ Start of Proc.
iebd RU_IEBD Fin. Processing
iebz RU_IEBZ Fin. Processing
isad RU_ISAD Start Teardown
isaz RU_ISAZ Start Teardown
iedd RU_IEDD Finish Execut.
iedz RU_IEDZ Actual finish
pedd CO_PEDD Forecast finish
pedz CO_PEDZ Forecast End
werks WERKS_D Plant
arbpl ARBPL Work Center
satza CO_SATZA Record Type
ile01 CO_ISMNGEH Unit/activity
ism01 RU_ISMNG Acty to Confirm
lek01 CO_LEIKZ No Remain. Act.
ile02 CO_ISMNGEH Unit/activity
ism02 RU_ISMNG Acty to Confirm
lek02 CO_LEIKZ No Remain. Act.
ile03 CO_ISMNGEH Unit/activity
ism03 RU_ISMNG Acty to Confirm
lek03 CO_LEIKZ No Remain. Act.
ile04 CO_ISMNGEH Unit/activity
ism04 RU_ISMNG Acty to Confirm
lek04 CO_LEIKZ No Remain. Act.
ile05 CO_ISMNGEH Unit/activity
ism05 RU_ISMNG Acty to Confirm
lek05 CO_LEIKZ No Remain. Act.
ile06 CO_ISMNGEH Unit/activity
ism06 RU_ISMNG Acty to Confirm
lek06 CO_LEIKZ No Remain. Act.
iprz1 RU_IPRZS Process Qty
ipre1 RU_IPRZE Process Unit
iprk1 RU_IPRZK No Remain. Act.
abarb CO_ABARB Processing %
ofe01 VGWRTEH Std value unit
ofm01 CO_SCHAETZ Forecast Value
ofe02 VGWRTEH Std value unit
ofm02 CO_SCHAETZ Forecast Value
ofe03 VGWRTEH Std value unit
ofm03 CO_SCHAETZ Forecast Value
ofe04 VGWRTEH Std value unit
ofm04 CO_SCHAETZ Forecast Value
ofe05 VGWRTEH Std value unit
ofm05 CO_SCHAETZ Forecast Value
ofe06 VGWRTEH Std value unit
ofm06 CO_SCHAETZ Forecast Value
oprz1 OPRZ1 Remaining Proc.
opre1 OPRE1 RemainProc.Unit
pernr CO_PERNR Personnel no.
zausw DZAUSW Time rec.ID no.
loart LOHNART Wage type
qualf QUALF Suitability
anzma ANZMS No. employees
logrp LOHNGRP Wage Group
zeier DZEIER Break Time Unit
iserh ISERH Conf Break Time
slk01 RU_TARGET_ACTIVITY Target activity
slk02 RU_TARGET_ACTIVITY Target activity
slk03 RU_TARGET_ACTIVITY Target activity
slk04 RU_TARGET_ACTIVITY Target activity
slk05 RU_TARGET_ACTIVITY Target activity
slk06 RU_TARGET_ACTIVITY Target activity
sprk1 RU_TARGET_BUS_PROC TrgtQtyBusTrans
extid RU_EXTID External Key
ldate LDATE Date
ltime LTIME 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.

-- Table of planned changes for confirmation (PDC)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFRP0 (
    MANDT,      -- Client [MANDT]
    PDSNR,      -- Number [PDSNR_D]
    COUNTER,    -- Counter [CIM_COUNT]
    ERNAM,      -- Entered By [AUFERFNAM]
    ERTSTAMPS,  -- Time Stamp [TZNTSTMPS]
    RU_PCOUNT,  -- Number [RU_PCOUNT]
    RU_ORINA,   -- Appl. Origin [RU_ORINA]
    RU_ORINI,   -- InterfaceOrigin [RU_ORINI]
    RU_VSWBN,   -- GoodsMvtsDetermined [VSWBN]
    WEBLNR,     -- Doc.gds mvt err [WEBLNR]
    RUECK,      -- Confirmation [CO_RUECK]
    AUFNR,      -- Order [AUFNR]
    APLFL,      -- Sequence [PLNFOLGE]
    VORNR,      -- Activity [VORNR]
    UVORN,      -- Suboperation [UVORN]
    KAPAR,      -- Capacity cat. [KAPART]
    SPLIT,      -- Split number [CY_SPLIT]
    AUERU,      -- Final Confirmtn [AUERU_VS]
    AUSOR,      -- Clear Open Res. [AUSBU]
    BUDAT,      -- Posting Date [BUCHDATUM]
    GRUND,      -- Reason [CO_AGRND]
    LTXA1,      -- Confirm. text [CO_RTEXT]
    EXNAM,      -- Created by [RU_EXNAM]
    EXERD,      -- Created on [RU_EXERD]
    EXERZ,      -- Time [RU_EXERZ]
    MEINH,      -- Confirmation Unit [RU_VORME]
    LMNGA,      -- Yield Quantity [RU_LMNGA]
    XMNGA,      -- Scrap Quantity [RU_XMNGA]
    RMNGA,      -- Rework Quantity [RU_RMNGA]
    ISDD,       -- Start Execution [RU_ISDD]
    ISDZ,       -- Act. Start Time [RU_ISDZ]
    IERD,       -- Finish Setup [RU_IERD]
    IERZ,       -- Finish Setup [RU_IERZ]
    ISBD,       -- Start of Proc. [RU_ISBD]
    ISBZ,       -- Start of Proc. [RU_ISBZ]
    IEBD,       -- Fin. Processing [RU_IEBD]
    IEBZ,       -- Fin. Processing [RU_IEBZ]
    ISAD,       -- Start Teardown [RU_ISAD]
    ISAZ,       -- Start Teardown [RU_ISAZ]
    IEDD,       -- Finish Execut. [RU_IEDD]
    IEDZ,       -- Actual finish [RU_IEDZ]
    PEDD,       -- Forecast finish [CO_PEDD]
    PEDZ,       -- Forecast End [CO_PEDZ]
    WERKS,      -- Plant [WERKS_D]
    ARBPL,      -- Work Center [ARBPL]
    SATZA,      -- Record Type [CO_SATZA]
    ILE01,      -- Unit/activity [CO_ISMNGEH]
    ISM01,      -- Acty to Confirm [RU_ISMNG]
    LEK01,      -- No Remain. Act. [CO_LEIKZ]
    ILE02,      -- Unit/activity [CO_ISMNGEH]
    ISM02,      -- Acty to Confirm [RU_ISMNG]
    LEK02,      -- No Remain. Act. [CO_LEIKZ]
    ILE03,      -- Unit/activity [CO_ISMNGEH]
    ISM03,      -- Acty to Confirm [RU_ISMNG]
    LEK03,      -- No Remain. Act. [CO_LEIKZ]
    ILE04,      -- Unit/activity [CO_ISMNGEH]
    ISM04,      -- Acty to Confirm [RU_ISMNG]
    LEK04,      -- No Remain. Act. [CO_LEIKZ]
    ILE05,      -- Unit/activity [CO_ISMNGEH]
    ISM05,      -- Acty to Confirm [RU_ISMNG]
    LEK05,      -- No Remain. Act. [CO_LEIKZ]
    ILE06,      -- Unit/activity [CO_ISMNGEH]
    ISM06,      -- Acty to Confirm [RU_ISMNG]
    LEK06,      -- No Remain. Act. [CO_LEIKZ]
    IPRZ1,      -- Process Qty [RU_IPRZS]
    IPRE1,      -- Process Unit [RU_IPRZE]
    IPRK1,      -- No Remain. Act. [RU_IPRZK]
    ABARB,      -- Processing % [CO_ABARB]
    OFE01,      -- Std value unit [VGWRTEH]
    OFM01,      -- Forecast Value [CO_SCHAETZ]
    OFE02,      -- Std value unit [VGWRTEH]
    OFM02,      -- Forecast Value [CO_SCHAETZ]
    OFE03,      -- Std value unit [VGWRTEH]
    OFM03,      -- Forecast Value [CO_SCHAETZ]
    OFE04,      -- Std value unit [VGWRTEH]
    OFM04,      -- Forecast Value [CO_SCHAETZ]
    OFE05,      -- Std value unit [VGWRTEH]
    OFM05,      -- Forecast Value [CO_SCHAETZ]
    OFE06,      -- Std value unit [VGWRTEH]
    OFM06,      -- Forecast Value [CO_SCHAETZ]
    OPRZ1,      -- Remaining Proc. [OPRZ1]
    OPRE1,      -- RemainProc.Unit [OPRE1]
    PERNR,      -- Personnel no. [CO_PERNR]
    ZAUSW,      -- Time rec.ID no. [DZAUSW]
    LOART,      -- Wage type [LOHNART]
    QUALF,      -- Suitability [QUALF]
    ANZMA,      -- No. employees [ANZMS]
    LOGRP,      -- Wage Group [LOHNGRP]
    ZEIER,      -- Break Time Unit [DZEIER]
    ISERH,      -- Conf Break Time [ISERH]
    SLK01,      -- Target activity [RU_TARGET_ACTIVITY]
    SLK02,      -- Target activity [RU_TARGET_ACTIVITY]
    SLK03,      -- Target activity [RU_TARGET_ACTIVITY]
    SLK04,      -- Target activity [RU_TARGET_ACTIVITY]
    SLK05,      -- Target activity [RU_TARGET_ACTIVITY]
    SLK06,      -- Target activity [RU_TARGET_ACTIVITY]
    SPRK1,      -- TrgtQtyBusTrans [RU_TARGET_BUS_PROC]
    EXTID,      -- External Key [RU_EXTID]
    LDATE,      -- Date [LDATE]
    LTIME,      -- Time [LTIME]
    PRIMARY KEY (MANDT, PDSNR, COUNTER)
);

Learn More