C_PurchasingDocStatus

DDL: C_PURCHASINGDOCSTATUS SQL: CPURDOCSTATUS Type: view CONSUMPTION

C_PurchasingDocStatus is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderStatus) and exposes 6 fields with key field PurchaseOrder. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderStatus I_PurchaseOrderStatus from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocumentStatusText _PurcahseOrderStatusText _PurcahseOrderStatusText.Language = $session.system_language and _PurcahseOrderStatusText.PurchasingDocumentStatus = $projection.PurchasingDocumentStatus

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CPURDOCSTATUS view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
PurchasingDocumentStatus PurchasingDocumentStatus
PurchasingDocumentStatusName _PurcahseOrderStatusText PurchasingDocumentStatusName
PurchaseOrderType PurchaseOrderType
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup 
@AbapCatalog.sqlViewName: 'CPURDOCSTATUS'
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type : #NONE
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL


define view C_PurchasingDocStatus
  as select from I_PurchaseOrderStatus
  
  association [1..1] to I_PurchasingDocumentStatusText as _PurcahseOrderStatusText     on  _PurcahseOrderStatusText.Language                 = $session.system_language
                                                                                       and _PurcahseOrderStatusText.PurchasingDocumentStatus = $projection.PurchasingDocumentStatus
  
//  as select from C_PurdocListItemStatus as PurDocItemStatus

//  association [1..1] to I_PurchasingDocumentStatus as _PDStatus on _PDStatus.PurchasingDocumentStatus = PurDocItemStatus.PurchasingDocumentStatus


{
  key PurchaseOrder,
      PurchasingDocumentStatus,
      _PurcahseOrderStatusText.PurchasingDocumentStatusName,
      
//      _PDStatus._Text[1: Language = $session.system_language].PurchasingDocumentStatusName,

     
      @UI.hidden: true   
      PurchaseOrderType,
      @UI.hidden: true
      PurchasingOrganization,
      @UI.hidden: true
      PurchasingGroup
//      @UI.hidden: true

//      Plant

      
      
}

Learn More