I_PurchaseOrderItemStatus

DDL: I_PURCHASEORDERITEMSTATUS SQL: IPURORDITMSTS Type: view COMPOSITE

Purchase Order Item Status

I_PurchaseOrderItemStatus is a Composite CDS View that provides data about "Purchase Order Item Status" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 3 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentStatus _PurchasingDocumentStatus $projection.PurchaseOrderItemStatus = _PurchasingDocumentStatus.PurchasingDocumentStatus

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IPURORDITMSTS view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Item Status view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey PurchaseOrderItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
_PurchasingDocumentStatus _PurchasingDocumentStatus 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IPURORDITMSTS'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Order Item Status'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  semanticKey: [ 'PurchaseOrder', 'PurchaseOrderItem' ],
  representativeKey: 'PurchaseOrderItem'
}

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurchaseOrderItemStatus as select from I_PurchaseOrderItem 

association [0..1] to I_PurchasingDocumentStatus as _PurchasingDocumentStatus on  $projection.PurchaseOrderItemStatus   = _PurchasingDocumentStatus.PurchasingDocumentStatus
{
    key PurchaseOrder,
    key PurchaseOrderItem,

    cast (
      case
        when PurchasingDocumentDeletionCode = 'S' then cast ('13' as abap.char(2))
        when PurchasingDocumentDeletionCode != '' then cast ('39' as abap.char(2))
      end
    as vdm_purchaseorderitemstatus preserving type ) as PurchaseOrderItemStatus,
      
    _PurchasingDocumentStatus
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More