AFRV

Transparent Table Application Table
189 Fields 1 CDS Views

Confirmation pool

AFRV is an SAP database table in S/4HANA. Confirmation pool. It contains 189 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FailedOrderConfirmation view from BASIC Failed Order Confirmation

Fields (189)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY afori ORIND Application
KEY afruv AFRUV Confirm. pool
KEY counter CIM_COUNT Counter
vtext LTXA1 Op. Short Text
beaknz BEAKNZ Confirmed
mpe_conf MPE_CONF Conf by MPE
pdsnr PDSNR_D Number
pernr PERNR_D Personnel No.
infty INFOTYP Infotype
subty SUBTY Subtype
objps CHAR_LG_02 CHAR2
sprps CHAR1 Single-Character Flag
endda ENDDA End Date
begda BEGDA Start Date
seqnr SEQNR IT record no.
bukrs BUKRS Company Code
gsber GSBER Business Area
kokrs KOKRS CO Area
kostl KOSTL Cost Center
aufnr AUFNR Order
kstrg KSTRG Cost Object
posnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
vornr VORNR Activity
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
paobjnr RKEOBJNR Profit. segment
prznr CO_PRZNR Business Process
fistl FM_FICTR Funds Center
fipos FIPOS Commitment item
geber BP_GEBER Fund
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
lstnr ASNUM Activity number
ltlst LSTAR Activity Type
sbukr BUKRS Company Code
sgsbr GSBER Business Area
skost KOSTL Cost Center
lstar LSTAR Activity Type
exbel CHAR18 Field length 18
mwskz MWSKZ Tax Code
otype OTYPE Object type
stell STELL Job
pohrs POHRS Hours
dart CHAR_LG_02 CHAR2
udart CHAR_LG_02 CHAR2
sgtxt SGTXT Text
txjcd TXJCD Tax Jur.
ldate BDE_DATE Entry Date
ltime BDE_TIME Time received
erdat PHDAT Created on
ertim PHTIM Created at
satza RETYP Time event type
terid TERID Terminal ID
abwgr CHAR4 Undefined range (can be used for patch levels)
exlga CHAR4 Undefined range (can be used for patch levels)
zeinh CHAR3 3-Byte field
hrazl DEC07 Dummy Dec07
hrbet CURR09 Amount
origf ORIGF Origin
dallf CHAR1 Single-Character Flag
pdc_otype OTYPE Object type
pdc_plans PLANS Position
pdc_usrup PDC_USRUP Cust.Field
refex CHAR1 Single-Character Flag
ordex CHAR1 Single-Character Flag
zausw DZAUSW Time rec.ID no.
orind ORIND Application
indeu INDEU I/D/U ind.
rueck CO_RUECK Confirmation
split CY_SPLIT Split number
rmzhl CO_RMZHL Counter
budat BUCHDATUM Posting Date
werks WERKS_D Plant
arbpl ARBPL Work Center
kapar KAPART Capacity cat.
ltxa1 CO_RTEXT Confirm. text
iserh ISERH Conf Break Time
zeier DZEIER Break Time Unit
ile01 CO_ISMNGEH Unit/activity
ism01 CO_ISMNG Acty to Confirm
ofm01 CO_SCHAETZ Forecast Value
ofe01 VGWRTEH Std value unit
lek01 CO_LEIKZ No Remain. Act.
ile02 CO_ISMNGEH Unit/activity
ism02 CO_ISMNG Acty to Confirm
ofm02 CO_SCHAETZ Forecast Value
ofe02 VGWRTEH Std value unit
lek02 CO_LEIKZ No Remain. Act.
ile03 CO_ISMNGEH Unit/activity
ism03 CO_ISMNG Acty to Confirm
ofm03 CO_SCHAETZ Forecast Value
ofe03 VGWRTEH Std value unit
lek03 CO_LEIKZ No Remain. Act.
ile04 CO_ISMNGEH Unit/activity
ism04 CO_ISMNG Acty to Confirm
ofm04 CO_SCHAETZ Forecast Value
ofe04 VGWRTEH Std value unit
lek04 CO_LEIKZ No Remain. Act.
ile05 CO_ISMNGEH Unit/activity
ism05 CO_ISMNG Acty to Confirm
ofm05 CO_SCHAETZ Forecast Value
ofe05 VGWRTEH Std value unit
lek05 CO_LEIKZ No Remain. Act.
ile06 CO_ISMNGEH Unit/activity
ism06 CO_ISMNG Acty to Confirm
ofm06 CO_SCHAETZ Forecast Value
ofe06 VGWRTEH Std value unit
lek06 CO_LEIKZ No Remain. Act.
ismnw ISMNW Actual work
ismne ARBEITE Unit for work
learr LEARR Activity Type
ofmnw REMNW Remaining work
ofmne OFMNE Unit Remng Work
leknw LEKNW No Remain. Work
abarb CO_ABARB Processing %
idaur IDAUR Actual Duration
idaue IDAURE Un/actual dur.
odaur ODAUR Remaining dur.
odaue ODAUE Unit/remaining
loart LOHNART Wage type
qualf QUALF Suitability
anzma ANZMS No. employees
logrp LOHNGRP Wage Group
lmnga RU_LMNGA Yield Quantity
xmnga RU_XMNGA Scrap Quantity
meinh RU_VORME Confirmation Unit
grund CO_AGRND Reason
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
aueru AUERU Final Conf.
ausor AUSOR Open Reservs.
aplfl PLNFOLGE Sequence
uvorn UVORN Suboperation
autyp AUFTYP Order category
pknum PKNUM Control Cycle
pkpos PKPOS Kanban Item
pkbst PKBST Kanban Status
abmng ABMNG Reduced Qty
rmnga RMNGA Confirmed Rework
pkkey PKKEY Kanban ID
pkimg PKIMG Actual Quantity
catsbelnr CATSBELNR Document no.
catsprice CATSPRICE Price
catstcurr TWAER Trans. Currency
catspeinh PEINH Price unit
bemot BEMOT AcctIndicator
prz01 CO_PRZNR Business Process
iprz1 RU_IPRZS Process Qty
ipre1 RU_IPRZE Process Unit
iprk1 RU_IPRZK No Remain. Act.
oprz1 OPRZ1 Remaining Proc.
opre1 OPRE1 RemainProc.Unit
exnam RU_EXNAM Created by
exerd RU_EXERD Created on
exerz RU_EXERZ Time
weblnr WEBLNR Doc.gds mvt err
pkluz PKLUZ Delivery time
pkldt PKLDT Delivery date
pkbmg PKBMG Requested Qty
charg CHARG_D Batch
skokrs KOKRS CO Area
skostl SKOSTL Send. CCtr
nodat NODAT No date update
ismnu ARBEITE Unit for work
ofmnu ARBEITE Unit for work
packno PACKNO Package number
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
catscurr TWAER Trans. Currency

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.

-- Confirmation pool
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFRV (
    CLIENT,     -- Client [MANDT]
    AFORI,      -- Application [ORIND]
    AFRUV,      -- Confirm. pool [AFRUV]
    COUNTER,    -- Counter [CIM_COUNT]
    VTEXT,      -- Op. Short Text [LTXA1]
    BEAKNZ,     -- Confirmed [BEAKNZ]
    MPE_CONF,   -- Conf by MPE [MPE_CONF]
    PDSNR,      -- Number [PDSNR_D]
    PERNR,      -- Personnel No. [PERNR_D]
    INFTY,      -- Infotype [INFOTYP]
    SUBTY,      -- Subtype [SUBTY]
    OBJPS,      -- CHAR2 [CHAR_LG_02]
    SPRPS,      -- Single-Character Flag [CHAR1]
    ENDDA,      -- End Date [ENDDA]
    BEGDA,      -- Start Date [BEGDA]
    SEQNR,      -- IT record no. [SEQNR]
    BUKRS,      -- Company Code [BUKRS]
    GSBER,      -- Business Area [GSBER]
    KOKRS,      -- CO Area [KOKRS]
    KOSTL,      -- Cost Center [KOSTL]
    AUFNR,      -- Order [AUFNR]
    KSTRG,      -- Cost Object [KSTRG]
    POSNR,      -- WBS Element [PS_PSP_PNR]
    NPLNR,      -- Network [NPLNR]
    VORNR,      -- Activity [VORNR]
    KDAUF,      -- Sales Order [KDAUF]
    KDPOS,      -- Sales Ord. Item [KDPOS]
    PAOBJNR,    -- Profit. segment [RKEOBJNR]
    PRZNR,      -- Business Process [CO_PRZNR]
    FISTL,      -- Funds Center [FM_FICTR]
    FIPOS,      -- Commitment item [FIPOS]
    GEBER,      -- Fund [BP_GEBER]
    EBELN,      -- Purchasing Doc. [EBELN]
    EBELP,      -- Item [EBELP]
    LSTNR,      -- Activity number [ASNUM]
    LTLST,      -- Activity Type [LSTAR]
    SBUKR,      -- Company Code [BUKRS]
    SGSBR,      -- Business Area [GSBER]
    SKOST,      -- Cost Center [KOSTL]
    LSTAR,      -- Activity Type [LSTAR]
    EXBEL,      -- Field length 18 [CHAR18]
    MWSKZ,      -- Tax Code [MWSKZ]
    OTYPE,      -- Object type [OTYPE]
    STELL,      -- Job [STELL]
    POHRS,      -- Hours [POHRS]
    DART,       -- CHAR2 [CHAR_LG_02]
    UDART,      -- CHAR2 [CHAR_LG_02]
    SGTXT,      -- Text [SGTXT]
    TXJCD,      -- Tax Jur. [TXJCD]
    LDATE,      -- Entry Date [BDE_DATE]
    LTIME,      -- Time received [BDE_TIME]
    ERDAT,      -- Created on [PHDAT]
    ERTIM,      -- Created at [PHTIM]
    SATZA,      -- Time event type [RETYP]
    TERID,      -- Terminal ID [TERID]
    ABWGR,      -- Undefined range (can be used for patch levels) [CHAR4]
    EXLGA,      -- Undefined range (can be used for patch levels) [CHAR4]
    ZEINH,      -- 3-Byte field [CHAR3]
    HRAZL,      -- Dummy Dec07 [DEC07]
    HRBET,      -- Amount [CURR09]
    ORIGF,      -- Origin [ORIGF]
    DALLF,      -- Single-Character Flag [CHAR1]
    PDC_OTYPE,  -- Object type [OTYPE]
    PDC_PLANS,  -- Position [PLANS]
    PDC_USRUP,  -- Cust.Field [PDC_USRUP]
    REFEX,      -- Single-Character Flag [CHAR1]
    ORDEX,      -- Single-Character Flag [CHAR1]
    ZAUSW,      -- Time rec.ID no. [DZAUSW]
    ORIND,      -- Application [ORIND]
    INDEU,      -- I/D/U ind. [INDEU]
    RUECK,      -- Confirmation [CO_RUECK]
    SPLIT,      -- Split number [CY_SPLIT]
    RMZHL,      -- Counter [CO_RMZHL]
    BUDAT,      -- Posting Date [BUCHDATUM]
    WERKS,      -- Plant [WERKS_D]
    ARBPL,      -- Work Center [ARBPL]
    KAPAR,      -- Capacity cat. [KAPART]
    LTXA1,      -- Confirm. text [CO_RTEXT]
    ISERH,      -- Conf Break Time [ISERH]
    ZEIER,      -- Break Time Unit [DZEIER]
    ILE01,      -- Unit/activity [CO_ISMNGEH]
    ISM01,      -- Acty to Confirm [CO_ISMNG]
    OFM01,      -- Forecast Value [CO_SCHAETZ]
    OFE01,      -- Std value unit [VGWRTEH]
    LEK01,      -- No Remain. Act. [CO_LEIKZ]
    ILE02,      -- Unit/activity [CO_ISMNGEH]
    ISM02,      -- Acty to Confirm [CO_ISMNG]
    OFM02,      -- Forecast Value [CO_SCHAETZ]
    OFE02,      -- Std value unit [VGWRTEH]
    LEK02,      -- No Remain. Act. [CO_LEIKZ]
    ILE03,      -- Unit/activity [CO_ISMNGEH]
    ISM03,      -- Acty to Confirm [CO_ISMNG]
    OFM03,      -- Forecast Value [CO_SCHAETZ]
    OFE03,      -- Std value unit [VGWRTEH]
    LEK03,      -- No Remain. Act. [CO_LEIKZ]
    ILE04,      -- Unit/activity [CO_ISMNGEH]
    ISM04,      -- Acty to Confirm [CO_ISMNG]
    OFM04,      -- Forecast Value [CO_SCHAETZ]
    OFE04,      -- Std value unit [VGWRTEH]
    LEK04,      -- No Remain. Act. [CO_LEIKZ]
    ILE05,      -- Unit/activity [CO_ISMNGEH]
    ISM05,      -- Acty to Confirm [CO_ISMNG]
    OFM05,      -- Forecast Value [CO_SCHAETZ]
    OFE05,      -- Std value unit [VGWRTEH]
    LEK05,      -- No Remain. Act. [CO_LEIKZ]
    ILE06,      -- Unit/activity [CO_ISMNGEH]
    ISM06,      -- Acty to Confirm [CO_ISMNG]
    OFM06,      -- Forecast Value [CO_SCHAETZ]
    OFE06,      -- Std value unit [VGWRTEH]
    LEK06,      -- No Remain. Act. [CO_LEIKZ]
    ISMNW,      -- Actual work [ISMNW]
    ISMNE,      -- Unit for work [ARBEITE]
    LEARR,      -- Activity Type [LEARR]
    OFMNW,      -- Remaining work [REMNW]
    OFMNE,      -- Unit Remng Work [OFMNE]
    LEKNW,      -- No Remain. Work [LEKNW]
    ABARB,      -- Processing % [CO_ABARB]
    IDAUR,      -- Actual Duration [IDAUR]
    IDAUE,      -- Un/actual dur. [IDAURE]
    ODAUR,      -- Remaining dur. [ODAUR]
    ODAUE,      -- Unit/remaining [ODAUE]
    LOART,      -- Wage type [LOHNART]
    QUALF,      -- Suitability [QUALF]
    ANZMA,      -- No. employees [ANZMS]
    LOGRP,      -- Wage Group [LOHNGRP]
    LMNGA,      -- Yield Quantity [RU_LMNGA]
    XMNGA,      -- Scrap Quantity [RU_XMNGA]
    MEINH,      -- Confirmation Unit [RU_VORME]
    GRUND,      -- Reason [CO_AGRND]
    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]
    AUERU,      -- Final Conf. [AUERU]
    AUSOR,      -- Open Reservs. [AUSOR]
    APLFL,      -- Sequence [PLNFOLGE]
    UVORN,      -- Suboperation [UVORN]
    AUTYP,      -- Order category [AUFTYP]
    PKNUM,      -- Control Cycle [PKNUM]
    PKPOS,      -- Kanban Item [PKPOS]
    PKBST,      -- Kanban Status [PKBST]
    ABMNG,      -- Reduced Qty [ABMNG]
    RMNGA,      -- Confirmed Rework [RMNGA]
    PKKEY,      -- Kanban ID [PKKEY]
    PKIMG,      -- Actual Quantity [PKIMG]
    CATSBELNR,  -- Document no. [CATSBELNR]
    CATSPRICE,  -- Price [CATSPRICE]
    CATSTCURR,  -- Trans. Currency [TWAER]
    CATSPEINH,  -- Price unit [PEINH]
    BEMOT,      -- AcctIndicator [BEMOT]
    PRZ01,      -- Business Process [CO_PRZNR]
    IPRZ1,      -- Process Qty [RU_IPRZS]
    IPRE1,      -- Process Unit [RU_IPRZE]
    IPRK1,      -- No Remain. Act. [RU_IPRZK]
    OPRZ1,      -- Remaining Proc. [OPRZ1]
    OPRE1,      -- RemainProc.Unit [OPRE1]
    EXNAM,      -- Created by [RU_EXNAM]
    EXERD,      -- Created on [RU_EXERD]
    EXERZ,      -- Time [RU_EXERZ]
    WEBLNR,     -- Doc.gds mvt err [WEBLNR]
    PKLUZ,      -- Delivery time [PKLUZ]
    PKLDT,      -- Delivery date [PKLDT]
    PKBMG,      -- Requested Qty [PKBMG]
    CHARG,      -- Batch [CHARG_D]
    SKOKRS,     -- CO Area [KOKRS]
    SKOSTL,     -- Send. CCtr [SKOSTL]
    NODAT,      -- No date update [NODAT]
    ISMNU,      -- Unit for work [ARBEITE]
    OFMNU,      -- Unit for work [ARBEITE]
    PACKNO,     -- Package number [PACKNO]
    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]
    CATSCURR,   -- Trans. Currency [TWAER]
    PRIMARY KEY (CLIENT, AFORI, AFRUV, COUNTER)
);

Learn More