P_DocumentInfoRecordCalcFields

DDL: P_DOCUMENTINFORECORDCALCFIELDS SQL: PDOCINFORECCALC Type: view CONSUMPTION

Document Info Record Calculation Field

P_DocumentInfoRecordCalcFields is a Consumption CDS View that provides data about "Document Info Record Calculation Field" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 28 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecord I_DocumentInfoRecord from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDOCINFORECCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Document Info Record Calculation Field view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart
AuthorizationGroup AuthorizationGroup
ChangeNumber ChangeNumber
ChangedDateTime ChangedDateTime
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
DocInfoRecdIsMarkedForDeletion DocInfoRecdIsMarkedForDeletion
DocInfoRecdSourceDocPart DocInfoRecdSourceDocPart
DocInfoRecdSourceDocVersion DocInfoRecdSourceDocVersion
InternalDocumentStatus InternalDocumentStatus
IsDocInfoRecdCreatedFromCAD IsDocInfoRecdCreatedFromCAD
IsDocInfoRecdStructure IsDocInfoRecdStructure
LastChangedByUser LastChangedByUser
ResponsiblePersonName ResponsiblePersonName
DocumentInfoRecord DocumentInfoRecord
_ChangedUser _ChangedUser
_CreatedUser _CreatedUser
_DocDesc _DocDesc
_DocNumber _DocNumber
_DocPart _DocPart
_DocStatus _DocStatus
_DocType _DocType
_DocVersion _DocVersion
_Indicator _Indicator
_UserDetails _UserDetails 
@AbapCatalog.sqlViewName: 'PDOCINFORECCALC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Document Info Record Calculation Field'
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_DocumentInfoRecordCalcFields
  as select from I_DocumentInfoRecord
{

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


      AuthorizationGroup             as  AuthorizationGroup,
      ChangeNumber                   as  ChangeNumber,
      ChangedDateTime                as  ChangedDateTime,
      CreatedByUser                  as  CreatedByUser,
      CreationDateTime               as  CreationDateTime,
      DocInfoRecdIsMarkedForDeletion as  DocInfoRecdIsMarkedForDeletion,

      // used for Deletion Criticality Code

      case when DocInfoRecdIsMarkedForDeletion = 'X'
      then 1
      else 0
      end                            as  Criticality,

      DocInfoRecdSourceDocPart       as  DocInfoRecdSourceDocPart,
      DocInfoRecdSourceDocVersion    as  DocInfoRecdSourceDocVersion,

      InternalDocumentStatus         as  InternalDocumentStatus,
      IsDocInfoRecdCreatedFromCAD    as  IsDocInfoRecdCreatedFromCAD,

      // used for Status Release Criticality code

      case when InternalDocumentStatus = 'FR'
      then 3
      else 0
      end                            as  CheckStatusCriticality,

      IsDocInfoRecdStructure         as  IsDocInfoRecdStructure,

      LastChangedByUser              as  LastChangedByUser,

      ResponsiblePersonName          as  ResponsiblePersonName,

      case when DocInfoRecdIsMarkedForDeletion = 'X'
      then cast( 'X' as xfeld)
      else cast( ' ' as xfeld)
      end                            as  DocInfoRecdIsDeleted,

      case when IsDocInfoRecdCreatedFromCAD = 'X'
      then cast( 'X' as xfeld)
      else cast( ' ' as xfeld)
      end                            as  DocumentIsCreatedByCAD,

      DocumentInfoRecord             as  DocumentInfoRecord,

      //concat(DocumentInfoRecordDocType,concat('',concat(DocumentInfoRecordDocNumber,concat('',concat(DocumentInfoRecordDocPart,concat('',DocumentInfoRecordDocVersion)))))) as  DocumentInfoRecord,

      _ChangedUser,
      _CreatedUser,
      _DocDesc,
      _DocNumber,
      _DocPart,
      _DocStatus,
      _DocType,
      _DocVersion,
      _Indicator,
      _UserDetails
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORD"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDDESC",
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCPRT",
"I_DOCUMENTINFORECORDDOCSTATUS",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_DOCUMENTINFORECORDINDSTS",
"I_USER"
],
"BASE":
[
"I_DOCUMENTINFORECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More