/SPE/INSPECRESH

Transparent Table Application Table
29 Fields 3 CDS Views

Inspection Outcome: Header

/SPE/INSPECRESH is an SAP database table in S/4HANA. Inspection Outcome: Header. It contains 29 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 (29)

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
created_on TIMESTAMP Time Stamp
created_by ERNAM Created By
changed_on TIMESTAMP Time Stamp
changed_by AENAM Changed By
msr_id MSR_PROCESS_ID Process ID No.
ref_doc MSR_DOC_NR Document Number
ref_doc_item MSR_DOC_ITEM Document Item
ref_doc_type MSR_DOC_TYPE Doc. Type
insp_vendor MSR_INSP_VENDOR Insp. Supplier
at_customer_site MSR_AT_CUSTOMER_SITE Insp. at Cust.
insp_cancelled MSR_INSP_CANCELLED Cancelled
fup_block MSR_INSP_FUP_BLOCK Follow-Up Block
prueflos QPLOS Inspection Lot
teillos QTLOS Partial Lot

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]
    CREATED_ON,        -- Time Stamp [TIMESTAMP]
    CREATED_BY,        -- Created By [ERNAM]
    CHANGED_ON,        -- Time Stamp [TIMESTAMP]
    CHANGED_BY,        -- Changed By [AENAM]
    MSR_ID,            -- Process ID No. [MSR_PROCESS_ID]
    REF_DOC,           -- Document Number [MSR_DOC_NR]
    REF_DOC_ITEM,      -- Document Item [MSR_DOC_ITEM]
    REF_DOC_TYPE,      -- Doc. Type [MSR_DOC_TYPE]
    INSP_VENDOR,       -- Insp. Supplier [MSR_INSP_VENDOR]
    AT_CUSTOMER_SITE,  -- Insp. at Cust. [MSR_AT_CUSTOMER_SITE]
    INSP_CANCELLED,    -- Cancelled [MSR_INSP_CANCELLED]
    FUP_BLOCK,         -- Follow-Up Block [MSR_INSP_FUP_BLOCK]
    PRUEFLOS,          -- Inspection Lot [QPLOS]
    TEILLOS,           -- Partial Lot [QTLOS]
    PRIMARY KEY (MANDT, INSPEC_NO)
);

Learn More