_INSPECTIONLOT

_INSPECTIONLOT is an SAP database table in S/4HANA. It contains 51 fields.

Fields (51)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 7
KEY ManufacturingOrder ManufacturingOrder,ProductionOrder 9
_Customer _Customer 1
_InspectionLotOrigin _InspectionLotOrigin 3
_InspectionLotQuantityUnit _InspectionLotQuantityUnit 1
_InspectionLotType _InspectionLotType 1
_InspectionSubsetType _InspectionSubsetType 1
_Manufacturer _Manufacturer 1
_ManufacturerPartNmbr _ManufacturerPartNmbr 1
_PurchasingOrganization _PurchasingOrganization 1
_SalesOrganization _SalesOrganization 1
_Supplier _Supplier 1
Batch Batch 5
BatchStorageLocation BatchStorageLocation 3
BillOfOperationsType BillOfOperationsType 1
ChangedDateTime ChangedDateTime 2
Customer Customer 3
InspectionLotActualQuantity InspectionLotActualQuantity 1
InspectionLotEndDate InspectionLotEndDate 2
InspectionLotHasPartialLots InspectionLotHasPartialLots 1
InspectionLotHasQuantity InspectionLotHasQuantity 2
InspectionLotOrigin InspectionLotOrigin 8
InspectionLotQuantity InspectionLotQuantity 3
InspectionLotQuantityUnit InspectionLotQuantityUnit 3
InspectionLotStartDate InspectionLotStartDate 1
InspectionLotStorageLocation InspectionLotStorageLocation 2
InspectionLotText InspectionLotText 6
InspectionLotType InspectionLotType 17
InspectionSubsetType InspectionSubsetType 6
InspLotIsSerialNmbrPossible InspLotIsSerialNmbrPossible 1
InspLotUsageDecisionValuation InspLotUsageDecisionValuation 1
InspSubsetFieldCombination InspSubsetFieldCombination 3
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm 1
InventorySpclStkSalesDocument InventorySpclStkSalesDocument 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 14
Manufacturer Manufacturer 3
ManufacturerPartNmbr ManufacturerPartNmbr 4
Material Material 6
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 15
OrderInternalBillOfOperations OrderInternalBillOfOperations 1
Plant Plant 15
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingOrganization PurchasingOrganization 3
SalesOrganization SalesOrganization 3
SerialNumberProfile SerialNumberProfile 1
SoldToParty SoldToParty 3
Supplier Supplier 4

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 _INSPECTIONLOT (
    INSPECTIONLOT,
    MANUFACTURINGORDER,
    _CUSTOMER,
    _INSPECTIONLOTORIGIN,
    _INSPECTIONLOTQUANTITYUNIT,
    _INSPECTIONLOTTYPE,
    _INSPECTIONSUBSETTYPE,
    _MANUFACTURER,
    _MANUFACTURERPARTNMBR,
    _PURCHASINGORGANIZATION,
    _SALESORGANIZATION,
    _SUPPLIER,
    BATCH,
    BATCHSTORAGELOCATION,
    BILLOFOPERATIONSTYPE,
    CHANGEDDATETIME,
    CUSTOMER,
    INSPECTIONLOTACTUALQUANTITY,
    INSPECTIONLOTENDDATE,
    INSPECTIONLOTHASPARTIALLOTS,
    INSPECTIONLOTHASQUANTITY,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTQUANTITY,
    INSPECTIONLOTQUANTITYUNIT,
    INSPECTIONLOTSTARTDATE,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTEXT,
    INSPECTIONLOTTYPE,
    INSPECTIONSUBSETTYPE,
    INSPLOTISSERIALNMBRPOSSIBLE,
    INSPLOTUSAGEDECISIONVALUATION,
    INSPSUBSETFIELDCOMBINATION,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    MATLQUALITYAUTHORIZATIONGROUP,
    ORDERINTERNALBILLOFOPERATIONS,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SERIALNUMBERPROFILE,
    SOLDTOPARTY,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT, MANUFACTURINGORDER)
);