P_INSPLOTRSLTRECGSTATUS

CDS View
18 Fields 1 CDS Views

Inspection Lot Result Recording

P_INSPLOTRSLTRECGSTATUS is a CDS View in S/4HANA. Inspection Lot Result Recording. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_InspUsageDecisionOVP view from CONSUMPTION Usage Decision Overview Page

Fields (18)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 1
BatchStorageLocation BatchStorageLocation 1
Customer Customer 1
InspectionLotOrigin InspectionLotOrigin 1
InspectionLotStorageLocation InspectionLotStorageLocation 1
InspectionLotType InspectionLotType 1
InspLotRsltRecgStatus InspLotRsltRecgStatus 1
InspLotRsltRecgStatusText InspLotRsltRecgStatusText 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
Manufacturer Manufacturer 1
ManufacturerPartNmbr ManufacturerPartNmbr 1
Material Material 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 1
Plant Plant 1
PurchasingOrganization PurchasingOrganization 1
SalesOrganization SalesOrganization 1
SoldToParty SoldToParty 1
Supplier Supplier 1

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 Lot Result Recording
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_INSPLOTRSLTRECGSTATUS (
    INSPECTIONLOT,
    BATCHSTORAGELOCATION,
    CUSTOMER,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTYPE,
    INSPLOTRSLTRECGSTATUS,
    INSPLOTRSLTRECGSTATUSTEXT,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT)
);

Learn More