C_INSPECTIONLOTWITHRESULTREC

CDS View
19 Fields 1 CDS Views

Inspection Lot with Result Recording

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_InspLotRsltRecgStatus view from CONSUMPTION Inspection Lot Result Recording

Fields (19)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 1
BatchStorageLocation BatchStorageLocation 1
Customer Customer 1
InspectionLotHasQuantity InspectionLotHasQuantity 1
InspectionLotHasUsageDecision InspectionLotHasUsageDecision 1
InspectionLotOrigin InspectionLotOrigin 1
InspectionLotStorageLocation InspectionLotStorageLocation 1
InspectionLotType InspectionLotType 1
InspLotRsltRecgStatus InspLotRsltRecgStatus 1
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 with Result Recording
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_INSPECTIONLOTWITHRESULTREC (
    INSPECTIONLOT,
    BATCHSTORAGELOCATION,
    CUSTOMER,
    INSPECTIONLOTHASQUANTITY,
    INSPECTIONLOTHASUSAGEDECISION,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTYPE,
    INSPLOTRSLTRECGSTATUS,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT)
);

Learn More