P_MfgInspCharcChgDocItemBasic

DDL: P_MFGINSPCHARCCHGDOCITEMBASIC Type: view_entity COMPOSITE
16 Fields 2 Data Sources

P_MfgInspCharcChgDocItemBasic is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 16 fields with key fields ChangeDocObjectClass, InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, ChangeDocument.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument ChangeDocument from
I_ChangeDocumentItem ChangeDocumentItem inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY InspectionLot
KEY InspPlanOperationInternalID
KEY InspectionCharacteristic
KEY ChangeDocument I_ChangeDocument ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject Object Value
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
CreatedByUser I_ChangeDocument CreatedByUser User Name
CreationDate I_ChangeDocument CreationDate Time Stamp
CreationTime I_ChangeDocument CreationTime Time of Change
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
clientNULLasChangeDocCreationDateTime

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 P_MfgInspCharcChgDocItemBasic.
-- 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.

CREATE VIEW P_MfgInspCharcChgDocItemBasic AS
SELECT
  ChangeDocument.ChangeDocObjectClass AS ChangeDocObjectClass,
  cast(substring(ChangeDocument.ChangeDocObject, 1, 12) as qplos) AS InspectionLot,
  cast(substring(ChangeDocument.ChangeDocObject, 13, 8) as qlfnkn) AS InspPlanOperationInternalID,
  cast(substring(ChangeDocument.ChangeDocObject, 21, 4) as qmerknrp) AS InspectionCharacteristic,
  ChangeDocument.ChangeDocument AS ChangeDocument,
  ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  ChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  ChangeDocumentItem.ChangeDocObject AS ChangeDocObject,
  ChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocument.CreatedByUser AS CreatedByUser,
  ChangeDocument.CreationDate AS CreationDate,
  ChangeDocument.CreationTime AS CreationTime,
  ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  dats_tims_to_tstmp( ChangeDocument.CreationDate,ChangeDocument.CreationTime, 'UTC',$session.client,'NULL' ) as ChangeDocCreationDateTime AS clientNULLasChangeDocCreationDateTime
FROM I_ChangeDocument AS ChangeDocument
INNER JOIN I_ChangeDocumentItem AS ChangeDocumentItem ON /* join condition not captured in parsed metadata */
;

Learn More