C_ChgImpactPurOrdItem

DDL: C_CHGIMPACTPURORDITEM SQL: CCHGIMPPUOITEM Type: view CONSUMPTION

Purchase Order Item Details

C_ChgImpactPurOrdItem is a Consumption CDS View that provides data about "Purchase Order Item Details" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem, ConditionSequentialNumberShort. It has 5 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem puoitem from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_SupDmndPurOrderSchedLine _Delivery $projection.PurchaseOrder = _Delivery.PurchasingDocument and $projection.PurchaseOrderItem = _Delivery.PurchasingDocumentItem
[1..1] I_PurchasingObjectCategoryText _PurchaseCategory_Text $projection.PurchaseOrderCategory = _PurchaseCategory_Text.PurchasingDocumentCategory and _PurchaseCategory_Text.Language = $session.system_language
[1..1] I_MaterialText _MatDesc $projection.Material = _MatDesc.Material and _MatDesc.Language = $session.system_language
[1..*] I_ChgImpactPurDocAcctAssign _PuoAcct $projection.PurchaseOrder = _PuoAcct.PurchasingDocument and $projection.PurchaseOrderItem = _PuoAcct.PurchasingDocumentItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPPUOITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Purchase Order Item Details view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem
KEY ConditionSequentialNumberShort _PuoAcct ConditionSequentialNumberShort
PurchaseOrderCategory I_PurchaseOrderItem PurchaseOrderCategory
Material I_PurchaseOrderItem Material
MaterialName _MatDesc MaterialName
OrderQuantity I_PurchaseOrderItem OrderQuantity
ScheduleLineDeliveryDate _Delivery ScheduleLineDeliveryDate
PurchasingDocumentCategoryName _PurchaseCategory_Text PurchasingDocumentCategoryName
SalesDocument _PuoAcct SalesDocument
SalesDocumentItem _PuoAcct SalesDocumentItem
ScheduleLine _PuoAcct ScheduleLine
ManufacturingOrder _PuoAcct ProductionOrder
WBSElement _PuoAcct WBSElement
WBSElementInternalID _PuoAcct WBSElementInternalID
PurchaseOrderType _PurchaseOrder PurchaseOrderType
NetChangeAnalysisPath
ProductionOrder
IsDefinite
IsChanged 
@AbapCatalog.sqlViewName: 'CCHGIMPPUOITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Purchase Order Item Details'
@VDM.viewType: #CONSUMPTION
@UI.presentationVariant: [{ requestAtLeast: ['WBSElement','SalesDocument','ManufacturingOrder','WBSElement','WBSElementInternalID' ] }]
define view C_ChgImpactPurOrdItem
  as select from I_PurchaseOrderItem as puoitem
  association [1..1] to I_PurchaseOrder                as _PurchaseOrder         on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [1..1] to I_SupDmndPurOrderSchedLine     as _Delivery              on  $projection.PurchaseOrder     = _Delivery.PurchasingDocument
                                                                                 and $projection.PurchaseOrderItem = _Delivery.PurchasingDocumentItem
  association [1..1] to I_PurchasingObjectCategoryText as _PurchaseCategory_Text on  $projection.PurchaseOrderCategory = _PurchaseCategory_Text.PurchasingDocumentCategory and
                                                                                      _PurchaseCategory_Text.Language = $session.system_language
  association [1..1] to I_MaterialText                 as _MatDesc               on  $projection.Material = _MatDesc.Material and
                                                                                      _MatDesc.Language = $session.system_language
  association [1..*] to I_ChgImpactPurDocAcctAssign    as _PuoAcct               on  $projection.PurchaseOrder     = _PuoAcct.PurchasingDocument
                                                                                 and $projection.PurchaseOrderItem = _PuoAcct.PurchasingDocumentItem
{

         @UI.hidden:true
  key    puoitem.PurchaseOrder,
         @UI.lineItem: [{position: 10,importance: #HIGH}]
  key    puoitem.PurchaseOrderItem,
         @UI.hidden: true
  key    _PuoAcct.ConditionSequentialNumberShort,

         @UI.lineItem: [{position: 20,importance: #HIGH}]
         @ObjectModel.text: {
         element: 'PurchasingDocumentCategoryName'
         }
         puoitem.PurchaseOrderCategory,
         @UI.lineItem: [{position: 30,importance: #HIGH}]
         @ObjectModel.text: {
            element: 'MaterialName'
         }
         puoitem.Material,
         @UI.hidden: true
         _MatDesc.MaterialName                                                                                                                       as MaterialName,
         @UI.lineItem: [{position: 40,importance: #HIGH}]
         puoitem.OrderQuantity,
         @UI.lineItem: [{position: 50,importance: #HIGH}]
         _Delivery.ScheduleLineDeliveryDate,
         //         @UI.lineItem: [{position: 60,importance: #HIGH}]

         @UI.hidden: true
         _PurchaseCategory_Text.PurchasingDocumentCategoryName,
         @ObjectModel.text: {
            element: ['SalesDocumentItem','ScheduleLine']
         }
         _PuoAcct.SalesDocument,
         @UI.hidden: true
         _PuoAcct.SalesDocumentItem,
         @UI.hidden: true
         _PuoAcct.ScheduleLine,
         _PuoAcct.ProductionOrder                                                                                                                    as ManufacturingOrder,
         _PuoAcct.WBSElement,
         @UI.hidden: true
         _PuoAcct.WBSElementInternalID,
         @UI.hidden: true
         _PurchaseOrder.PurchaseOrderType,
         @UI.hidden: true
         @ObjectModel: {
         filter: {
            transformedBy: 'ABAP:CL_MPE_CIMA_SADL_FILTER_CONV'
         }
         }
         cast( ' ' as abap.char( 255 ) )                                                                                                             as NetChangeAnalysisPath,
         @UI.hidden: true
         @ObjectModel: {
         filter: {
            transformedBy: 'ABAP:CL_MPE_CIMA_SADL_FILTER_CONV'
         }
         }
         cast( ' ' as abap.char( 255 ) )                                                                                                             as ProductionOrder,
         @UI.hidden: true
         @ObjectModel: {
             filter: {
                 transformedBy: 'ABAP:CL_MPE_CIMA_SADL_FILTER_CONV'
             }
         }
         cast(' '  as mpe_mec_cima_isdefinite)                                                                                                       as IsDefinite,
         @UI.hidden: true
         @ObjectModel: {
         filter: {
            transformedBy: 'ABAP:CL_MPE_CIMA_SADL_FILTER_CONV'
         }
         }
         cast(' ' as mpe_mec_cima_ischanged )                                                                                                        as IsChanged
}

Learn More