P_DocInfoRecdBOMLink

DDL: P_DOCINFORECDBOMLINK SQL: PCVDIRBOMLINK Type: view BASIC

P_DocInfoRecdBOMLink is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dost) and exposes 10 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart, BillOfMaterial.

Data Sources (1)

SourceAliasJoin Type
dost DocBomLink from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCVDIRBOMLINK view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DocumentType dost dokar
KEY DocumentInfoRecord dost doknr
KEY DocumentVersion dost dokvr
KEY DocumentPart dost doktl
KEY BillOfMaterial dost stlnr
KEY AlternativeBillOfMaterial dost stlal
CreatedByUser dost annam
CreationDate dost andat
LastChangedByUser dost aenam
LastChangeDate dost aedat
@AbapCatalog.sqlViewName: 'PCVDIRBOMLINK'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_DocInfoRecdBOMLink
  as select from dost as DocBomLink
{
  key DocBomLink.dokar as DocumentType,
  key DocBomLink.doknr as DocumentInfoRecord,
  key DocBomLink.dokvr as DocumentVersion,
  key DocBomLink.doktl as DocumentPart,
  key DocBomLink.stlnr as BillOfMaterial,
  key DocBomLink.stlal as AlternativeBillOfMaterial,
      DocBomLink.annam as CreatedByUser,
      DocBomLink.andat as CreationDate,
      DocBomLink.aenam as LastChangedByUser,
      DocBomLink.aedat as LastChangeDate

}