Which tables does A_DocumentInfoRecord use?

A_DocumentInfoRecord reads from 1 data source(s): I_DocInfoRecordTP.

A_DocumentInfoRecord

Q: How many fields does A_DocumentInfoRecord have?

A_DocumentInfoRecord has 26 fields. Key fields: DocumentInfoRecordDocType, DocumentInfoRecordDocVersion, DocumentInfoRecordDocNumber, DocumentInfoRecordDocPart.

DDL: A_DOCUMENTINFORECORD SQL: ADIRHDR Type: view_entity COMPOSITE

Document Info Record

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

Data Sources (1)

Source	Alias	Join Type
I_DocInfoRecordTP	docInfoRecord	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	A_DocumentInfoRecordClass	_Classification	`$projection.DocumentInfoRecordDocType = _Classification.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Classification.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocPart = _Classification.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocVersion = _Classification.DocumentInfoRecordDocVersion`
[0..*]	A_DocumentInfoRecordCharc	_Characteristics	`$projection.DocumentInfoRecordDocType = _Characteristics.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Characteristics.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocPart = _Characteristics.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocVersion = _Characteristics.DocumentInfoRecordDocVersion`
[0..*]	A_DocumentInfoRecordDocStsVH	_DocStatusVH	`$projection.DocumentInfoRecordDocType = _DocStatusVH.DocumentInfoRecordDocType and $projection.InternalDocumentStatus = _DocStatusVH.InternalDocumentStatus`
[0..*]	A_DocumentInfoRecordDesc	_DocDesc
[0..*]	A_DocInfoRecdObjLinkProduct	_ProductObj
[0..*]	A_DocInfoRecdObjLinkBOM	_BomObj
[0..*]	A_DocInfoRecdObjLinkChgRecd	_ChgRecdObj

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Document Info Record	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (26)

Key	Field	Source Table	Source Field
KEY	DocumentInfoRecordDocType		DocumentInfoRecordDocType
KEY	DocumentInfoRecordDocVersion		DocumentInfoRecordDocVersion
KEY	DocumentInfoRecordDocNumber		DocumentInfoRecordDocNumber
KEY	DocumentInfoRecordDocPart		DocumentInfoRecordDocPart
	DocumentInfoRecord	I_DocInfoRecordTP	DocumentInfoRecord
	InternalDocumentStatus		InternalDocumentStatus
	LaboratoryOrDesignOffice		LaboratoryOrDesignOffice
	AuthorizationGroup		AuthorizationGroup
	ChangeNumber		ChangeNumber
	DocInfoRecdIsMarkedForDeletion		DocInfoRecdIsMarkedForDeletion
	IsDocInfoRecdCreatedFromCAD		IsDocInfoRecdCreatedFromCAD
	IsDocInfoRecdStructure		IsDocInfoRecdStructure
	ResponsiblePersonName		ResponsiblePersonName
	CreationDateTime		CreationDateTime
	CreatedByUser		CreatedByUser
	ChangedDateTime		ChangedDateTime
	LastChangedByUser		LastChangedByUser
	ExternalDocumentStatus	_DocStatusVH	ExternalDocumentStatus
	DocumentStatusName	_DocStatusVH	DocumentStatusName
	_DocDesc		_DocDesc
	_DocStatusVH		_DocStatusVH
	_ProductObj		_ProductObj
	_BomObj		_BomObj
	_ChgRecdObj		_ChgRecdObj
	_Classification		_Classification
	_Characteristics		_Characteristics

//@AbapCatalog.sqlViewName: 'ADIRHDR'

//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Document Info Record'
@VDM.viewType : #COMPOSITE
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL 

/*
@ObjectModel.compositionRoot:true
@ObjectModel.createEnabled:true 
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@ObjectModel.foreignKey.association: '_DocDesc'
@ObjectModel.entityChangeStateId: 'ChangedDateTime'
@ObjectModel.transactionalProcessingDelegated: true
*/ 
//@AbapCatalog.preserveKey: true

define root view entity A_DocumentInfoRecord
  as select from I_DocInfoRecordTP as docInfoRecord
  composition [0..*] of A_DocumentInfoRecordDesc     as _DocDesc         //on  $projection.DocumentInfoRecordDocType    = _DocDesc.DocumentInfoRecordDocType

                                                                         //and $projection.DocumentInfoRecordDocNumber  = _DocDesc.DocumentInfoRecordDocNumber

                                                                         //and $projection.DocumentInfoRecordDocPart    = _DocDesc.DocumentInfoRecordDocPart

                                                                         //and $projection.DocumentInfoRecordDocVersion = _DocDesc.DocumentInfoRecordDocVersion


  composition [0..*] of A_DocInfoRecdObjLinkProduct  as _ProductObj      //on  $projection.DocumentInfoRecordDocType    = _ProductObj.DocumentInfoRecordDocType

                                                                         //and $projection.DocumentInfoRecordDocNumber  = _ProductObj.DocumentInfoRecordDocNumber

                                                                         //and $projection.DocumentInfoRecordDocPart    = _ProductObj.DocumentInfoRecordDocPart

                                                                         //and $projection.DocumentInfoRecordDocVersion = _ProductObj.DocumentInfoRecordDocVersion

 
  composition [0..*] of A_DocInfoRecdObjLinkBOM      as _BomObj          //on  $projection.DocumentInfoRecordDocType    = _BomObj.DocumentInfoRecordDocType

                                                                         //and $projection.DocumentInfoRecordDocNumber  = _BomObj.DocumentInfoRecordDocNumber

                                                                         //and $projection.DocumentInfoRecordDocPart    = _BomObj.DocumentInfoRecordDocPart

                                                                         //and $projection.DocumentInfoRecordDocVersion = _BomObj.DocumentInfoRecordDocVersion


  composition [0..*] of A_DocInfoRecdObjLinkChgRecd  as _ChgRecdObj      //on  $projection.DocumentInfoRecordDocType    = _ChgRecdObj.DocumentInfoRecordDocType

                                                                         //and $projection.DocumentInfoRecordDocNumber  = _ChgRecdObj.DocumentInfoRecordDocNumber

                                                                         //and $projection.DocumentInfoRecordDocPart    = _ChgRecdObj.DocumentInfoRecordDocPart

                                                                         //and $projection.DocumentInfoRecordDocVersion = _ChgRecdObj.DocumentInfoRecordDocVersion


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

  association [0..*] to A_DocumentInfoRecordCharc    as _Characteristics on  $projection.DocumentInfoRecordDocType    = _Characteristics.DocumentInfoRecordDocType
                                                                         and $projection.DocumentInfoRecordDocNumber  = _Characteristics.DocumentInfoRecordDocNumber
                                                                         and $projection.DocumentInfoRecordDocPart    = _Characteristics.DocumentInfoRecordDocPart
                                                                         and $projection.DocumentInfoRecordDocVersion = _Characteristics.DocumentInfoRecordDocVersion
  
  association [0..*] to A_DocumentInfoRecordDocStsVH as _DocStatusVH     on  $projection.DocumentInfoRecordDocType = _DocStatusVH.DocumentInfoRecordDocType
                                                                         and $projection.InternalDocumentStatus    = _DocStatusVH.InternalDocumentStatus


{
// @ObjectModel.sapObjectNodeTypeReference: 'DocumentInfoRecordDocType'

  key DocumentInfoRecordDocType        as DocumentInfoRecordDocType,
  key DocumentInfoRecordDocVersion     as DocumentInfoRecordDocVersion,
  key DocumentInfoRecordDocNumber      as DocumentInfoRecordDocNumber,
  key DocumentInfoRecordDocPart        as DocumentInfoRecordDocPart,

      docInfoRecord.DocumentInfoRecord as DocumentInfoRecord,

      /*  Document Info Record other Details */
      InternalDocumentStatus           as InternalDocumentStatus,
      LaboratoryOrDesignOffice         as LaboratoryOrDesignOffice,
      AuthorizationGroup               as AuthorizationGroup,
      ChangeNumber                     as ChangeNumber,

      /*  Document Structure, CAD and Deletion Indicator */
      DocInfoRecdIsMarkedForDeletion   as DocInfoRecdIsMarkedForDeletion,
      IsDocInfoRecdCreatedFromCAD      as IsDocInfoRecdCreatedFromCAD,
      IsDocInfoRecdStructure           as IsDocInfoRecdStructure,

      ResponsiblePersonName            as ResponsiblePersonName,

      /* DIR Administrative Data */
      CreationDateTime                 as CreationDateTime,
      CreatedByUser                    as CreatedByUser,
     // @ObjectModel.readOnly: true

      ChangedDateTime                  as ChangedDateTime,
      LastChangedByUser                as LastChangedByUser,
      
      /* Document Info Record Status */
      _DocStatusVH.ExternalDocumentStatus as ExternalDocumentStatus,
      _DocStatusVH.DocumentStatusName     as DocumentStatusName,

//      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      _DocDesc,
//      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      _DocStatusVH,
//      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      _ProductObj,
     // @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      _BomObj,
     // @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      _ChgRecdObj,
    
      _Classification,
     
      _Characteristics
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_DOCUMENTINFORECORDDOCSTSVH",
"I_DOCINFORECORDTP"
],
"ASSOCIATED":
[
"A_DOCINFORECDOBJLINKBOM",
"A_DOCINFORECDOBJLINKCHGRECD",
"A_DOCINFORECDOBJLINKPRODUCT",
"A_DOCUMENTINFORECORDCHARC",
"A_DOCUMENTINFORECORDCLASS",
"A_DOCUMENTINFORECORDDESC",
"A_DOCUMENTINFORECORDDOCSTSVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

A_DocumentInfoRecord view_entity

I_DocInfoRecordTP view