P_PurOrderConvertedValues

DDL: P_PURORDERCONVERTEDVALUES SQL: PMMPOCNVRTDVAL Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Purchase Order Converted Values

P_PurOrderConvertedValues is a Consumption CDS View that provides data about "Purchase Order Converted Values" in SAP S/4HANA. It reads from 1 data source (I_PurOrdScheduleLineEnhanced) and exposes 60 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ProcurementHubSourceSystem. Part of development package ODATA_MM_ANALYTICS.

1 data source(s) 60 fields

Data Sources (1)

SourceAliasJoin Type
I_PurOrdScheduleLineEnhanced I_PurOrdScheduleLineEnhanced from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPOCNVRTDVAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine ScheduleLine
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem
ScheduleLineUniqueID ScheduleLineUniqueID
CreatedByUser CreatedByUser
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
CompanyCode CompanyCode
PurgDocHdrCompanyCode PurgDocHdrCompanyCode
Supplier Supplier
Plant Plant
Material Material
MaterialGroup MaterialGroup
PurchaseOrderItemText PurchaseOrderItemText
ServicePerformer ServicePerformer
AnlytlCrcyExchangeRateStatus AnlytlCrcyExchangeRateStatus
NetPriceInReportingCurrency NetPriceInReportingCurrency
NetPriceInReportingCurrency2 NetPriceInReportingCurrency2
NetPriceAmount
AnalyticalReportingCurrency AnalyticalReportingCurrency
AnalyticalReportingCurrency2 AnalyticalReportingCurrency2
DocumentCurrency DocumentCurrency
NetAmountInReportingCurrency NetAmountInReportingCurrency
NetAmountInReportingCurrency2 NetAmountInReportingCurrency2
NetAmount
OpenAmountInReportingCurrency OpenAmountInReportingCurrency
OpenAmountInReportingCurrency2 OpenAmountInReportingCurrency2
OpenAmountInDocumentCurrency OpenAmountInDocumentCurrency
OrderQuantityUnit OrderQuantityUnit
ScheduleLineOpenQuantity ScheduleLineOpenQuantity
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
PrevDelivQtyOfScheduleLine PrevDelivQtyOfScheduleLine
GoodsReceiptQuantity GoodsReceiptQuantity
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
OrderQuantity OrderQuantity
IsReturnsItem IsReturnsItem
IsCompletelyDelivered IsCompletelyDelivered
GoodsReceiptIsExpected GoodsReceiptIsExpected
PurgDocumentItemDeletionCode PurgDocumentItemDeletionCode
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
PurchasingCompletenessStatus PurchasingCompletenessStatus
PurgDocSchdLnHasNextDelivery PurgDocSchdLnHasNextDelivery
ProductType ProductTypeCode
ReleaseIsNotCompleted ReleaseIsNotCompleted
PurchaseOrderCategory PurchaseOrderCategory
PurchaseOrderType PurchaseOrderType
PurchaseOrderItemCategory PurchaseOrderItemCategory
PurchasingProcessingStatus PurchasingProcessingStatus
AccountAssignmentCategory AccountAssignmentCategory
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
PurOrdItmAnlytsIndIsActv PurOrdItmAnlytsIndIsActv
PurchasingDocumentIsAged PurchasingDocumentIsAged
CreationDate CreationDate
PurchaseOrderDate PurchaseOrderDate
LastChangeDateTime LastChangeDateTime
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate 
@AbapCatalog.sqlViewName: 'PMMPOCNVRTDVAL'
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

define view P_PurOrderConvertedValues
  
  as select from I_PurOrdScheduleLineEnhanced

{
  key PurchaseOrder,
  key PurchaseOrderItem,
  key ScheduleLine,
  key ProcurementHubSourceSystem,

      ScheduleLineUniqueID,

      CreatedByUser,

      PurchasingOrganization,
      PurchasingGroup,
      CompanyCode,
      PurgDocHdrCompanyCode,
      Supplier,
      Plant,
      Material,
      MaterialGroup,
      PurchaseOrderItemText,
      ServicePerformer,

      AnlytlCrcyExchangeRateStatus,

      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetPriceInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetPriceInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast( NetPriceAmount as abap.curr(21,5)) as NetPriceAmount,

      @Semantics.currencyCode: true
      AnalyticalReportingCurrency,
      @Semantics.currencyCode: true
      AnalyticalReportingCurrency2,
      @Semantics.currencyCode: true
      DocumentCurrency,

      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      NetAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      NetAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast(NetAmount as abap.curr(21,5))       as NetAmount,

      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency'
      OpenAmountInReportingCurrency,
      @Semantics.amount.currencyCode: 'AnalyticalReportingCurrency2'
      OpenAmountInReportingCurrency2,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      OpenAmountInDocumentCurrency,

      //Quanitity


      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOpenQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOrderQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PrevDelivQtyOfScheduleLine,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      GoodsReceiptQuantity,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineIssuedQuantity,

      @Semantics.unitOfMeasure: true
      PurchaseOrderQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      OrderQuantity,

      IsReturnsItem,
      IsCompletelyDelivered,
      GoodsReceiptIsExpected,
      PurgDocumentItemDeletionCode,
      PurchasingDocumentDeletionCode,
      PurchasingCompletenessStatus,
      PurgDocSchdLnHasNextDelivery,
      ProductTypeCode                          as ProductType,
      ReleaseIsNotCompleted,
      PurchaseOrderCategory,
      PurchaseOrderType,
      PurchaseOrderItemCategory,
      //PurchasingDocumentStatus,

      PurchasingProcessingStatus,
      AccountAssignmentCategory,
      MultipleAcctAssgmtDistribution,
      PurOrdItmAnlytsIndIsActv,
      PurchasingDocumentIsAged,

      //Date


      CreationDate,
      PurchaseOrderDate,
      LastChangeDateTime,
      ScheduleLineDeliveryTime,
      ScheduleLineDeliveryDate,
      SchedLineStscDeliveryDate


}

Learn More