ESH_N_MASTERINSPCHAR

DDL: ESH_N_MASTERINSPCHAR SQL: ESH_L_INSPMIC Type: view Package: BSESH_QM_IM

Anchor view -MASTERINSPCHAR

ESH_N_MASTERINSPCHAR is a CDS View that provides data about "Anchor view -MASTERINSPCHAR" in SAP S/4HANA. It reads from 1 data source (I_INSPSPECIFICATIONVERSION) and exposes 20 fields with key fields INSPECTIONSPECIFICATION, INSPECTIONSPECIFICATIONPLANT, INSPECTIONSPECIFICATIONVERSION. It has 2 associations to related views. Part of development package BSESH_QM_IM.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_INSPSPECIFICATIONVERSION I_INSPSPECIFICATIONVERSION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..*] dd07t _INSPSPECSTATUS $projection.InspectionSpecificationStatus=_INSPSPECSTATUS.domvalue_l and _INSPSPECSTATUS.domname='QLOESCHKZ' and _INSPSPECSTATUS.as4local='A'
[0..*] dd07t _INSPSPECTRANSFERTYPE ( $projection.InspSpecTransferType=_INSPSPECTRANSFERTYPE.domvalue_l AND _INSPSPECTRANSFERTYPE.domname='QVOLLST' AND _INSPSPECTRANSFERTYPE.as4local='A' )

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_INSPMIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY INSPECTIONSPECIFICATION INSPECTIONSPECIFICATION
KEY INSPECTIONSPECIFICATIONPLANT INSPECTIONSPECIFICATIONPLANT
KEY INSPECTIONSPECIFICATIONVERSION INSPECTIONSPECIFICATIONVERSION
INSPECTIONMASTERDATASTATUSTEXT
INSPECTIONSPECIFICATIONSRCHTXT INSPECTIONSPECIFICATIONSRCHTXT
INSPECTIONSPECIFICATIONSTATUS INSPECTIONSPECIFICATIONSTATUS
INSPECTIONSPECIFICATIONTEXT
INSPECTORQUALIFICATION INSPECTORQUALIFICATION
INSPECTORQUALIFICATIONTEXT
INSPSPECGLOBALNAME INSPSPECGLOBALNAME
INSPSPECIMPORTANCECODE INSPSPECIMPORTANCECODE
INSPSPECIMPORTANCECODETEXT
INSPSPECINFORMATIONFIELD1 INSPSPECINFORMATIONFIELD1
INSPSPECTRANSFERTYPE INSPSPECTRANSFERTYPE
INSPSPECTRANSFERTYPETEXT
PLANTNAME _INSPSPECIFICATIONPLANT PLANTNAME
QLTYMSTRDATAAUTHORIZATIONGROUP QLTYMSTRDATAAUTHORIZATIONGROUP
QLTYMSTRDATAAUTHZNGROUPTXT
USERDESCRIPTION _INSPSPECCREATEDBYUSER USERDESCRIPTION
VALIDITYSTARTDATE VALIDITYSTARTDATE 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ESH_L_INSPMIC'
define view ESH_N_MASTERINSPCHAR
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_INSPSPECIFICATIONVERSION
association [0..*] to dd07t as _INSPSPECSTATUS on  $projection.InspectionSpecificationStatus=_INSPSPECSTATUS.domvalue_l and  _INSPSPECSTATUS.domname='QLOESCHKZ' and  _INSPSPECSTATUS.as4local='A' association [0..*] to dd07t as _INSPSPECTRANSFERTYPE on ( $projection.InspSpecTransferType=_INSPSPECTRANSFERTYPE.domvalue_l AND  _INSPSPECTRANSFERTYPE.domname='QVOLLST' AND  _INSPSPECTRANSFERTYPE.as4local='A' ) {

key INSPECTIONSPECIFICATION,

key INSPECTIONSPECIFICATIONPLANT,

key INSPECTIONSPECIFICATIONVERSION,

_INSPSPECSTATUS[1: ddlanguage = $parameters. P_Language].ddtext as INSPECTIONMASTERDATASTATUSTEXT,

INSPECTIONSPECIFICATIONSRCHTXT,

INSPECTIONSPECIFICATIONSTATUS,

_TEXT[1: LANGUAGE = $parameters. P_Language].INSPECTIONSPECIFICATIONTEXT,

INSPECTORQUALIFICATION,

_INSPECTORQUALIFICATION._INSPECTORQUALIFICATIONTEXT[1: LANGUAGE = $parameters. P_Language].INSPECTORQUALIFICATIONTEXT,

INSPSPECGLOBALNAME,

INSPSPECIMPORTANCECODE,

_INSPSPECIMPORTANCECODE._TEXT[1: LANGUAGE = $parameters. P_Language].INSPSPECIMPORTANCECODETEXT,

INSPSPECINFORMATIONFIELD1,

INSPSPECTRANSFERTYPE,

_INSPSPECTRANSFERTYPE[1: ddlanguage = $parameters. P_Language].ddtext as INSPSPECTRANSFERTYPETEXT,

_INSPSPECIFICATIONPLANT.PLANTNAME,

QLTYMSTRDATAAUTHORIZATIONGROUP,

_QLTYMSTRDATAAUTHZNGRPTXT[1: LANGUAGE = $parameters. P_Language].QLTYMSTRDATAAUTHZNGROUPTXT,

_INSPSPECCREATEDBYUSER.USERDESCRIPTION,

VALIDITYSTARTDATE
}

Learn More