/SPE/INSPECRESH

Transparent Table Application Table
15 Fields 3 CDS Views

Inspection Outcome: Header

/SPE/INSPECRESH is an SAP database table in S/4HANA. Inspection Outcome: Header. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ComplaintInspection view_entity from BASIC Inspection Detail
I_InspectionOutcomeBasic view_entity from BASIC Inspection Outcome Header
I_ReturnsInspectionBasic view_entity from BASIC Returns Inspection

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY inspec_no /spe/inspec_no Inspection Number
rma_number /spe/ret_rma RMA Number
publstatus /spe/insp_publ_stat Publish Stat.
hustatus /spe/insp_hu_stat HU Status
deliv_numb vbeln_vl Delivery
deliv_item posnr_vl Item
hu_exid exidv Handling Unit
whsenumber lgnum Warehouse No.
plant werks_d Plant
stge_loc lgort_d Location
tzone tznzone Time Zone
material matnr Material
delflag /spe/lskenz Del.Flag
_dataaging data_temperature Data Aging

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.

-- Inspection Outcome: Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SPE/INSPECRESH (
    MANDT,       -- Client [mandt]
    INSPEC_NO,   -- Inspection Number [/spe/inspec_no]
    RMA_NUMBER,  -- RMA Number [/spe/ret_rma]
    PUBLSTATUS,  -- Publish Stat. [/spe/insp_publ_stat]
    HUSTATUS,    -- HU Status [/spe/insp_hu_stat]
    DELIV_NUMB,  -- Delivery [vbeln_vl]
    DELIV_ITEM,  -- Item [posnr_vl]
    HU_EXID,     -- Handling Unit [exidv]
    WHSENUMBER,  -- Warehouse No. [lgnum]
    PLANT,       -- Plant [werks_d]
    STGE_LOC,    -- Location [lgort_d]
    TZONE,       -- Time Zone [tznzone]
    MATERIAL,    -- Material [matnr]
    DELFLAG,     -- Del.Flag [/spe/lskenz]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, INSPEC_NO)
);

Learn More