I_QltyFirstArticleInsp

DDL: I_QLTYFIRSTARTICLEINSP SQL: IQLTYFAI Type: view BASIC

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.

1 data source(s) 12 fields

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 (13)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYFAI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label First Article Inspection view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey QltyInProcmt1stArticleInsp view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Material qinf_fai matnr
KEY QltyInProcmtIntID
KEY QltyInProcmt1stArticleInsp qinf_fai fai_id
PurchaseOrder qinf_fai ebeln
PurchaseOrderItem qinf_fai ebelp
InspLotUsageDecisionValuation qinf_fai valuation
QltyInProcmtHas1stArticleInsp qinf_fai fai_insp_exists
CreatedByUser qinf_fai ersteller
CreationDate qinf_fai erstelldat
LastChangedByUser qinf_fai aenderer
ChangedDateTime qinf_fai changeddatetime
_QualityInProcurement _QualityInProcurement 
@AbapCatalog.sqlViewName: 'IQLTYFAI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'First Article Inspection'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.representativeKey: 'QltyInProcmt1stArticleInsp'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #S, dataClass: #MASTER }
define view I_QltyFirstArticleInsp as select from qinf_fai
association [1..1] to I_QualityInProcurement as _QualityInProcurement
  on $projection.Material = _QualityInProcurement.Material
  and $projection.QltyInProcmtIntID = _QualityInProcurement.QltyInProcmtIntID
{
  key qinf_fai.matnr as Material,
  key cast(qinf_fai.zaehl as vdm_qm_qltyinprocmtintid ) as QltyInProcmtIntID,
  key 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, 
  //Associations

  _QualityInProcurement // Make association public

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QINF_FAI"
],
"ASSOCIATED":
[
"I_QUALITYINPROCUREMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More