AFVV

Transparent Table Application Table
182 Fields 8 CDS Views

DB structure of the quantities/dates/values in the operation

AFVV is an SAP database table in S/4HANA. DB structure of the quantities/dates/values in the operation. It contains 182 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_MaintOrderOperPlanningValues view from BASIC Planning Values of Maint Order Operation
I_NetworkActivity view left_outer BASIC Network Activity Details
I_NetworkActivityDatesQuantity view from BASIC Network Activity Dates/Quantities
I_OrderOperationDatesQty view from BASIC Order Operation Dates
P_AFVG view inner BASIC
P_ProcOrdMgmtOpBasic view inner BASIC
P_ProcOrdMgmtOpDetails view inner BASIC
P_ProdOrdMgmtOpBasic view_entity inner BASIC

Fields (182)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY aplzl CO_APLZL Counter
meinh VORME Act/op UoM
umren CP_UMREN Denominator
umrez CP_UMREZ Numerator
bmsch BMSCH Base Quantity
zmerh DZMERH Break Time
zeier DZEIER Break Time Unit
vge01 VGWRTEH Std value unit
vgw01 VGWRT Standard Value
vge02 VGWRTEH Std value unit
vgw02 VGWRT Standard Value
vge03 VGWRTEH Std value unit
vgw03 VGWRT Standard Value
vge04 VGWRTEH Std value unit
vgw04 VGWRT Standard Value
vge05 VGWRTEH Std value unit
vgw05 VGWRT Standard Value
vge06 VGWRTEH Std value unit
vgw06 VGWRT Standard Value
zeimu DZEIMU Min.Overlap Tme
zminu DZMINU Minimum Overlap
minwe MINWEI Min. Send-Ahead
zeimb DZEIMB Min. Proc. Time
zminb DZMINB Min. Proc. Time
zeilm DZEILM Max. Wait Unit
zlmax DZLMAX Max. Wait Time
zeilp DZEILP Req. Wait Unit
zlpro DZLPRO Min. Wait Time
zeiwn DZEIWN Std Queue Unit
zwnor DZWNOR Std Queue Time
zeiwm DZEIWM Min. Queue Unit
zwmin DZWMIN Min. Queue Time
zeitn DZEITN StdMoveTime Un
ztnor DZTNOR Std Move Time
zeitm DZEITM MinMoveTime Un
ztmin DZTMIN Min. Move Time
plifz PLIFZ Pl. Deliv. Time
dauno DAUNOR Normal duration
daune DAUNORE Norm.duratn un.
daumi DAUMIN Min. duration
daume DAUMINE Min. dur. unit
einsa EINSCHRA StartConstraint
einse EINSCHRE Fin. constraint
arbei ARBEIT Work
arbeh ARBEITE Unit for work
mgvrg MGVRG Operation Qty
asvrg ASVRG Planned Scrap
lmnga LMNGA Confirmed Yield
xmnga XMNGA Confirmed Scrap
gmnga GMNGA Yield in Order Unit
ism01 CO_RUMNG Conf. Activity
ism02 CO_RUMNG Conf. Activity
ism03 CO_RUMNG Conf. Activity
ism04 CO_RUMNG Conf. Activity
ism05 CO_RUMNG Conf. Activity
ism06 CO_RUMNG Conf. Activity
ismnw CO_ISMNW Actual work
fsavd FSAVD Earl.start date
fsavz FSAVZ Earl.start time
fssbd FSSBD Earl.start date
fssbz FSSBZ Earl.start time
fssad FSSAD Earl.start date
fssaz FSSAZ Earl.start time
fsedd FSEDD EarliestEndDate
fsedz FSEDZ Earliest finish
fssld FSSLD Erl. Wait Start Date
fsslz FSSLZ Erl. Wait Start Time
fseld FSELD Erlst Wait End Date
fselz FSELZ Erlst Wait End Time
ssavd SSAVD Latest start
ssavz SSAVZ Lat. start time
sssbd SSSBD Lat.start date
sssbz SSSBZ Lat. start time
sssad SSSAD Lat.start date
sssaz SSSAZ Lat. start time
ssedd SSEDD Lat.finish date
ssedz SSEDZ Latest fin.time
sssld SSSLD Ltst Wait Start Date
ssslz SSSLZ Ltst Wait Start Time
sseld SSELD Latest Wait End Date
sselz SSELZ Latest Wait End Time
isavd ISAVD Operation Start Date
ieavd IEAVD Operation End Date
isdd ISDD Execution Start Date
isdz ISDZ Execution Start Time
ierd IERD Setup End Date
ierz IERZ Setup End Time
isbd ISBD Procg Start Date
isbz ISBZ Procg Start Time
iebd IEBD Processing End Date
iebz IEBZ Processing End Time
isad ISAD Teardown Start Date
isaz ISAZ Teardown Start Time
iedd IEDD Execution End Date
iedz IEDZ Execution End Time
pedd CO_PEDD Forecast finish
pedz CO_PEDZ Forecast End
puffr PUFFR_FREI Free float
pufgs PUFFR_GESM Total float
ntanf VORGABESTD Start constr.
ntanz VORGABESTZ StartTimeConstr
ntend VORGABEEND2 Finish Constr.
ntenz VORGABEENZ Fin.time constr
ewstd EWSTARTD Fcst start date
ewstz EWSTARTZ Fcst start time
ewend EWENDED Fcst fin. date
ewenz EWENDEZ Fcst fin. time
ewdan EWDAN Normal dur. (F)
ewdne EWDNE Unit/NrmDur(F)
ewdam EWDAM Forecast min.
ewdme EWDME Min. dur. unit
ewste PS_RESTE Fin. constraint
ewsta PS_RESTA StartConstraint
wartz WARTEZEIT Queue Time
wrtze WTRZE Queue Time Unit
ruest RUEST Setup Time
rstze RSTZE Setup Unit
bearz BEARZEIT Processing Time
beaze BEAZE Proc. time unit
abrue ABRUE Teardown
aruze ARUZE Teardown Unit
liegz LIEGEZEIT Wait Time
ligze LIGZE Wait Time Unit
tranz TRANSZEIT Move Time
traze TRAZE Move Time Unit
iserh ISERH Conf Break Time
ofm01 CO_SCHAETZ Forecast Value
ofm02 CO_SCHAETZ Forecast Value
ofm03 CO_SCHAETZ Forecast Value
ofm04 CO_SCHAETZ Forecast Value
ofm05 CO_SCHAETZ Forecast Value
ofm06 CO_SCHAETZ Forecast Value
ofmnw OFMNW Forecast work
bzoffb CP_OBZOFFB Reference Date
ehoffb CP_OEHOFFB Unit
offstb CP_OOFFSTB Offset
offste CP_OOFFSTE Offset
bzoffe CP_OBZOFFE Reference
ehoffe CP_OEHOFFE Unit
fpavd FPAVD Earliest start date
fpavz FPAVZ Earliest start time
fpedd FPEDD Earliest finish
fpedz FPEDZ Earliest Finish
spavd SPAVD LateSchdStartDt
spavz SPAVZ Latest start
spedd SPEDD Latest end
spedz SPEDZ Latest finish
beazp BEAZEP Proc. time unit
pufgp PPUFF_GESM Total float
puffp PPUFF_FREI Free float
bearp PBEARZEIT Processing time
epanf EPANF Disptched start
epanz EPANZ DispatchedStart
epend EPEND DsptchFinish
epenz EPENZ DsptchdFinish
pdau PDAU Forecast duratn
pdae PDAE Un/Fcst duratn.
knote KNOTE Points
vstzw VSTZW Deadl.function
vstga VSTGA Reason f.Deviat
qrastzeht QRASTZEHT Time unit
qrastzfak QRASTZFAK Time factor
qrastmeng QRASTMENG QtyIntervalInsp
qrastereh QRASTEREH Grid msmt unit
aufkt AFAKT Execution Fact.
rmnga RMNGA Confirmed Rework
ile01 CO_ISMNGEH Unit/activity
ile02 CO_ISMNGEH Unit/activity
ile03 CO_ISMNGEH Unit/activity
ile04 CO_ISMNGEH Unit/activity
ile05 CO_ISMNGEH Unit/activity
ile06 CO_ISMNGEH Unit/activity
rwfak RWFAK Not Used
iprz1 CO_IPRZS Process Quantity
ipre1 RU_IPRZE Process Unit
iprk1 RU_IPRZK No Remain. Act.
takt LD_TAKT Takt
oprz1 OPRZ1 Remaining Proc.
opre1 OPRE1 RemainProc.Unit
pspm_indicator PSPM_INDICATOR Indicates PMCS date influence activity scheduling

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.

-- DB structure of the quantities/dates/values in the operation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFVV (
    MANDT,           -- Client [MANDT]
    AUFPL,           -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,           -- Counter [CO_APLZL]
    MEINH,           -- Act/op UoM [VORME]
    UMREN,           -- Denominator [CP_UMREN]
    UMREZ,           -- Numerator [CP_UMREZ]
    BMSCH,           -- Base Quantity [BMSCH]
    ZMERH,           -- Break Time [DZMERH]
    ZEIER,           -- Break Time Unit [DZEIER]
    VGE01,           -- Std value unit [VGWRTEH]
    VGW01,           -- Standard Value [VGWRT]
    VGE02,           -- Std value unit [VGWRTEH]
    VGW02,           -- Standard Value [VGWRT]
    VGE03,           -- Std value unit [VGWRTEH]
    VGW03,           -- Standard Value [VGWRT]
    VGE04,           -- Std value unit [VGWRTEH]
    VGW04,           -- Standard Value [VGWRT]
    VGE05,           -- Std value unit [VGWRTEH]
    VGW05,           -- Standard Value [VGWRT]
    VGE06,           -- Std value unit [VGWRTEH]
    VGW06,           -- Standard Value [VGWRT]
    ZEIMU,           -- Min.Overlap Tme [DZEIMU]
    ZMINU,           -- Minimum Overlap [DZMINU]
    MINWE,           -- Min. Send-Ahead [MINWEI]
    ZEIMB,           -- Min. Proc. Time [DZEIMB]
    ZMINB,           -- Min. Proc. Time [DZMINB]
    ZEILM,           -- Max. Wait Unit [DZEILM]
    ZLMAX,           -- Max. Wait Time [DZLMAX]
    ZEILP,           -- Req. Wait Unit [DZEILP]
    ZLPRO,           -- Min. Wait Time [DZLPRO]
    ZEIWN,           -- Std Queue Unit [DZEIWN]
    ZWNOR,           -- Std Queue Time [DZWNOR]
    ZEIWM,           -- Min. Queue Unit [DZEIWM]
    ZWMIN,           -- Min. Queue Time [DZWMIN]
    ZEITN,           -- StdMoveTime Un [DZEITN]
    ZTNOR,           -- Std Move Time [DZTNOR]
    ZEITM,           -- MinMoveTime Un [DZEITM]
    ZTMIN,           -- Min. Move Time [DZTMIN]
    PLIFZ,           -- Pl. Deliv. Time [PLIFZ]
    DAUNO,           -- Normal duration [DAUNOR]
    DAUNE,           -- Norm.duratn un. [DAUNORE]
    DAUMI,           -- Min. duration [DAUMIN]
    DAUME,           -- Min. dur. unit [DAUMINE]
    EINSA,           -- StartConstraint [EINSCHRA]
    EINSE,           -- Fin. constraint [EINSCHRE]
    ARBEI,           -- Work [ARBEIT]
    ARBEH,           -- Unit for work [ARBEITE]
    MGVRG,           -- Operation Qty [MGVRG]
    ASVRG,           -- Planned Scrap [ASVRG]
    LMNGA,           -- Confirmed Yield [LMNGA]
    XMNGA,           -- Confirmed Scrap [XMNGA]
    GMNGA,           -- Yield in Order Unit [GMNGA]
    ISM01,           -- Conf. Activity [CO_RUMNG]
    ISM02,           -- Conf. Activity [CO_RUMNG]
    ISM03,           -- Conf. Activity [CO_RUMNG]
    ISM04,           -- Conf. Activity [CO_RUMNG]
    ISM05,           -- Conf. Activity [CO_RUMNG]
    ISM06,           -- Conf. Activity [CO_RUMNG]
    ISMNW,           -- Actual work [CO_ISMNW]
    FSAVD,           -- Earl.start date [FSAVD]
    FSAVZ,           -- Earl.start time [FSAVZ]
    FSSBD,           -- Earl.start date [FSSBD]
    FSSBZ,           -- Earl.start time [FSSBZ]
    FSSAD,           -- Earl.start date [FSSAD]
    FSSAZ,           -- Earl.start time [FSSAZ]
    FSEDD,           -- EarliestEndDate [FSEDD]
    FSEDZ,           -- Earliest finish [FSEDZ]
    FSSLD,           -- Erl. Wait Start Date [FSSLD]
    FSSLZ,           -- Erl. Wait Start Time [FSSLZ]
    FSELD,           -- Erlst Wait End Date [FSELD]
    FSELZ,           -- Erlst Wait End Time [FSELZ]
    SSAVD,           -- Latest start [SSAVD]
    SSAVZ,           -- Lat. start time [SSAVZ]
    SSSBD,           -- Lat.start date [SSSBD]
    SSSBZ,           -- Lat. start time [SSSBZ]
    SSSAD,           -- Lat.start date [SSSAD]
    SSSAZ,           -- Lat. start time [SSSAZ]
    SSEDD,           -- Lat.finish date [SSEDD]
    SSEDZ,           -- Latest fin.time [SSEDZ]
    SSSLD,           -- Ltst Wait Start Date [SSSLD]
    SSSLZ,           -- Ltst Wait Start Time [SSSLZ]
    SSELD,           -- Latest Wait End Date [SSELD]
    SSELZ,           -- Latest Wait End Time [SSELZ]
    ISAVD,           -- Operation Start Date [ISAVD]
    IEAVD,           -- Operation End Date [IEAVD]
    ISDD,            -- Execution Start Date [ISDD]
    ISDZ,            -- Execution Start Time [ISDZ]
    IERD,            -- Setup End Date [IERD]
    IERZ,            -- Setup End Time [IERZ]
    ISBD,            -- Procg Start Date [ISBD]
    ISBZ,            -- Procg Start Time [ISBZ]
    IEBD,            -- Processing End Date [IEBD]
    IEBZ,            -- Processing End Time [IEBZ]
    ISAD,            -- Teardown Start Date [ISAD]
    ISAZ,            -- Teardown Start Time [ISAZ]
    IEDD,            -- Execution End Date [IEDD]
    IEDZ,            -- Execution End Time [IEDZ]
    PEDD,            -- Forecast finish [CO_PEDD]
    PEDZ,            -- Forecast End [CO_PEDZ]
    PUFFR,           -- Free float [PUFFR_FREI]
    PUFGS,           -- Total float [PUFFR_GESM]
    NTANF,           -- Start constr. [VORGABESTD]
    NTANZ,           -- StartTimeConstr [VORGABESTZ]
    NTEND,           -- Finish Constr. [VORGABEEND2]
    NTENZ,           -- Fin.time constr [VORGABEENZ]
    EWSTD,           -- Fcst start date [EWSTARTD]
    EWSTZ,           -- Fcst start time [EWSTARTZ]
    EWEND,           -- Fcst fin. date [EWENDED]
    EWENZ,           -- Fcst fin. time [EWENDEZ]
    EWDAN,           -- Normal dur. (F) [EWDAN]
    EWDNE,           -- Unit/NrmDur(F) [EWDNE]
    EWDAM,           -- Forecast min. [EWDAM]
    EWDME,           -- Min. dur. unit [EWDME]
    EWSTE,           -- Fin. constraint [PS_RESTE]
    EWSTA,           -- StartConstraint [PS_RESTA]
    WARTZ,           -- Queue Time [WARTEZEIT]
    WRTZE,           -- Queue Time Unit [WTRZE]
    RUEST,           -- Setup Time [RUEST]
    RSTZE,           -- Setup Unit [RSTZE]
    BEARZ,           -- Processing Time [BEARZEIT]
    BEAZE,           -- Proc. time unit [BEAZE]
    ABRUE,           -- Teardown [ABRUE]
    ARUZE,           -- Teardown Unit [ARUZE]
    LIEGZ,           -- Wait Time [LIEGEZEIT]
    LIGZE,           -- Wait Time Unit [LIGZE]
    TRANZ,           -- Move Time [TRANSZEIT]
    TRAZE,           -- Move Time Unit [TRAZE]
    ISERH,           -- Conf Break Time [ISERH]
    OFM01,           -- Forecast Value [CO_SCHAETZ]
    OFM02,           -- Forecast Value [CO_SCHAETZ]
    OFM03,           -- Forecast Value [CO_SCHAETZ]
    OFM04,           -- Forecast Value [CO_SCHAETZ]
    OFM05,           -- Forecast Value [CO_SCHAETZ]
    OFM06,           -- Forecast Value [CO_SCHAETZ]
    OFMNW,           -- Forecast work [OFMNW]
    BZOFFB,          -- Reference Date [CP_OBZOFFB]
    EHOFFB,          -- Unit [CP_OEHOFFB]
    OFFSTB,          -- Offset [CP_OOFFSTB]
    OFFSTE,          -- Offset [CP_OOFFSTE]
    BZOFFE,          -- Reference [CP_OBZOFFE]
    EHOFFE,          -- Unit [CP_OEHOFFE]
    FPAVD,           -- Earliest start date [FPAVD]
    FPAVZ,           -- Earliest start time [FPAVZ]
    FPEDD,           -- Earliest finish [FPEDD]
    FPEDZ,           -- Earliest Finish [FPEDZ]
    SPAVD,           -- LateSchdStartDt [SPAVD]
    SPAVZ,           -- Latest start [SPAVZ]
    SPEDD,           -- Latest end [SPEDD]
    SPEDZ,           -- Latest finish [SPEDZ]
    BEAZP,           -- Proc. time unit [BEAZEP]
    PUFGP,           -- Total float [PPUFF_GESM]
    PUFFP,           -- Free float [PPUFF_FREI]
    BEARP,           -- Processing time [PBEARZEIT]
    EPANF,           -- Disptched start [EPANF]
    EPANZ,           -- DispatchedStart [EPANZ]
    EPEND,           -- DsptchFinish [EPEND]
    EPENZ,           -- DsptchdFinish [EPENZ]
    PDAU,            -- Forecast duratn [PDAU]
    PDAE,            -- Un/Fcst duratn. [PDAE]
    KNOTE,           -- Points [KNOTE]
    VSTZW,           -- Deadl.function [VSTZW]
    VSTGA,           -- Reason f.Deviat [VSTGA]
    QRASTZEHT,       -- Time unit [QRASTZEHT]
    QRASTZFAK,       -- Time factor [QRASTZFAK]
    QRASTMENG,       -- QtyIntervalInsp [QRASTMENG]
    QRASTEREH,       -- Grid msmt unit [QRASTEREH]
    AUFKT,           -- Execution Fact. [AFAKT]
    RMNGA,           -- Confirmed Rework [RMNGA]
    ILE01,           -- Unit/activity [CO_ISMNGEH]
    ILE02,           -- Unit/activity [CO_ISMNGEH]
    ILE03,           -- Unit/activity [CO_ISMNGEH]
    ILE04,           -- Unit/activity [CO_ISMNGEH]
    ILE05,           -- Unit/activity [CO_ISMNGEH]
    ILE06,           -- Unit/activity [CO_ISMNGEH]
    RWFAK,           -- Not Used [RWFAK]
    IPRZ1,           -- Process Quantity [CO_IPRZS]
    IPRE1,           -- Process Unit [RU_IPRZE]
    IPRK1,           -- No Remain. Act. [RU_IPRZK]
    TAKT,            -- Takt [LD_TAKT]
    OPRZ1,           -- Remaining Proc. [OPRZ1]
    OPRE1,           -- RemainProc.Unit [OPRE1]
    PSPM_INDICATOR,  -- Indicates PMCS date influence activity scheduling [PSPM_INDICATOR]
    PRIMARY KEY (MANDT, AUFPL, APLZL)
);

Learn More