A_InspectionMethodText

DDL: A_INSPECTIONMETHODTEXT Type: view_entity COMPOSITE Package: ODATA_QM_PLAN_API
9 Fields 1 Data Sources 1 Associations

Inspection Method Texts

A_InspectionMethodText is a Composite CDS View that provides data about "Inspection Method Texts" in SAP S/4HANA. It reads from 1 data source (I_InspectionMethodVersionText) and exposes 9 fields with key fields InspectionMethodPlant, InspectionMethod, InspectionMethodVersion, Language. It has 1 association to related views. Part of development package ODATA_QM_PLAN_API.

Data Sources (1)

SourceAliasJoin Type
I_InspectionMethodVersionText I_InspectionMethodVersionText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_InspectionMethod _InspectionMethod $projection.InspectionMethod = _InspectionMethod.InspectionMethod and $projection.InspectionMethodVersion = _InspectionMethod.InspectionMethodVersion and $projection.InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant

Annotations (12)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Inspection Method Texts view
AccessControl.authorizationCheck #CHECK view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethodPlant I_InspectionMethodVersionText InspectionMethodPlant Receiving Plant
KEY InspectionMethod I_InspectionMethodVersionText InspectionMethod Insp. Method
KEY InspectionMethodVersion I_InspectionMethodVersionText InspectionMethodVersion XML Vers.
KEY Language I_InspectionMethodVersionText Language Report Text Language
InspectionMethodText I_InspectionMethodVersionText InspectionMethodText
InspMethodHasLongText I_InspectionMethodVersionText InspMethodHasLongText
QltyMstrDataAuthorizationGroup _InspectionMethod QltyMstrDataAuthorizationGroup
InspectionMethodStatus _InspectionMethod InspectionMethodStatus
_InspectionMethod _InspectionMethod

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 A_InspectionMethodText.
-- 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 A_InspectionMethodText AS
SELECT
  I_InspectionMethodVersionText.InspectionMethodPlant AS InspectionMethodPlant,
  I_InspectionMethodVersionText.InspectionMethod AS InspectionMethod,
  I_InspectionMethodVersionText.InspectionMethodVersion AS InspectionMethodVersion,
  I_InspectionMethodVersionText.Language AS Language,
  I_InspectionMethodVersionText.InspectionMethodText AS InspectionMethodText,
  I_InspectionMethodVersionText.InspMethodHasLongText AS InspMethodHasLongText,
  _InspectionMethod.QltyMstrDataAuthorizationGroup AS QltyMstrDataAuthorizationGroup,
  _InspectionMethod.InspectionMethodStatus AS InspectionMethodStatus
FROM I_InspectionMethodVersionText
LEFT OUTER JOIN A_InspectionMethod AS _InspectionMethod ON InspectionMethod = _InspectionMethod.InspectionMethod AND InspectionMethodVersion = _InspectionMethod.InspectionMethodVersion AND InspectionMethodPlant = _InspectionMethod.InspectionMethodPlant  -- association [1..1]
;

Learn More