P_INSPLOTRESULTRECORDING

CDS View
22 Fields 1 CDS Views

Inspection Lot Result Recording

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_InspLotUsageDecisionOVP view_entity from CONSUMPTION Inspection Lot Usage Decision OVP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 2
KEY InspLotEndDateGrp InspLotEndDateGrp 3
_InspLotEndDateGrp _InspLotEndDateGrp 2
BatchStorageLocation BatchStorageLocation 2
Customer Customer 2
InspectionLotHasQuantity InspectionLotHasQuantity 2
InspectionLotHasUsageDecision InspectionLotHasUsageDecision 2
InspectionLotOrigin InspectionLotOrigin 2
InspectionLotStorageLocation InspectionLotStorageLocation 1
InspectionLotType InspectionLotType 2
InspLotIsTaskListRequired InspLotIsTaskListRequired 2
InspLotRsltRecgStatus InspLotRsltRecgStatus 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
Manufacturer Manufacturer 2
ManufacturerPartNmbr ManufacturerPartNmbr 2
Material Material 2
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 2
Plant Plant 2
PurchasingOrganization PurchasingOrganization 2
SalesOrganization SalesOrganization 2
SoldToParty SoldToParty 2
Supplier Supplier 2

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_INSPLOTRESULTRECORDING (
    INSPECTIONLOT,
    INSPLOTENDDATEGRP,
    _INSPLOTENDDATEGRP,
    BATCHSTORAGELOCATION,
    CUSTOMER,
    INSPECTIONLOTHASQUANTITY,
    INSPECTIONLOTHASUSAGEDECISION,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTYPE,
    INSPLOTISTASKLISTREQUIRED,
    INSPLOTRSLTRECGSTATUS,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT, INSPLOTENDDATEGRP)
);

Learn More