AFIH

Transparent Table Application Table
66 Fields 14 CDS Views

Maintenance order header

AFIH is an SAP database table in S/4HANA. Maintenance order header. It contains 66 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
CRMS4_IU_C_UMOCON view_entity inner Utilities Service Order by Con. Object
CRMS4_IU_I_UMO view_entity inner Utilities Maintenance Order
E_MaintenanceOrder view_entity from EXTENSION Maintenance Order Extension
FINOC_RULE_ORD_BASE view left_outer Orgl Change-Rule: Order Base
I_FldLogsMaintOrders view from BASIC Get all work orders
I_MaintenanceOrder view from BASIC Maintenance Order
I_MaintenanceOrderLongText view inner BASIC Maintenance Order Long Text
I_MaintOrderOpProdnRsceTool view from BASIC Maintenance Order Operation PRT
I_MaintOrderSettlmtDistrRule view inner BASIC Maintenance Order Settlement Rule
I_MaintOrderSettlmtDistrRule_2 view inner BASIC Maintenance Order Settlement Rule
I_ProjSchedMaintOrderBasicData view from BASIC Project Schedule Data for Work Order Basic
P_MaintOrderDuration view from BASIC
pp_mrp_read_mfg_order_comp view left_outer Read Manufacturing Order Components
SDM_AFIH_STATE view from

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR Order
artpr ARTPR PriorityType
priok PRIOK Priority
equnr EQUNR Equipment
bautl BAUTL Assembly
iloan ILOAN Loc/AccAssmt
iloai ILOAI ILOA individ.
anlzu ANLZU SystemCondition
iwerk IWERK Planning Plant
ingpr INGRP Planner Group
apgrp VAGRP Planner Group
pm_objty PM_OBJTY Object Type
gewrk LGWID Work Center
kunum KUNUM Customer
aning ANING Person respons.
gauzt GAUZT PlanDowntime/h
gaueh MAUEH Unit
anlbd ANLBD Available to
anlvd ANLVD Available from
anlbz ANLBZ Avail. to time
anlvz ANLVZ Available from
inspk INSPK TechInspectn by
datan DATAN TechInspec on
warpl WARPL MaintenancePlan
abnum ABNUM Call Number
wapos WAPOS MaintItem
laufn LAUFN Last order
obknr OBJKNR Object list
revnr REVNI Revision
addat ADDAT Reference Date
aduhr ADUHR Reference time
iphas PM_PHASE Phase
ilart ILA MaintActivType
qmnum QMNUM Notification
hisda HISDA Hist.fr.
akknz AKKNZ Category
plknz AUF_PLKNZ OrderPlanInd.
serialnr GERNR Serial Number
sermat MATNR Material
deviceid DEVICEID Device Data
screenty SCRTP Scenario
adpsp ADDCOMPARE_CORE Ref. Element PM/PS
rsupg RSUPG Upgrade Order
changeddatetime TZNTSTMPS Time Stamp
maintordpersonresponsible EAMS_PERSON_RESPONSIBLE Person Resp. ID
maintordovrlprocphase EAM_OSTAT_PHASE Process Phase
maintordovrlprocsubphase EAM_OSTAT_SPHASE Process Subphase
mainworkcompleteddatetime EAM_MAIN_WORK_COMPLETED_TSTMP Main Work Completed
dummy_afih_incl_eew_ps CFD_DUMMY Dummy
maintorderprocessingcontext MAINTORDERPROCESSINGCONTEXT Processing Context
uii UII_CHAR72 UII
datamodelversion EAM_SDM_VERSION_AFIH Migration State
service_doc_type CRMT_PROCESS_TYPE Transaction Type
service_doc_id CRMT_OBJECT_ID_DB Transaction ID
service_doc_item_id CRMS4_NUMBER_INT Item Number in Doc.
is_billable EAM_BILLABLE Billable
fldlogsdelivisheldonshore FLOG_HOLD Hold On-Shore
maintordprocmtintegscenario MAINTORDPROCMTINTEGSCENARIO Procurement Mode
orcod ADPM_ORDERCODE PM/CS Order Code
prman ADPM_PRMAN Prio.Manually Chgd
prval ADPM_RTPRIO Priority
twtde ADPM_TWTFLAG TWT Std/Min.
mstck CHAR1 Single-Character Flag
lacd_date LACD_DATE Final Due Date
old_lacd_date LACD_OLD Prev. Final Due Date

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.

-- Maintenance order header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFIH (
    MANDT,                        -- Client [MANDT]
    AUFNR,                        -- Order [AUFNR]
    ARTPR,                        -- PriorityType [ARTPR]
    PRIOK,                        -- Priority [PRIOK]
    EQUNR,                        -- Equipment [EQUNR]
    BAUTL,                        -- Assembly [BAUTL]
    ILOAN,                        -- Loc/AccAssmt [ILOAN]
    ILOAI,                        -- ILOA individ. [ILOAI]
    ANLZU,                        -- SystemCondition [ANLZU]
    IWERK,                        -- Planning Plant [IWERK]
    INGPR,                        -- Planner Group [INGRP]
    APGRP,                        -- Planner Group [VAGRP]
    PM_OBJTY,                     -- Object Type [PM_OBJTY]
    GEWRK,                        -- Work Center [LGWID]
    KUNUM,                        -- Customer [KUNUM]
    ANING,                        -- Person respons. [ANING]
    GAUZT,                        -- PlanDowntime/h [GAUZT]
    GAUEH,                        -- Unit [MAUEH]
    ANLBD,                        -- Available to [ANLBD]
    ANLVD,                        -- Available from [ANLVD]
    ANLBZ,                        -- Avail. to time [ANLBZ]
    ANLVZ,                        -- Available from [ANLVZ]
    INSPK,                        -- TechInspectn by [INSPK]
    DATAN,                        -- TechInspec on [DATAN]
    WARPL,                        -- MaintenancePlan [WARPL]
    ABNUM,                        -- Call Number [ABNUM]
    WAPOS,                        -- MaintItem [WAPOS]
    LAUFN,                        -- Last order [LAUFN]
    OBKNR,                        -- Object list [OBJKNR]
    REVNR,                        -- Revision [REVNI]
    ADDAT,                        -- Reference Date [ADDAT]
    ADUHR,                        -- Reference time [ADUHR]
    IPHAS,                        -- Phase [PM_PHASE]
    ILART,                        -- MaintActivType [ILA]
    QMNUM,                        -- Notification [QMNUM]
    HISDA,                        -- Hist.fr. [HISDA]
    AKKNZ,                        -- Category [AKKNZ]
    PLKNZ,                        -- OrderPlanInd. [AUF_PLKNZ]
    SERIALNR,                     -- Serial Number [GERNR]
    SERMAT,                       -- Material [MATNR]
    DEVICEID,                     -- Device Data [DEVICEID]
    SCREENTY,                     -- Scenario [SCRTP]
    ADPSP,                        -- Ref. Element PM/PS [ADDCOMPARE_CORE]
    RSUPG,                        -- Upgrade Order [RSUPG]
    CHANGEDDATETIME,              -- Time Stamp [TZNTSTMPS]
    MAINTORDPERSONRESPONSIBLE,    -- Person Resp. ID [EAMS_PERSON_RESPONSIBLE]
    MAINTORDOVRLPROCPHASE,        -- Process Phase [EAM_OSTAT_PHASE]
    MAINTORDOVRLPROCSUBPHASE,     -- Process Subphase [EAM_OSTAT_SPHASE]
    MAINWORKCOMPLETEDDATETIME,    -- Main Work Completed [EAM_MAIN_WORK_COMPLETED_TSTMP]
    DUMMY_AFIH_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    MAINTORDERPROCESSINGCONTEXT,  -- Processing Context [MAINTORDERPROCESSINGCONTEXT]
    UII,                          -- UII [UII_CHAR72]
    DATAMODELVERSION,             -- Migration State [EAM_SDM_VERSION_AFIH]
    SERVICE_DOC_TYPE,             -- Transaction Type [CRMT_PROCESS_TYPE]
    SERVICE_DOC_ID,               -- Transaction ID [CRMT_OBJECT_ID_DB]
    SERVICE_DOC_ITEM_ID,          -- Item Number in Doc. [CRMS4_NUMBER_INT]
    IS_BILLABLE,                  -- Billable [EAM_BILLABLE]
    FLDLOGSDELIVISHELDONSHORE,    -- Hold On-Shore [FLOG_HOLD]
    MAINTORDPROCMTINTEGSCENARIO,  -- Procurement Mode [MAINTORDPROCMTINTEGSCENARIO]
    ORCOD,                        -- PM/CS Order Code [ADPM_ORDERCODE]
    PRMAN,                        -- Prio.Manually Chgd [ADPM_PRMAN]
    PRVAL,                        -- Priority [ADPM_RTPRIO]
    TWTDE,                        -- TWT Std/Min. [ADPM_TWTFLAG]
    MSTCK,                        -- Single-Character Flag [CHAR1]
    LACD_DATE,                    -- Final Due Date [LACD_DATE]
    OLD_LACD_DATE,                -- Prev. Final Due Date [LACD_OLD]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More