AFIH

Transparent Table Application Table
5 Fields 13 CDS Views

Maintenance order header

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

CDS Views using this table (13)

ViewTypeJoinVDMDescription
E_MaintenanceOrder view_entity from EXTENSION Maintenance Order Extension
I_FldLogsMaintOrders view from BASIC Get all work orders
I_FldLogsProcRcptMaintOrd view inner BASIC Maintenance orders for process receipts FL
I_MaintenanceOrderBasic view_entity 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
Mmim_MatDocDocFlow view_entity inner Material Documents Document Flow
P_MaintOrderDuration view from BASIC used for AMDP method (Table function) for durations
pp_mrp_read_mfg_order_comp view left_outer Read Manufacturing Order Components
SDM_AFIH_STATE view from Silent Data Migration State for Maintenance Orders

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY aufnr aufnr Order
datamodelversion eam_sdm_version_afih Migration State
fldlogsdelivisheldonshore flog_hold Hold On-Shore
maintordprocmtintegscenario maintordprocmtintegscenario Procurement Mode

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]
    DATAMODELVERSION,             -- Migration State [eam_sdm_version_afih]
    FLDLOGSDELIVISHELDONSHORE,    -- Hold On-Shore [flog_hold]
    MAINTORDPROCMTINTEGSCENARIO,  -- Procurement Mode [maintordprocmtintegscenario]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More