I_DocInfoRecordObjLinkAddlInfo

DDL: I_DOCINFORECORDOBJLINKADDLINFO SQL: ICVDOCINFORECOLN Type: view COMPOSITE

Document Info Record Object Link ( ESH )

I_DocInfoRecordObjLinkAddlInfo is a Composite CDS View that provides data about "Document Info Record Object Link ( ESH )" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordObjectLink) and exposes 12 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, LinkedSAPObject. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecordObjectLink ObjLinkESH from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_RecipeForKeyDate _RecipeForKeyDate $projection.LinkedSAPObjectKey = _RecipeForKeyDate.RecipeUniqueID and $projection.LinkedSAPObject = '/PLMB/RCP'
[0..*] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.LinkedSAPObjectKey = _SpecificationForKeyDate.Specification and $projection.LinkedSAPObject = 'ESTRH'
[0..1] I_ChangeMaster _ChangeMasterObjLink $projection.LinkedSAPObjectKey = _ChangeMasterObjLink.ChangeNumber
[0..*] I_TextObjectPlainLongText _TextObjectPlainLongText $projection.DocInfoRecdLongTextUUID = _TextObjectPlainLongText.TextObjectKey and _TextObjectPlainLongText.TextObjectCategory = 'DRAD' and _TextObjectPlainLongText.TextObjectType = 'LTXT'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCINFORECOLN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Document Info Record Object Link ( ESH ) view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart
KEY LinkedSAPObject LinkedSAPObject
KEY LinkedSAPObjectKey LinkedSAPObjectKey
KEY DocObjectLinkCounter DocObjectLinkCounter
DocInfoRecdLongTextUUID DocInfoRecdLongTextUUID
_ChangeMasterObjLink _ChangeMasterObjLink
_RecipeForKeyDate _RecipeForKeyDate
_SpecificationForKeyDate _SpecificationForKeyDate
_TextObjectPlainLongText _TextObjectPlainLongText 
@AbapCatalog.sqlViewName: 'ICVDOCINFORECOLN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_TextObjectPlainLongText']
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #MIXED}
@EndUserText.label: 'Document Info Record Object Link ( ESH )'

define view I_DocInfoRecordObjLinkAddlInfo
  as select from I_DocumentInfoRecordObjectLink as ObjLinkESH


  //Need to be changed to new CDS view with @VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

  association [0..*] to I_RecipeForKeyDate             as _RecipeForKeyDate          on  $projection.LinkedSAPObjectKey = _RecipeForKeyDate.RecipeUniqueID
                                                                                     and $projection.LinkedSAPObject    = '/PLMB/RCP'

  //Need to be changed to new CDS view with @VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

  association [0..*] to I_SpecificationForKeyDate      as _SpecificationForKeyDate   on  $projection.LinkedSAPObjectKey = _SpecificationForKeyDate.Specification
                                                                                     and $projection.LinkedSAPObject    = 'ESTRH'

  association [0..1] to I_ChangeMaster                 as _ChangeMasterObjLink       on  $projection.LinkedSAPObjectKey = _ChangeMasterObjLink.ChangeNumber

  /*
    //Restricted 'bintohex' function on key field

    association [0..*] to I_ProductStructureNode        as _ProductStructureNode        on  $projection.LinkedSAPObjectKey = _ProductStructureNode.ProductStructureNodeUniqueID
                                                                                        and $projection.LinkedSAPObject    = 'PNODID'
    //Restricted 'concat' function on key field

    association [0..*] to I_ProductStructureVariantNode as _ProductStructureVariantNode on  $projection.LinkedSAPObjectKey = _ProductStructureVariantNode.ProdStrucVariantConcatenated
                                                                                        and $projection.LinkedSAPObject    = 'POSVID'
    //Restricted 'bintohex' function on key field

     association [0..*] to I_MaterialBOM                 as _MaterialBOM                 on  $projection.LinkedSAPObjectKey = _MaterialBOM.BOMCharUUID
                                                                                         and $projection.LinkedSAPObject    = 'POSVID'
   */
  association [0..*] to I_TextObjectPlainLongText      as _TextObjectPlainLongText   on  $projection.DocInfoRecdLongTextUUID         = _TextObjectPlainLongText.TextObjectKey
                                                                                     and _TextObjectPlainLongText.TextObjectCategory = 'DRAD'
                                                                                     and _TextObjectPlainLongText.TextObjectType     = 'LTXT'

{
  key DocumentInfoRecordDocType,
  key DocumentInfoRecordDocNumber,
  key DocumentInfoRecordDocVersion,
  key DocumentInfoRecordDocPart,
  key LinkedSAPObject,
  key LinkedSAPObjectKey,
  key DocObjectLinkCounter,

      DocInfoRecdLongTextUUID,
      _ChangeMasterObjLink,
      _RecipeForKeyDate,
      _SpecificationForKeyDate,
      /*       _ProductStructureNode,
             _ProductStructureVariantNode,
             _MaterialBOM, */
      _TextObjectPlainLongText
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORDOBJECTLINK"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_RECIPEFORKEYDATE",
"I_SPECIFICATIONFORKEYDATE",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More