Fields (51)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA