P_PurchaseOrderStatus

DDL: P_PURCHASEORDERSTATUS SQL: PPOORDSTAT Type: view CONSUMPTION

Status logic for PO

P_PurchaseOrderStatus is a Consumption CDS View that provides data about "Status logic for PO" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderStatus) and exposes 6 fields with key fields PurchaseOrder, PurchaseOrderItem. 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
[0..*] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPOORDSTAT view
EndUserText.label Status logic for PO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_purgdocconf view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem _PurchaseOrderItem PurchaseOrderItem
SupplierConfirmationControlKey _PurchaseOrderItem SupplierConfirmationControlKey
PurchaseOrderType PurchaseOrderType
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup 
@AbapCatalog.sqlViewName: 'PPOORDSTAT'
@EndUserText.label: 'Status logic for PO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'P_purgdocconf' //PurchasingDocumentStatus calculation is now done in P_purgdocconf


define view P_PurchaseOrderStatus as select  from I_PurchaseOrderStatus
  association [0..*] to I_PurchaseOrderItem       as _PurchaseOrderItem       on  $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder

 {
    //I_PurchaseOrderStatus 

    key PurchaseOrder,
    
   key _PurchaseOrderItem.PurchaseOrderItem,
   
   _PurchaseOrderItem.SupplierConfirmationControlKey,
    
    
    cast (
      case
       when _PurchaseOrderItem.PurchasingDocumentDeletionCode != '' then cast ('39' as abap.char(2))
     else PurchasingDocumentStatus
      end
    as vdm_purchaseorderitemstatus preserving type ) as PurchasingDocumentStatus,
    
//    PurchasingDocumentStatus, 

    PurchaseOrderType, 
    PurchasingOrganization, 
    PurchasingGroup
}

Learn More