Deprecated NONE
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PrmtHbRpldSuplrInvcItmPORef

DDL: C_PRMTHBRPLDSUPLRINVCITMPOREF SQL: CPRCHUBSINVPOREF Type: view CONSUMPTION
25 Fields 1 Data Sources

Procurement Hub Supplier Invoice Item Purchase Order Ref.

C_PrmtHbRpldSuplrInvcItmPORef is a Consumption CDS View that provides data about "Procurement Hub Supplier Invoice Item Purchase Order Ref." in SAP S/4HANA. It reads from 1 data source (I_PrmtHbRpldSuplrInvcItmPORef) and exposes 25 fields with key field PrmtHbRpldSuplrInvcItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_PrmtHbRpldSuplrInvcItmPORef I_PrmtHbRpldSuplrInvcItmPORef from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRCHUBSINVPOREF view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label Procurement Hub Supplier Invoice Item Purchase Order Ref. view
VDM.lifecycle.contract.type #NONE view
VDM.lifecycle.status #DEPRECATED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PrmtHbRpldSuplrInvcItemUUID PrmtHbRpldSuplrInvcItemUUID UUID
PrmtHbRpldSupplierInvoiceUUID PrmtHbRpldSupplierInvoiceUUID UUID
PrmtHbRpldSupplierInvoice PrmtHbRpldSupplierInvoice Inv. Doc. No.
PrmtHbRpldSuplrInvcFiscalYear PrmtHbRpldSuplrInvcFiscalYear Fiscal Year
ProcmtHubCompanyCode ProcmtHubCompanyCode Company Code
SupplierInvoiceItemDescription SupplierInvoiceItemDescription Short Text
ProcmtHubDocumentCurrency ProcmtHubDocumentCurrency Currency Key
PrmtHbRpldSupplierInvoiceItem PrmtHbRpldSupplierInvoiceItem Seq. Number
FormattedPurchaseOrderItem
PrmtHbRpldPurchaseOrder PrmtHbRpldPurchaseOrder Purchasing Doc.
PrmtHbRpldPurchaseOrderItem PrmtHbRpldPurchaseOrderItem Item
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
DebitCreditCode DebitCreditCode Single-Character Flag
ProcmtHubTaxCode ProcmtHubTaxCode Tax Code
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit Quantity
ProcmtHubOrderQuantityUnit ProcmtHubOrderQuantityUnit Order Unit
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
ProcmtHubOrderPriceUnit ProcmtHubOrderPriceUnit PO Price Unit
IsSubsequentDebitCredit IsSubsequentDebitCredit Subseq. Dr/Cr
PrmtHbReferenceDocument PrmtHbReferenceDocument Reference Doc.
PrmtHbReferenceDocumentFsclYr PrmtHbReferenceDocumentFsclYr Year Cur.Period
PrmtHbReferenceDocumentItem PrmtHbReferenceDocumentItem Ref. Doc. Item
SupplierInvoiceItemText SupplierInvoiceItemText Text
ProcmtHubPlant ProcmtHubPlant Plant
_SupplierInvoice _SupplierInvoice

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_PrmtHbRpldSuplrInvcItmPORef.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPRCHUBSINVPOREF

CREATE VIEW C_PrmtHbRpldSuplrInvcItmPORef AS
SELECT
  PrmtHbRpldSuplrInvcItemUUID,
  PrmtHbRpldSupplierInvoiceUUID,
  PrmtHbRpldSupplierInvoice,
  PrmtHbRpldSuplrInvcFiscalYear,
  ProcmtHubCompanyCode,
  SupplierInvoiceItemDescription,
  ProcmtHubDocumentCurrency,
  PrmtHbRpldSupplierInvoiceItem,
  concat(concat(PrmtHbRpldPurchaseOrder, '/'), PrmtHbRpldPurchaseOrderItem) AS FormattedPurchaseOrderItem,
  PrmtHbRpldPurchaseOrder,
  PrmtHbRpldPurchaseOrderItem,
  SupplierInvoiceItemAmount,
  DebitCreditCode,
  ProcmtHubTaxCode,
  QuantityInPurchaseOrderUnit,
  ProcmtHubOrderQuantityUnit,
  QtyInPurchaseOrderPriceUnit,
  ProcmtHubOrderPriceUnit,
  IsSubsequentDebitCredit,
  PrmtHbReferenceDocument,
  PrmtHbReferenceDocumentFsclYr,
  PrmtHbReferenceDocumentItem,
  SupplierInvoiceItemText,
  ProcmtHubPlant
FROM I_PrmtHbRpldSuplrInvcItmPORef
;

Learn More