I_InspLotSerialNumberTP

DDL: I_INSPLOTSERIALNUMBERTP SQL: IINSPLOTSRLNUMTP Type: view TRANSACTIONAL
8 Fields 2 Data Sources 1 Associations

Inspection Lot Serial Number - TP

I_InspLotSerialNumberTP is a Transactional CDS View that provides data about "Inspection Lot Serial Number - TP" in SAP S/4HANA. It reads from 2 data sources (P_InspSrlNmbrUsgeDcsnStkPostd, I_InspLotSerialNumber) and exposes 8 fields with key fields InspectionLot, SerialNumber, InspLotMatlDocItem, SerialNumber, InspLotMatlDocItem. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_InspSrlNmbrUsgeDcsnStkPostd _SerNumStckPost union
I_InspLotSerialNumber I_InspLotSerialNumber from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTSRLNUMTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Inspection Lot Serial Number - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey SerialNumber view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence QINSPLOTSRLNUM_D view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspLotSerialNumber InspectionLot Inspection Lot
KEY SerialNumber I_InspLotSerialNumber SerialNumber Serial Number
KEY InspLotMatlDocItem P_InspSrlNmbrUsgeDcsnStkPostd InspLotMatlDocItem
InspectionLot Inspection Lot
KEY SerialNumber P_InspSrlNmbrUsgeDcsnStkPostd SerialNumber Serial Number
KEY InspLotMatlDocItem P_InspSrlNmbrUsgeDcsnStkPostd InspLotMatlDocItem
InspSrlNumbHasUsgeDcsnStkPostg P_InspSrlNmbrUsgeDcsnStkPostd InspSrlNumbHasUsgeDcsnStkPostg
_InspectionLot _InspectionLot

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InspLotSerialNumberTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IINSPLOTSRLNUMTP

CREATE VIEW I_InspLotSerialNumberTP AS
SELECT
  I_InspLotSerialNumber.InspectionLot AS InspectionLot,
  I_InspLotSerialNumber.SerialNumber AS SerialNumber,
  _SerNumStckPost.InspLotMatlDocItem AS InspLotMatlDocItem,
  _SerNumStckPost.InspSrlNumbHasUsgeDcsnStkPostg AS InspSrlNumbHasUsgeDcsnStkPostg
FROM I_InspLotSerialNumber
LEFT OUTER JOIN I_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
-- UNION with additional select branch(es): P_InspSrlNmbrUsgeDcsnStkPostd
;

Learn More