Model / PM / AFVV

PM — Plant Maintenance

AFVV

48 fields · 3 key · 12 foreign keys · sourced from leanx.eu

DB structure of the quantities/dates/values in the operation — one row per order operation (AUFPL/APLZL) carrying standard-value quantities, scheduled and actual execution/setup/teardown dates and times, work, and confirmation quantities that drive PM order operation costing and scheduling. SAP's real table carries 190+ fields (six parallel standard-value slots, forecast/business-process variants, and PS-specific date sets); this definition is scoped to the key, the unit-of-measure/base-quantity fields, the six standard-value pairs, confirmed/scrap/work quantities, and the earliest/latest/actual scheduling date-time fields a PM execution or crosswalk model consumes — never silently truncate beyond that scope.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
ITN_NUM_MND keyitinerarium numerus mandatumRouting number of operations in the orderCO_AUFPLNUMC 10
NMR_MND keynumerator mandatumGeneral counter for orderCO_APLZLNUMC 8AFVC
MEN_ACT_OPEmensura actio operatioUnit of Measure for Activity/OperationVORMEUNIT 3T006
UMRENDenominator for converting rtg and op units of measureCP_UMRENDEC 5
IXPindex pensorumNumerator for converting task list and oper. un. of measureCP_UMREZDEC 5
QNTquantitasBase QuantityBMSCHQUAN 13,3
MEN_NRM_VALmensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VALnorma valorStandard ValueVGWRTQUAN 9,3
MEN_NRM_VAL2mensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VAL2norma valorStandard ValueVGWRTQUAN 9,3
MEN_NRM_VAL3mensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VAL3norma valorStandard ValueVGWRTQUAN 9,3
MEN_NRM_VAL4mensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VAL4norma valorStandard ValueVGWRTQUAN 9,3
MEN_NRM_VAL5mensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VAL5norma valorStandard ValueVGWRTQUAN 9,3
MEN_NRM_VAL6mensura norma valorUnit of measure for the standard valueVGWRTEHUNIT 3T006
NRM_VAL6norma valorStandard ValueVGWRTQUAN 9,3
MRA_ACTmora actioNormal duration of the activityDAUNORQUAN 5,1
MRA_UNImora unitasNormal duration/unitDAUNOREUNIT 3T006
OPS_ACTopus actioWork involved in the activityARBEITQUAN 7,1
UNI_OPSunitas opusUnit for workARBEITEUNIT 3T006
OPE_QNToperatio quantitasOperation QuantityMGVRGQUAN 13,3
OPEoperatioOperation scrapASVRGQUAN 13,3
TOTsumma totalisTotal Yield ConfirmedLMNGAQUAN 13,3
TOT_QNTsumma totalis quantitasTotal scrap quantity confirmedXMNGAQUAN 13,3
MND_MENmandatum mensuraConfirmed yield in order unit of measureGMNGAQUAN 13,3
ACL_OPSactualis opusActual workCO_ISMNWQUAN 13,3
TOT_QNT2summa totalis quantitasTotal confirmed rework quantityRMNGAQUAN 13,3
INI_DIEinitium diesEarliest scheduled start: Execution (date)FSAVDDATS 8
FIN_DIEfinis diesEarliest scheduled finish: Execution (date)FSEDDDATS 8
INI_DIE2initium diesLatest scheduled start: Execution (date)SSAVDDATS 8
FIN_DIE2finis diesLatest scheduled finish: Execution (date)SSEDDDATS 8
ACL_OPE_INIactualis operatio initiumActual operation start (date)ISAVDDATS 8
ACL_FIN_OPEactualis finis operatioActual finish of operation (date)IEAVDDATS 8
ACL_INI_DIEactualis initium diesActual start: Execution (date)ISDDDATS 8
ACL_INI_TMPactualis initium tempusActual start: Execution/setup (time)ISDZTIMS 6
ACL_FIN_DIEactualis finis diesActual finish: Execution (date)IEDDDATS 8
ACL_FIN_TMPactualis finis tempusActual finish: Execution (time)IEDZTIMS 6
PVS_FIN_DIEpraevisio finis diesForecast finish date of operation from confirmationCO_PEDDDATS 8
PVS_FIN_TMPpraevisio finis tempusForecast finish time of operation from confirmationCO_PEDZTIMS 6
ORD_TMPordo expectantium tempusQueue time used for schedulingWARTEZEITFLTP 16,16
TMPtempusSetup timeRUESTFLTP 16,16
TMP2tempusProcessing timeBEARZEITFLTP 16,16
ABRUETeardownABRUEFLTP 16,16
TMP3tempusWait time used for schedulingLIEGEZEITFLTP 16,16
TMP4tempusMove time used for schedulingTRANSZEITFLTP 16,16

Foreign keys

FieldCheck tableCheck field
APLZLAFVCAUFPL
APLZLAFVCAPLZL
ARBEHT006MSEHI
DAUNET006MSEHI
MANDTT000MANDT
MEINHT006MSEHI
VGE01T006MSEHI
VGE02T006MSEHI
VGE03T006MSEHI
VGE04T006MSEHI
VGE05T006MSEHI
VGE06T006MSEHI

View AFVV.yaml in the repository