I_DocumentInfoRecordTP

DDL: I_DOCUMENTINFORECORDTP SQL: ICVDOCINFORECTP Type: view TRANSACTIONAL

Document Info Record Transactional

I_DocumentInfoRecordTP is a Transactional CDS View that provides data about "Document Info Record Transactional" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 45 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecord Document from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_DocumentInfoRecordDescTP _Desc $projection.DocumentInfoRecordDocType = _Desc.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Desc.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _Desc.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _Desc.DocumentInfoRecordDocPart
[0..*] I_DocumentInfoRecordObjLinkTP _ObjLink $projection.DocumentInfoRecordDocType = _ObjLink.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _ObjLink.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _ObjLink.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _ObjLink.DocumentInfoRecordDocPart -------Extension
[1..1] E_DocumentInfoRecord _ManageDocDataExtension $projection.DocumentInfoRecordDocType = _ManageDocDataExtension.DocumentInfoRecordDocType -- and $projection.DocumentInfoRecordDocNumber = _ManageDocDataExtension.DocumentInfoRecordDocNumber -- and $projection.DocumentInfoRecordDocVersion = _ManageDocDataExtension.DocumentInfoRecordDocVersion -- and $projection.DocumentInfoRecordDocPart = _ManageDocDataExtension.DocumentInfoRecordDocPart

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCINFORECTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Info Record Transactional view
VDM.viewType #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence DRAW_DRAFT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.entityChangeStateId ChangedDateTime view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.sapObjectNodeType.name DocumentInfoRecord view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType I_DocumentInfoRecord DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber I_DocumentInfoRecord DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion I_DocumentInfoRecord DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart I_DocumentInfoRecord DocumentInfoRecordDocPart
DocumentInfoRecord I_DocumentInfoRecord DocumentInfoRecord
DocInfoRecdIsMarkedForDeletion I_DocumentInfoRecord DocInfoRecdIsMarkedForDeletion
InternalDocumentStatus I_DocumentInfoRecord InternalDocumentStatus
IsDocInfoRecdCreatedFromCAD I_DocumentInfoRecord IsDocInfoRecdCreatedFromCAD
IsDocInfoRecdStructure I_DocumentInfoRecord IsDocInfoRecdStructure
DocInfoRecdSourceDocNumber I_DocumentInfoRecord DocInfoRecdSourceDocNumber
DocInfoRecdSourceDocVersion I_DocumentInfoRecord DocInfoRecdSourceDocVersion
DocInfoRecdSourceDocPart I_DocumentInfoRecord DocInfoRecdSourceDocPart
ResponsiblePersonName I_DocumentInfoRecord ResponsiblePersonName
CreatedByUser I_DocumentInfoRecord CreatedByUser
CreationDateTime I_DocumentInfoRecord CreationDateTime
LastChangedByUser I_DocumentInfoRecord LastChangedByUser
ChangedDateTime I_DocumentInfoRecord ChangedDateTime
DocInfoRecdDocTypeForEdit I_DocumentInfoRecord DocumentInfoRecordDocType
DocInfoRecdDocNumberForEdit I_DocumentInfoRecord DocumentInfoRecordDocNumber
DocInfoRecdDocVersionForEdit I_DocumentInfoRecord DocumentInfoRecordDocVersion
DocInfoRecdDocPartForEdit I_DocumentInfoRecord DocumentInfoRecordDocPart
LaboratoryOrDesignOffice I_DocumentInfoRecord LaboratoryOrDesignOffice
AuthorizationGroup I_DocumentInfoRecord AuthorizationGroup
DocumentDescriptionForEdit
ExternalDocumentStatusForEdit
ClassificationSideEffect
_ChangedUser I_DocumentInfoRecord _ChangedUser
_CreatedUser I_DocumentInfoRecord _CreatedUser
_UserDetails I_DocumentInfoRecord _UserDetails
_ChangedUserVH I_DocumentInfoRecord _ChangedUserVH
_CreatedUserVH I_DocumentInfoRecord _CreatedUserVH
_UserDetailsVH I_DocumentInfoRecord _UserDetailsVH
_DocNumber I_DocumentInfoRecord _DocNumber
_DocPart I_DocumentInfoRecord _DocPart
_DocType I_DocumentInfoRecord _DocType
_DocVersion I_DocumentInfoRecord _DocVersion
_DocStatus I_DocumentInfoRecord _DocStatus
_Indicator I_DocumentInfoRecord _Indicator
_AuthGroup I_DocumentInfoRecord _AuthGroup
_LabOffice I_DocumentInfoRecord _LabOffice
_LogAccMObjectTypeActive I_DocumentInfoRecord _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn I_DocumentInfoRecord _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt I_DocumentInfoRecord _LogAccMObjSecureIDAssgmt
_Desc _Desc
_ObjLink _ObjLink
@AbapCatalog.sqlViewName: 'ICVDOCINFORECTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_ChangedUser', '_CreatedUser', '_UserDetails' ]
@EndUserText.label: 'Document Info Record Transactional'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.draftEnabled: true
@ObjectModel.writeDraftPersistence: 'DRAW_DRAFT'
@ObjectModel.createEnabled: true //'EXTERNAL_CALCULATION'

@ObjectModel.updateEnabled: true //'EXTERNAL_CALCULATION'

@ObjectModel.deleteEnabled: true
@ObjectModel.entityChangeStateId: 'ChangedDateTime'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API


-- BOPF Related Annotations
@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.sapObjectNodeType.name: 'DocumentInfoRecord'   
define view I_DocumentInfoRecordTP
  as select from I_DocumentInfoRecord as Document

  association [0..*] to I_DocumentInfoRecordDescTP    as _Desc    on  $projection.DocumentInfoRecordDocType    = _Desc.DocumentInfoRecordDocType
                                                                  and $projection.DocumentInfoRecordDocNumber  = _Desc.DocumentInfoRecordDocNumber
                                                                  and $projection.DocumentInfoRecordDocVersion = _Desc.DocumentInfoRecordDocVersion
                                                                  and $projection.DocumentInfoRecordDocPart    = _Desc.DocumentInfoRecordDocPart

  association [0..*] to I_DocumentInfoRecordObjLinkTP as _ObjLink on  $projection.DocumentInfoRecordDocType    = _ObjLink.DocumentInfoRecordDocType
                                                                  and $projection.DocumentInfoRecordDocNumber  = _ObjLink.DocumentInfoRecordDocNumber
                                                                  and $projection.DocumentInfoRecordDocVersion = _ObjLink.DocumentInfoRecordDocVersion
                                                                  and $projection.DocumentInfoRecordDocPart    = _ObjLink.DocumentInfoRecordDocPart

-------Extension Association
--  association [1..1] to E_DocumentInfoRecord  as _ManageDocDataExtension  on  $projection.DocumentInfoRecordDocType     =  _ManageDocDataExtension.DocumentInfoRecordDocType
--                                                                           and $projection.DocumentInfoRecordDocNumber  =  _ManageDocDataExtension.DocumentInfoRecordDocNumber
--                                                                           and $projection.DocumentInfoRecordDocVersion =  _ManageDocDataExtension.DocumentInfoRecordDocVersion
--                                                                           and $projection.DocumentInfoRecordDocPart    =  _ManageDocDataExtension.DocumentInfoRecordDocPart
  
{
      /*  Document Info Record  key Details */
      @ObjectModel.mandatory:true     
  key Document.DocumentInfoRecordDocType                as  DocumentInfoRecordDocType,

  key Document.DocumentInfoRecordDocNumber              as  DocumentInfoRecordDocNumber,

  key Document.DocumentInfoRecordDocVersion             as  DocumentInfoRecordDocVersion,

  key Document.DocumentInfoRecordDocPart                as  DocumentInfoRecordDocPart,

      Document.DocumentInfoRecord                       as  DocumentInfoRecord,
      
      Document.DocInfoRecdIsMarkedForDeletion           as  DocInfoRecdIsMarkedForDeletion,
      Document.InternalDocumentStatus                   as  InternalDocumentStatus,
      Document.IsDocInfoRecdCreatedFromCAD              as  IsDocInfoRecdCreatedFromCAD,
      Document.IsDocInfoRecdStructure                   as  IsDocInfoRecdStructure,

      Document.DocInfoRecdSourceDocNumber               as  DocInfoRecdSourceDocNumber,
      Document.DocInfoRecdSourceDocVersion              as  DocInfoRecdSourceDocVersion,
      Document.DocInfoRecdSourceDocPart                 as  DocInfoRecdSourceDocPart,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       enabled:   'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
       }
      Document.ResponsiblePersonName                    as  ResponsiblePersonName,

      Document.CreatedByUser                            as  CreatedByUser,
      Document.CreationDateTime                         as  CreationDateTime,

      Document.LastChangedByUser                        as  LastChangedByUser,
      Document.ChangedDateTime                          as  ChangedDateTime,
 
      //@ObjectModel.mandatory:true 

      //@ObjectModel.enabled: true

      @ObjectModel: {
       readOnly:  'EXTERNAL_CALCULATION'
//       enabled:   'EXTERNAL_CALCULATION'

       }                            
      Document.DocumentInfoRecordDocType                as  DocInfoRecdDocTypeForEdit,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       readOnly:  'EXTERNAL_CALCULATION'
       }
      Document.DocumentInfoRecordDocNumber              as  DocInfoRecdDocNumberForEdit,
     
      Document.DocumentInfoRecordDocVersion             as  DocInfoRecdDocVersionForEdit,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       readOnly:  'EXTERNAL_CALCULATION'       
       }

      Document.DocumentInfoRecordDocPart                as  DocInfoRecdDocPartForEdit,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       enabled:   'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
       }
      Document.LaboratoryOrDesignOffice                 as  LaboratoryOrDesignOffice,
      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       enabled:   'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
       }
      Document.AuthorizationGroup                       as  AuthorizationGroup,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       enabled:   'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
       }
      cast( '' as dktxt )                               as  DocumentDescriptionForEdit,

      //@ObjectModel.updateEnabled: true

      @ObjectModel: {
       enabled:   'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
       }
      cast( '' as stabk )                               as  ExternalDocumentStatusForEdit,

      @UI.hidden: true
      cast(' ' as vchclf_side_effect_data)              as  ClassificationSideEffect,

      Document._ChangedUser,
      Document._CreatedUser,
      Document._UserDetails,
      Document._ChangedUserVH,
      Document._CreatedUserVH,
      Document._UserDetailsVH,
      Document._DocNumber,
      Document._DocPart,
      Document._DocType,
      Document._DocVersion,
      Document._DocStatus,
      Document._Indicator,
      Document._AuthGroup,
      Document._LabOffice,
      Document._LogAccMObjectTypeActive,
      Document._LogAccMObjectUserAuthzn,
      Document._LogAccMObjSecureIDAssgmt,
      
      @ObjectModel.association.type:  #TO_COMPOSITION_CHILD
      _Desc,

      @ObjectModel.association.type:  #TO_COMPOSITION_CHILD
      _ObjLink

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORD"
],
"ASSOCIATED":
[
"I_DOCINFORECORDACCMSECIDASGT",
"I_DOCUMENTINFORECORDACCMACTV",
"I_DOCUMENTINFORECORDAUTHZNGRP",
"I_DOCUMENTINFORECORDDESCTP",
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCPRT",
"I_DOCUMENTINFORECORDDOCSTATUS",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_DOCUMENTINFORECORDINDSTS",
"I_DOCUMENTINFORECORDLBTRYOFFC",
"I_DOCUMENTINFORECORDOBJLINKTP",
"I_DOCUMENTINFORECORDUAUTHACCM",
"I_DOCUMENTINFORECORDUSERVH",
"I_USER"
],
"BASE":
[
"I_DOCUMENTINFORECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/