I_ACMPurchaseOrder

DDL: I_ACMPURCHASEORDER SQL: IPURCHASEORDER Type: view COMPOSITE

Purchase Order

I_ACMPurchaseOrder is a Composite CDS View that provides data about "Purchase Order" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocument) and exposes 24 fields with key field PurchaseOrder. It has 2 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocument R_PurchasingDocument from

Associations (2)

CardinalityTargetAliasCondition
[*] I_ACMPurchaseOrderItem _ACMPurchaseOrdItm
[1] I_ACMPurOrdPlanningRelevance _ACMPurchaseOrderPlngRelevance

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPURCHASEORDER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
CompanyCode CompanyCode
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
CreationDate CreationDate
IncotermsClassification IncotermsClassification
IncotermsLocation1 IncotermsLocation1
PaymentTerms PaymentTerms
Counterparty Supplier
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
POCorrespncExternalReference CorrespncExternalReference
DocumentCurrency DocumentCurrency
_ACMPurchaseOrdItm _ACMPurchaseOrdItm
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_IncotermsClassification _IncotermsClassification
_PaymentTerms _PaymentTerms
_Supplier _Supplier
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingDocumentType _PurchasingDocumentType
_DocumentCurrency _DocumentCurrency
_ACMPurchaseOrderPlngRelevance _ACMPurchaseOrderPlngRelevance 
@AbapCatalog.sqlViewName: 'IPURCHASEORDER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
               usageType: {
                 dataClass: #TRANSACTIONAL,
                 serviceQuality: #A,
                 sizeCategory: #M
               }
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
define root view I_ACMPurchaseOrder
  as select from R_PurchasingDocument
  composition [*] of I_ACMPurchaseOrderItem as _ACMPurchaseOrdItm
  composition [1] of I_ACMPurOrdPlanningRelevance as _ACMPurchaseOrderPlngRelevance
{
  key  PurchasingDocument         as PurchaseOrder,
       CompanyCode,
       PurchasingOrganization,
       PurchasingGroup,
       CreationDate,
       IncotermsClassification,
       IncotermsLocation1,
       PaymentTerms,
       Supplier                   as Counterparty,
       PurchasingDocumentCategory,
       PurchasingDocumentType,
       CorrespncExternalReference as POCorrespncExternalReference,
       DocumentCurrency,

       /* Associations */
       _ACMPurchaseOrdItm,
       _CompanyCode,
       _PurchasingOrganization,
       _PurchasingGroup,
       _IncotermsClassification,
       _PaymentTerms,
       _Supplier,
       _PurchasingDocumentCategory,
       _PurchasingDocumentType,
       _DocumentCurrency,
       _ACMPurchaseOrderPlngRelevance

}

Learn More