I_PURCHASEORDER

CDS View

Purchase Order

I_PURCHASEORDER is a CDS View in S/4HANA. Purchase Order. It contains 60 fields. 104 CDS views read from this table.

Used by 104 CDS view(s) 60 fields

CDS Views using this table (104)

ViewTypeJoinVDMDescription
C_APProcessFlowPurchaseOrder view from CONSUMPTION AP Process Flow Purchase Order
C_APProcessFlowPurOrdItemVH view from CONSUMPTION AP Process Flow Purchase Order Item VH
C_ChgImpactPurOrdDets view from CONSUMPTION Purchase Order Details
C_POItemChangeCount view left_outer CONSUMPTION Purchase Order Item Changes
C_POItemCountForSuplrCube view inner CONSUMPTION PO and Item Count for Total Supplier - Cube
C_PurchaseOrderFeature view from CONSUMPTION Feature of Purchase Order
C_PurchaseOrderFeatureDetail view from CONSUMPTION Feature Detail of Purchase Order
C_PurchaseOrderMassUpdate view from CONSUMPTION Mass Changes to Purchase Orders
C_PurchaseOrderSolution view from CONSUMPTION Purchase Order Solution
C_PurchaseOrderValueHelp view from CONSUMPTION Purchase Order Value Help
C_PurchaserValueHelp view inner CONSUMPTION Purchaser Value Help
C_PurDocListInvoiceDetails view left_outer CONSUMPTION
C_PurDocListPOAll view left_outer CONSUMPTION Purchase Order : Header + Item
C_Purdoclistpoitemstatus view left_outer CONSUMPTION PO Item Status
C_PurgDataForTimeSheet view left_outer CONSUMPTION Purchasing Data for Time Sheet
C_PurOrdItmSts view left_outer CONSUMPTION Purchase Order Item Status
C_PurOrdRefDocPO view left_outer CONSUMPTION Reference Documents for PO Creation - Purchase Order Items
C_PurReturnDelItem view inner CONSUMPTION MM SSP Return Delivery Items
C_RFQProcessFlow view inner CONSUMPTION RFQ Process Flow
C_ServiceEntrySheetProcessFlow view inner CONSUMPTION Process Flow For Service Entry Sheet
C_SSPPurchaseOrderStsForBPF view from CONSUMPTION PO Status in SSP Requisition Application
I_APProcessFlowDocumentVH view from COMPOSITE Document Number
I_ChgRecdRefPurOrdTP view left_outer TRANSACTIONAL Change Record Reference Object Pur Ord
I_FldLogsRetServicePurOrdVH view inner COMPOSITE Service PO F4 Help for FL Returns
I_MMTimeRecording view inner BASIC Time Sheet (CATS): Transfer to MM
I_PPS_PurchaseOrderStatus view from COMPOSITE PPS Status of a purchase order
I_PurchaseOrderCalcFields view from COMPOSITE Collection of calculated fields on PO header level
I_PurchaseOrderEMailParameter view from COMPOSITE Parameters for Purchase Order Email Template
I_PurchaseOrderPartner view inner BASIC Purchase Order Partner
I_PurchaseOrderPricingElement view inner BASIC Purchase Order Pricing Element on Header
I_PurchaseOrderStatus view from COMPOSITE Status of a purchase order
I_PurchaseOrderStdVH view from COMPOSITE Purchase Order
I_PurchaseOrderSupplierAddress view from COMPOSITE Supplier Address in Purchase Order
I_PurOrdItemPricingElement view inner BASIC Purchase Order Pricing Element on Item
I_PurOrdPricingElement view inner COMPOSITE Purchase Order Pricing Element
I_PurOrdScheduleLineBasic view inner BASIC Purchasing Document Schedule Line Basic
I_RFM_MngPOHdr view from COMPOSITE Composite View for Hdr details Manage PO
I_StockTransportOrder view from BASIC Stock Transport Order
I_VMSVehicleStdPurchaseOrder view from BASIC Purchase Order details
M_V_Purchord_Output_Params view from Paramters for Purchase Order Output Determination
N_ChangeRecordObjPgPurOrd view left_outer Change Record Reference Object Page Pur Ord
P_DeliveryCostBasedOnPOItm view inner CONSUMPTION
P_InspLotPurgOrdDocs view inner CONSUMPTION Inspectionlot for purchase orders
P_InvoicesCreatedBeforePO view from CONSUMPTION
P_PDOCITEMWITHOUTACCTASSGMT view union_all CONSUMPTION
P_POCastedAmounts view from CONSUMPTION Casted Amounts for Purchase Order
P_PODOWNPAYTSTSCALCFINAL view from CONSUMPTION Private View for Status Calculation
P_PODwnPaytAmountCalc view from CONSUMPTION Down Payment Calc Fields for PO
P_PODwnPaytDuDteIntvlCalc1 view from CONSUMPTION Due Date Interval Calc1
P_PODwnPaytDueDateInterval view from CONSUMPTION Due Date Interval for PO Dwn Pymt
P_POHistInDateRange view inner CONSUMPTION PO History in date range
P_POHistoryForGR view inner CONSUMPTION
P_POHistoryForInvoice view inner CONSUMPTION
P_POIDeliveryCostGR view inner CONSUMPTION
P_POIDeliveryCostInvoice view inner CONSUMPTION
P_POItemChangeDocHeader view from CONSUMPTION POI Change Document Header
P_POItemInvoicePrice view from CONSUMPTION PO Item for Invoice Price
P_PRToFirstPurchasOrder view inner CONSUMPTION First Purchas Order created to a PR
P_PRToFirstPurchasOrder1 view inner CONSUMPTION First Purchase Order created to a PR
P_PurcContractLeakagePC1 view inner CONSUMPTION P_PurcContractLeakagePC1
P_PurchaseContractLeakage view inner CONSUMPTION
P_PurchaseContractleakage1 view inner CONSUMPTION Purchase Contract Leakage 1
P_Purchasecontractleakage3 view inner CONSUMPTION
P_PurchaseOrderCommitment view inner COMPOSITE
P_PurchaseOrderHistory_Basic view inner BASIC
P_PURCHASEORDERITEMCHANGEDOC view from CONSUMPTION
P_PurchaseOrderItemPAI view inner CONSUMPTION
P_PurchaseOrderItemPAI_04 view left_outer CONSUMPTION
P_PurchaseOrderMassUpdate view from CONSUMPTION Mass Update of Purchase Orders
P_PurchaseOrderMigration view inner CONSUMPTION Purchase Order for Migration Report
P_PurchaseOrderPriceVariance view inner CONSUMPTION
P_PurchaseOrderQuantity view from CONSUMPTION Purchase Order Quantity
P_PurchaseOrderQuantity view union_all CONSUMPTION Purchase Order Quantity
P_PURCHASEORDERSENDTOSUPPLR view from CONSUMPTION Purchase order send to supplier
P_PurchaseOrderSupplierAddress view from COMPOSITE
P_PurchasingGroupAnalysis2 view inner CONSUMPTION Purchasing Group Analysis 2
P_PurchasingSpndComparison1 view inner CONSUMPTION Purchasing Spend Comparison 1
P_PurchOrderFiltered view from CONSUMPTION Purchase Order filtered by date
P_PurDocStat view left_outer CONSUMPTION
P_PurFutureSpend view inner CONSUMPTION Purchasing Future Spend
P_PurOrdDownPaymentMntr view union CONSUMPTION Monitor Purchase Order Down Payments
P_PurOrdItemAcctAssgmt view inner CONSUMPTION Purchase Order Item Account Assignment
P_PurOrdItmAcctAssgmt1 view inner CONSUMPTION
P_PURORDITMACCTASSGMT2 view union_all CONSUMPTION
P_PurOrdItmServiceSpnd view inner CONSUMPTION Purchase Order Item - Service Spend
P_PurOrdMaintainHdrActCalFsHlp view from CONSUMPTION
P_PurOrdMaintainHeaderActAddr view from CONSUMPTION
P_PurOrdMaintainHeaderActive view from CONSUMPTION
P_PurOrdMaintainHeadersList view from CONSUMPTION
P_PurOrdMaintainHeaderStatus view from CONSUMPTION
P_PurOrdOutputAutomation1 view from CONSUMPTION PO Output Automation CreationDate
P_PurOrdSchedAcct1 view inner CONSUMPTION Scheduled Purchase Orders
P_PurOrdServiceInvoice1 view inner CONSUMPTION Purchase Order Service Invoice
P_PurOrdsForConfirmation view from COMPOSITE
P_QltyNotifPurgDocs1 view inner CONSUMPTION Supplier Eval by Quality Notification
P_ReqnToOrderCycleTime1 view inner CONSUMPTION
P_SlsOrdProcFlowM12 view inner CONSUMPTION Sales Order Process Flow: Level -1 IC Purchase Order
P_SuplrEvalByQltyNotif2 view inner CONSUMPTION PO
P_SupplierMaterialGroupSpend view inner CONSUMPTION Supplier Material Group Spend
P_UserContactCardPO view from CONSUMPTION Purchase Order User Contact Card
P_WrkflwPurchaseOrderItem view inner CONSUMPTION P View of Purchase Order item Workflow
R_POSubcontractingComponent view inner BASIC Internal Basic View for PO Subcontracting Components
R_PurOrdItemPricingElement view inner COMPOSITE Purchase Order Pricing Element
SHSM_SHP_VIEW_RFQ view from CDS-based Value Help Selection Method SHP_VIEW_RFQ

Fields (60)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser CreatedByUser 12
KEY PurchaseOrder LevelM1Document,PurchaseOrder,PurchasingDocument,SubsequentDocument 33
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 2
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 1
_PaymentTerms _PaymentTerms 2
_PurchaseOrderType _PurchaseOrderType 1
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_Supplier _Supplier 3
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CompanyCode CompanyCode,PurgDocHdrCompanyCode 24
CreationDate CreationDate,LastChangeDate 3
DocumentCurrency Currency,DocumentCurrency 17
DownPaymentDueDate DownPaymentDueDate 1
DownPaymentPercentageOfTotAmt DownPaymentPercentageOfTotAmt 1
DownPaymentType DownPaymentType 1
ExchangeRate ExchangeRate 1
IncotermsClassification IncotermsClassification 5
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 4
InvoicingParty InvoicingParty 3
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 5
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 1
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
ManualSupplierAddressID ManualSupplierAddressID 1
NetPaymentDays NetPaymentDays 3
PaymentTerms PaymentTerms 6
PricingProcedure PricingProcedure 3
PurchaseContract PurchaseContract 2
PurchaseOrderDate PurchaseOrderDate 24
PurchaseOrderSubtype PurchaseOrderSubtype,PurchasingDocumentSubtype 3
PurchaseOrderType PurchaseOrderType,PurchasingDocumentType 25
PurchasingCompletenessStatus IsHeld,PurchasingCompletenessStatus 4
PurchasingDocumentCondition PurchasingDocumentCondition 4
PurchasingDocumentDeletionCode IsDeletedHeader,PurchasingDocumentDeletionCode 4
PurchasingDocumentIsAged PurchasingDocumentIsAged 1
PurchasingDocumentOrigin PurchasingDocumentOrigin,PurchasingDocumentStatus 2
PurchasingGroup PurchasingGroup,PurOrdPurchasingGroup 36
PurchasingOrganization PurchasingOrganization,PurOrdPurchasingOrganization 36
PurchasingProcessingStatus PurchasingProcessingStatus 2
ReleaseIsNotCompleted ReleaseIsNotCompleted 4
Supplier FixedSupplierName,Supplier 31
SupplierAddressID PurchaseOrderAddressNumber,SupplierAddressID 2
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierQuotationExternalID SupplierQuotationExternalID 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplyingPlant name1_sp,SupplyingPlant 4
SupplyingSupplier SupplyingSupplier 1
ValidityEndDate PurchaseOrderValidityEndDate,ValidityEndDate 4
ValidityStartDate PurchaseOrderValidityStartDate,ValidityStartDate 2 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchase Order'
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType : #BASIC
@AbapCatalog.sqlViewName: 'IMMPURCHASEORDER'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel: {
  modelCategory: #BUSINESS_OBJECT,
  compositionRoot:true,
  semanticKey: 'PurchaseOrder',
  representativeKey: 'PurchaseOrder'
}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AccessControl.privilegedAssociations: [ '_SupplierAddress' ]

define view I_PurchaseOrder
  as select from R_PurchasingDocument

  association [0..1] to I_PurchasingDocumentType  as _PurchaseOrderType       on  _PurchaseOrderType.PurchasingDocumentCategory = 'F'
                                                                              and _PurchaseOrderType.PurchasingDocumentType     = $projection.PurchaseOrderType

  association [0..*] to I_PurchaseOrderItem       as _PurchaseOrderItem       on  $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder

  association [1..1] to I_PurchaseOrderCalcFields as _PurchaseOrderCalcFields on  $projection.PurchaseOrder = _PurchaseOrderCalcFields.PurchaseOrder

{
      //Key

  key cast (PurchasingDocument as vdm_purchaseorder preserving type) as PurchaseOrder,

      //Category

      @ObjectModel.foreignKey.association: '_PurchaseOrderType'
      cast (PurchasingDocumentType as mm_purchaseordertype preserving type ) as PurchaseOrderType,
      PurchasingDocumentSubtype                      as PurchaseOrderSubtype,
      PurchasingDocumentOrigin,
      PurchasingDocumentIsAged,

      //Admin

      CreatedByUser,
 //     @Semantics.businessDate.createdAt

      CreationDate,
      cast (PurchasingDocumentOrderDate as bedat preserving type)    as PurchaseOrderDate,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
      Language,

      //Status

      PurchasingDocumentDeletionCode,
      ReleaseIsNotCompleted,
      PurchasingCompletenessStatus,
      PurchasingProcessingStatus,
      PurgReleaseSequenceStatus,
      ReleaseCode,  
      PurchasingReleaseStrategy,    

      //Organization

      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      PurchasingOrganization,
      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      PurchasingGroup,

      //Supplier

      @ObjectModel.foreignKey.association: '_Supplier'
      Supplier,
      ManualSupplierAddressID,
      SupplierAddressID,
      SupplierRespSalesPersonName,
      SupplierPhoneNumber,
      @ObjectModel.foreignKey.association: '_SupplyingSupplier'
      SupplyingSupplier,
      @ObjectModel.foreignKey.association: '_SupplyingPlant'
      SupplyingPlant,
      @ObjectModel.foreignKey.association: '_InvoicingParty'
      InvoicingParty,
      Customer,

      //References

      CorrespncExternalReference, //Your reference

      CorrespncInternalReference, //Our reference

      
      // Contract

      PurchaseContract,
      
      // Request For Quotation

      RequestForQuotation,      
      
      //Quotation

      SupplierQuotationExternalID,

      //PaymentTerms

      @ObjectModel.foreignKey.association: '_PaymentTerms'
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,

      //DownPayment

      DownPaymentType,
      DownPaymentPercentageOfTotAmt,
      DownPaymentAmount,
      DownPaymentDueDate,

      //Incoterms

      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      IncotermsClassification,
      IncotermsTransferLocation,
      @ObjectModel.foreignKey.association: '_IncotermsVersion'
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,
      
      //Intratat

      IsIntrastatReportingRelevant,
      IsIntrastatReportingExcluded,

      //Pricing

      PricingDocument as PurchasingDocumentCondition,
      PricingProcedure,
      
      @Semantics.currencyCode
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      DocumentCurrency,

      ValidityStartDate,
      ValidityEndDate,

      @Consumption.hidden: true 
      ExchangeRate,
      ExchangeRateIsFixed,
      
      LastChangeDateTime,
      IsEndOfPurposeBlocked,

      TaxReturnCountry,
      VATRegistrationCountry,
      PurgReasonForDocCancellation,
      PurgReleaseTimeTotalAmount,

      //_CompanyCode.FiscalYearVariant as FiscalYearVariant,


      // Associations


      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PurchaseOrderItem,
      _PurchaseOrderType,
      _CompanyCode,
      _CreatedByUser,
      _Supplier,
      _SupplyingSupplier,
      _InvoicingParty,
      _PurchasingOrganization,
      _PurchasingGroup,
      _DocumentCurrency,
      _IncotermsClassification,
      _IncotermsVersion,
      _SupplyingPlant,
      _PaymentTerms,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_SupplierAddress_2'
      _SupplierAddress,
      _SupplierAddress_2,
      _Language,

      _PurchaseOrderCalcFields

      //Missing Associations


      //_AllContacts

      // Partner

      //Conditions

      //PricingProcedure

}
where
      R_PurchasingDocument.PurchasingDocumentCategory = 'F'
  and R_PurchasingDocument.PurchasingDocumentIsAged   = ''   
  and IsEndOfPurposeBlocked = ''
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASINGDOCUMENT"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_COMPANYCODE",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_LANGUAGE",
"I_ORGANIZATIONADDRESS",
"I_PAYMENTTERMS",
"I_PLANT",
"I_PURCHASEORDERCALCFIELDS",
"I_PURCHASEORDERITEM",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_USER"
],
"BASE":
[
"R_PURCHASINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More