I_DocumentInfoRecordDocStatus

DDL: I_DOCUMENTINFORECORDDOCSTATUS SQL: ICVDOCSTATUS Type: view BASIC Package: VDM_DMS

Document Info Record Document Status

I_DocumentInfoRecordDocStatus is a Basic CDS View (Dimension) that provides data about "Document Info Record Document Status" in SAP S/4HANA. It reads from 1 data source (tdws) and exposes 6 fields with key fields DocumentInfoRecordDocType, InternalDocumentStatus. It has 3 associations to related views. Part of development package VDM_DMS.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
tdws status from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_DocumentInfoRecordDocTypeT _DocTypeText $projection.DocumentInfoRecordDocType = _DocTypeText.DocumentInfoRecordDocType
[0..1] I_DocumentInfoRecordDocType _DocType $projection.DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType
[0..*] I_DocumentInfoRecordDocStatusT _Text $projection.InternalDocumentStatus = _Text.InternalDocumentStatus

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCSTATUS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Document Info Record Document Status view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey InternalDocumentStatus view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType tdws dokar
KEY InternalDocumentStatus tdws dokst Internal Document Status
DocInfoRecdStatusType tdws dosar
_DocType _DocType
_Text _Text
_DocTypeText _DocTypeText 
@AbapCatalog.sqlViewName: 'ICVDOCSTATUS'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Document Info Record Document Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@ObjectModel.compositionRoot:true 
@ObjectModel.representativeKey: 'InternalDocumentStatus'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.numberOfKeyFields: #(001)
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@VDM.lifecycle.contract.type:#PUBLIC_LOCAL_API

//--[ GENERATED:011:GlBfhyFV7jY4gRmvB6oo}W

@AccessControl.privilegedAssociations: ['_DocTypeText']
// ]--GENERATED

@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION , #CDS_MODELING_ASSOCIATION_TARGET , #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
define view I_DocumentInfoRecordDocStatus
  as select from    tdws  as status     

  --Get Document Type Association
  
  //--[ GENERATED:011:GlBfhyFV7jY4gRmvB6oo}W

  association [0..*] to I_DocumentInfoRecordDocTypeT      as _DocTypeText on   $projection.DocumentInfoRecordDocType = _DocTypeText.DocumentInfoRecordDocType
  // ]--GENERATED

  association [0..1] to I_DocumentInfoRecordDocType as _DocType on $projection.DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType

  association [0..*] to I_DocumentInfoRecordDocStatusT  as _Text     on $projection.InternalDocumentStatus = _Text.InternalDocumentStatus

{
      //--[ GENERATED:011:GlBfhyFV7jY4gRmvB6oo}W

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_DocInfoRecdDocTypeStdVH',
                     element: 'DocumentInfoRecordDocType' }
        }]
      @ObjectModel.text.association: '_DocTypeText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_DocType'
  key status.dokar  as DocumentInfoRecordDocType,

      @EndUserText.label:'Internal Document Status'
      @ObjectModel.text.association: '_Text' 
  key status.dokst  as InternalDocumentStatus,
  
      status.dosar  as DocInfoRecdStatusType, //added by IH to retrieve status

      
      _DocType,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD] 
      _Text,
      //--[ GENERATED:011:GlBfhyFV7jY4gRmvB6oo}W

      @Consumption.hidden: true
      _DocTypeText
      // ]--GENERATED


      
}

Learn More