_INSPECTIONLOT

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

Fields (56)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 7
KEY ManufacturingOrder ManufacturingOrder 8
_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
BillOfOperationsUsage BillOfOperationsUsage 1
ChangedDateTime ChangedDateTime 2
Customer Customer 3
Equipment InspectionLotEquipment 1
InspectionLotActualQuantity InspectionLotActualQuantity 1
InspectionLotCreatedOn InspectionLotCreatedOn 1
InspectionLotEndDate InspectionLotEndDate 2
InspectionLotHasPartialLots InspectionLotHasPartialLots 1
InspectionLotHasQuantity InspectionLotHasQuantity 2
InspectionLotOrigin InspectionLotOrigin 8
InspectionLotQuantity InspectionLotQuantity 4
InspectionLotQuantityUnit InspectionLotQuantityUnit 4
InspectionLotStartDate InspectionLotStartDate 1
InspectionLotStorageLocation InspectionLotStorageLocation 2
InspectionLotText InspectionLotText 9
InspectionLotType InspectionLotType 19
InspectionSubsetType InspectionSubsetType 7
InspLotIsSerialNmbrPossible InspLotIsSerialNmbrPossible 1
InspLotUsageDecisionValuation InspLotUsageDecisionValuation 1
InspSubsetFieldCombination InspSubsetFieldCombination 3
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm 1
InventorySpclStkSalesDocument InventorySpclStkSalesDocument 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 15
Manufacturer Manufacturer 3
ManufacturerPartNmbr ManufacturerPartNmbr 4
Material Material 8
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 16
NumberOfSerialNumbers NumberOfSerialNumbers 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 2
Plant InspectionLotPlant,Plant 19
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingOrganization PurchasingOrganization 3
SalesOrganization SalesOrganization 3
SerialNumberProfile SerialNumberProfile 1
SoldToParty SoldToParty 3
StatusObject StatusObject 2
Supplier Supplier 6

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,
    BILLOFOPERATIONSUSAGE,
    CHANGEDDATETIME,
    CUSTOMER,
    EQUIPMENT,
    INSPECTIONLOTACTUALQUANTITY,
    INSPECTIONLOTCREATEDON,
    INSPECTIONLOTENDDATE,
    INSPECTIONLOTHASPARTIALLOTS,
    INSPECTIONLOTHASQUANTITY,
    INSPECTIONLOTORIGIN,
    INSPECTIONLOTQUANTITY,
    INSPECTIONLOTQUANTITYUNIT,
    INSPECTIONLOTSTARTDATE,
    INSPECTIONLOTSTORAGELOCATION,
    INSPECTIONLOTTEXT,
    INSPECTIONLOTTYPE,
    INSPECTIONSUBSETTYPE,
    INSPLOTISSERIALNMBRPOSSIBLE,
    INSPLOTUSAGEDECISIONVALUATION,
    INSPSUBSETFIELDCOMBINATION,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    ISBUSINESSPURPOSECOMPLETED,
    MANUFACTURER,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    MATLQUALITYAUTHORIZATIONGROUP,
    NUMBEROFSERIALNUMBERS,
    ORDERINTERNALBILLOFOPERATIONS,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SERIALNUMBERPROFILE,
    SOLDTOPARTY,
    STATUSOBJECT,
    SUPPLIER,
    PRIMARY KEY (INSPECTIONLOT, MANUFACTURINGORDER)
);