_INSPLOT

_INSPLOT is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 1
BatchStorageLocation BatchStorageLocation 2
Customer Customer 1
Equipment Equipment 1
EquipmentName EquipmentName 1
FunctionalLocationLabelName FunctionalLocationLabelName 1
FunctionalLocationName FunctionalLocationName 1
InspectionLotOrigin InspectionLotOrigin 1
InspectionLotStorageLocation InspectionLotStorageLocation 1
InspectionLotType InspectionLotType 3
InspLotIsSerialNmbrPossible InspLotIsSerialNmbrPossible 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
Manufacturer Manufacturer 2
ManufacturerPartNmbr ManufacturerPartNmbr 1
ManufacturingOrder ProcessOrder 1
Material Material 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 2
Plant Plant 1
PurchasingOrganization PurchasingOrganization 1
SalesOrganization SalesOrganization 2
SerialNumberProfile SerialNumberProfile 1
SoldToParty SoldToParty 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _INSPLOT (
    INSPECTIONLOT,
    BATCHSTORAGELOCATION,
    CUSTOMER,
    EQUIPMENT,
    EQUIPMENTNAME,
    FUNCTIONALLOCATIONLABELNAME,
    FUNCTIONALLOCATIONNAME,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTYPE,
    INSPLOTISSERIALNMBRPOSSIBLE,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MANUFACTURINGORDER,
    MATERIAL,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SERIALNUMBERPROFILE,
    SOLDTOPARTY,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT)
);