HIKO

Transparent Table Application Table
74 Fields 2 CDS Views

Order master data history

HIKO is an SAP database table in S/4HANA. Order master data history. It contains 74 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintenanceOrderHistory view from BASIC Maintenance Order History
P_MaintOrderHistoryDuration view_entity from BASIC

Fields (74)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR_H Order
auart AUFART Order Type
autyp AUFTYP Order category
ktext AUFTEXT Description
ltext AUFLTEXT Long Txt Exists
loekz AUFLOEKZ Deletion Flag
maufnr MAUFNR_H SuperiorOrder
lead_aufnr LAUFNR_H Leading order
plvar PLVAR Plan version
objnr J_OBJNR Object number
vaplz GEWRK Main WorkCtr
vawrk WERGW Plnt WorkCenter
bukrs BUKRS Company Code
werks WERKS_D Plant
gsber GSBER Business Area
kokrs KOKRS CO Area
waers AUFWAERS Currency
gltrp CO_GLTRP Basic fin. date
gstrp CO_GSTRP Bas. start date
gstri CO_GSTRI Actual start
getri CO_GETRI Actual Finish
pspel PS_PSP_ELE WBS Element
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
zaehl CIM_COUNT Counter
ernam AUFERFNAM Entered By
erdat AUFERFDAT Created On
aenam AUFAENAM Changed By
aedat AUFAEDAT Changed On
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_H 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.
user4 AUFUSER4 Estimated costs
serialnr GERNR Serial Number
sermat MATNR Material
deviceid DEVICEID Device Data
screenty SCRTP Scenario
zzbauleiter ZBAULEITER
uii UII_CHAR72 UII

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.

-- Order master data history
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HIKO (
    MANDT,        -- Client [MANDT]
    AUFNR,        -- Order [AUFNR_H]
    AUART,        -- Order Type [AUFART]
    AUTYP,        -- Order category [AUFTYP]
    KTEXT,        -- Description [AUFTEXT]
    LTEXT,        -- Long Txt Exists [AUFLTEXT]
    LOEKZ,        -- Deletion Flag [AUFLOEKZ]
    MAUFNR,       -- SuperiorOrder [MAUFNR_H]
    LEAD_AUFNR,   -- Leading order [LAUFNR_H]
    PLVAR,        -- Plan version [PLVAR]
    OBJNR,        -- Object number [J_OBJNR]
    VAPLZ,        -- Main WorkCtr [GEWRK]
    VAWRK,        -- Plnt WorkCenter [WERGW]
    BUKRS,        -- Company Code [BUKRS]
    WERKS,        -- Plant [WERKS_D]
    GSBER,        -- Business Area [GSBER]
    KOKRS,        -- CO Area [KOKRS]
    WAERS,        -- Currency [AUFWAERS]
    GLTRP,        -- Basic fin. date [CO_GLTRP]
    GSTRP,        -- Bas. start date [CO_GSTRP]
    GSTRI,        -- Actual start [CO_GSTRI]
    GETRI,        -- Actual Finish [CO_GETRI]
    PSPEL,        -- WBS Element [PS_PSP_ELE]
    PLNTY,        -- Task List Type [PLNTY]
    PLNNR,        -- Group [PLNNR]
    PLNAL,        -- Group Counter [PLNAL]
    ZAEHL,        -- Counter [CIM_COUNT]
    ERNAM,        -- Entered By [AUFERFNAM]
    ERDAT,        -- Created On [AUFERFDAT]
    AENAM,        -- Changed By [AUFAENAM]
    AEDAT,        -- Changed On [AUFAEDAT]
    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_H]
    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]
    USER4,        -- Estimated costs [AUFUSER4]
    SERIALNR,     -- Serial Number [GERNR]
    SERMAT,       -- Material [MATNR]
    DEVICEID,     -- Device Data [DEVICEID]
    SCREENTY,     -- Scenario [SCRTP]
    ZZBAULEITER,  -- ZBAULEITER
    UII,          -- UII [UII_CHAR72]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More