ITEMORD

ITEMORD is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY InHouseRepair InHouseRepair 6
KEY InHouseRepairItem InHouseRepairItem 6
KEY ServiceOrder ServiceOrder 6
_InHouseRepair _InHouseRepair 6
InHouseRepairItemUUID InHouseRepairItemUUID 6
InhRepairType InhRepairType 6
ServiceOrderIsNotNew ServiceOrderIsNotNew 6
ServiceOrderIsOpen ServiceOrderIsOpen 6
ServiceOrderIsReleased ServiceOrderIsReleased 6

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ITEMORD (
    INHOUSEREPAIR,
    INHOUSEREPAIRITEM,
    SERVICEORDER,
    _INHOUSEREPAIR,
    INHOUSEREPAIRITEMUUID,
    INHREPAIRTYPE,
    SERVICEORDERISNOTNEW,
    SERVICEORDERISOPEN,
    SERVICEORDERISRELEASED,
    PRIMARY KEY (INHOUSEREPAIR, INHOUSEREPAIRITEM, SERVICEORDER)
);