I_QltyFirstArticleInsp

DDL: I_QLTYFIRSTARTICLEINSP Type: view_entity BASIC Package: VDM_QM_PLANNING
12 Fields 1 Data Sources 1 Associations

First Article Inspection

I_QltyFirstArticleInsp is a Basic CDS View that provides data about "First Article Inspection" in SAP S/4HANA. It reads from 1 data source (qinf_fai) and exposes 12 fields with key fields Material, QltyInProcmtIntID, QltyInProcmt1stArticleInsp. It has 1 association to related views. Part of development package VDM_QM_PLANNING.

Data Sources (1)

SourceAliasJoin Type
qinf_fai qinf_fai from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_QualityInProcurement _QualityInProcurement $projection.Material = _QualityInProcurement.Material and $projection.QltyInProcmtIntID = _QualityInProcurement.QltyInProcmtIntID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label First Article Inspection view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey QltyInProcmt1stArticleInsp view
Analytics.technicalName IQLTYFAI view
ObjectModel.sapObjectNodeType.name PurgQltyInfoRecd1stArticleInsp view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Material qinf_fai matnr Vehicle Model
KEY QltyInProcmtIntID
KEY QltyInProcmt1stArticleInsp qinf_fai fai_id First Article Insp.
PurchaseOrder qinf_fai ebeln Source PurchDoc
PurchaseOrderItem qinf_fai ebelp Item pur. doc.
InspLotUsageDecisionValuation qinf_fai valuation Valuation View
QltyInProcmtHas1stArticleInsp qinf_fai fai_insp_exists FAI Exists
CreatedByUser qinf_fai ersteller Created By
CreationDate qinf_fai erstelldat Created On
LastChangedByUser qinf_fai aenderer Changed By
ChangedDateTime qinf_fai changeddatetime Time Stamp
_QualityInProcurement _QualityInProcurement

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_QltyFirstArticleInsp.
-- 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 I_QltyFirstArticleInsp AS
SELECT
  qinf_fai.matnr AS Material,
  cast(qinf_fai.zaehl as vdm_qm_qltyinprocmtintid ) AS QltyInProcmtIntID,
  qinf_fai.fai_id AS QltyInProcmt1stArticleInsp,
  qinf_fai.ebeln AS PurchaseOrder,
  qinf_fai.ebelp AS PurchaseOrderItem,
  qinf_fai.valuation AS InspLotUsageDecisionValuation,
  qinf_fai.fai_insp_exists AS QltyInProcmtHas1stArticleInsp,
  qinf_fai.ersteller AS CreatedByUser,
  qinf_fai.erstelldat AS CreationDate,
  qinf_fai.aenderer AS LastChangedByUser,
  qinf_fai.changeddatetime AS ChangedDateTime
FROM qinf_fai
LEFT OUTER JOIN I_QualityInProcurement AS _QualityInProcurement ON Material = _QualityInProcurement.Material AND QltyInProcmtIntID = _QualityInProcurement.QltyInProcmtIntID  -- association [1..1]
;

Learn More