P_PrmtHubPRItemWithAcctAssign

DDL: P_PRMTHUBPRITEMWITHACCTASSIGN SQL: PPRHBWACAS Type: view CONSUMPTION
100 Fields 3 Data Sources

P View of Cntrl PR Items-Acct Assignment

P_PrmtHubPRItemWithAcctAssign is a Consumption CDS View that provides data about "P View of Cntrl PR Items-Acct Assignment" in SAP S/4HANA. It reads from 3 data sources (P_PrmtHubPRItemDisType, P_PrmtHubPRItemDisType, P_PrmtHubPRItemDisType) and exposes 100 fields with key fields ProcmtHubPurchaseRequisition, ProcmtHubPurRequisitionItem, ProcurementHubSourceSystem, ProcmtHubPurRequisitionItem, ProcurementHubSourceSystem.

Data Sources (3)

SourceAliasJoin Type
P_PrmtHubPRItemDisType PurReqn from
P_PrmtHubPRItemDisType PurReqn union_all
P_PrmtHubPRItemDisType PurReqn union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRHBWACAS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label P View of Cntrl PR Items-Acct Assignment view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY ProcmtHubPurchaseRequisition P_PrmtHubPRItemDisType ProcmtHubPurchaseRequisition Purchase Req.
KEY ProcmtHubPurRequisitionItem P_PrmtHubPRItemDisType ProcmtHubPurRequisitionItem Requisn. item
KEY ProcurementHubSourceSystem P_PrmtHubPRItemDisType ProcurementHubSourceSystem Connected System ID
AccountAssignmentNumber AccountAssignment ProcmtHubPurReqnAcctAssgmtNo
ProcmtHubWBSElementInternalID AccountAssignment ProcmtHubWBSElementInternalID WBS Element
ProcmtHubMasterFixedAsset AccountAssignment ProcmtHubMasterFixedAsset Asset
ProcmtHubProjectNetwork AccountAssignment ProcmtHubProjectNetwork Network
ProcmtHubCostCenter AccountAssignment ProcmtHubCostCenter Cost Center
ProcmtHubGLAccount AccountAssignment ProcmtHubGLAccount G/L Account
ProcmtHubControllingArea AccountAssignment ProcmtHubControllingArea CO Area
ChartOfAccounts AccountAssignment ChartOfAccounts Node Class
ValidityDate AccountAssignment ValidityDate Valid On
RequestedQuantity P_PrmtHubPRItemDisType RequestedQuantity Requested Quantity
OrderedQuantity P_PrmtHubPRItemDisType OrderedQuantity Quantity
PurReqnPriceQuantity P_PrmtHubPRItemDisType PurReqnPriceQuantity Price unit
BaseUnit P_PrmtHubPRItemDisType BaseUnit Unit of Measure
PurchaseRequisitionPrice P_PrmtHubPRItemDisType PurchaseRequisitionPrice Valuation Price
ProcmtHubAcctAssgmtCategory P_PrmtHubPRItemDisType ProcmtHubAcctAssgmtCategory Acct Assgmt Cat
PurchaseRequisitionItemText P_PrmtHubPRItemDisType PurchaseRequisitionItemText Short Text
ProcmtHubPurgDocItmCategory P_PrmtHubPRItemDisType ProcmtHubPurgDocItmCategory Item Category
ProcmtHubPurRequisitionType P_PrmtHubPRItemDisType ProcmtHubPurRequisitionType
ProcmtHubPurchasingGroup P_PrmtHubPRItemDisType ProcmtHubPurchasingGroup Purch. Group
ProcmtHubCompanyCode P_PrmtHubPRItemDisType ProcmtHubCompanyCode Company Code
ProcmtHubPurchasingOrg P_PrmtHubPRItemDisType ProcmtHubPurchasingOrg Purchasing Org.
ProcmtHubPlant P_PrmtHubPRItemDisType ProcmtHubPlant Plant
Material P_PrmtHubPRItemDisType Material Vehicle Model
MaterialGroup P_PrmtHubPRItemDisType MaterialGroup Product Group
ProcmtHubCreatedByUser P_PrmtHubPRItemDisType ProcmtHubCreatedByUser Entered By
CreationDate P_PrmtHubPRItemDisType CreationDate Time Stamp
PurReqnReleaseStatus P_PrmtHubPRItemDisType PurReqnReleaseStatus Proc.state
ProcessingStatus P_PrmtHubPRItemDisType ProcessingStatus Worklist Status
DeliveryDate P_PrmtHubPRItemDisType DeliveryDate Delivery Date
PurReqnItemCurrency P_PrmtHubPRItemDisType PurReqnItemCurrency Currency
ProcmtHubPurchaseRequisition Purchase Req.
KEY ProcmtHubPurRequisitionItem P_PrmtHubPRItemDisType ProcmtHubPurRequisitionItem Requisn. item
KEY ProcurementHubSourceSystem P_PrmtHubPRItemDisType ProcurementHubSourceSystem Connected System ID
AccountAssignmentNumber
ProcmtHubWBSElementInternalID WBS Element
ProcmtHubMasterFixedAsset Asset
ProcmtHubProjectNetwork Network
ProcmtHubCostCenter Cost Center
ProcmtHubGLAccount G/L Account
ProcmtHubControllingArea CO Area
ChartOfAccounts Node Class
ValidityDate AccountAssignment ValidityDate Valid On
RequestedQuantity P_PrmtHubPRItemDisType RequestedQuantity Requested Quantity
OrderedQuantity P_PrmtHubPRItemDisType OrderedQuantity Quantity
PurReqnPriceQuantity P_PrmtHubPRItemDisType PurReqnPriceQuantity Price unit
BaseUnit P_PrmtHubPRItemDisType BaseUnit Unit of Measure
PurchaseRequisitionPrice P_PrmtHubPRItemDisType PurchaseRequisitionPrice Valuation Price
ProcmtHubAcctAssgmtCategory P_PrmtHubPRItemDisType ProcmtHubAcctAssgmtCategory Acct Assgmt Cat
PurchaseRequisitionItemText P_PrmtHubPRItemDisType PurchaseRequisitionItemText Short Text
ProcmtHubPurgDocItmCategory P_PrmtHubPRItemDisType ProcmtHubPurgDocItmCategory Item Category
ProcmtHubPurRequisitionType P_PrmtHubPRItemDisType ProcmtHubPurRequisitionType
ProcmtHubPurchasingGroup P_PrmtHubPRItemDisType ProcmtHubPurchasingGroup Purch. Group
ProcmtHubCompanyCode P_PrmtHubPRItemDisType ProcmtHubCompanyCode Company Code
ProcmtHubPurchasingOrg P_PrmtHubPRItemDisType ProcmtHubPurchasingOrg Purchasing Org.
ProcmtHubPlant P_PrmtHubPRItemDisType ProcmtHubPlant Plant
Material P_PrmtHubPRItemDisType Material Vehicle Model
MaterialGroup P_PrmtHubPRItemDisType MaterialGroup Product Group
ProcmtHubCreatedByUser P_PrmtHubPRItemDisType ProcmtHubCreatedByUser Entered By
CreationDate P_PrmtHubPRItemDisType CreationDate Time Stamp
PurReqnReleaseStatus P_PrmtHubPRItemDisType PurReqnReleaseStatus Proc.state
ProcessingStatus P_PrmtHubPRItemDisType ProcessingStatus Worklist Status
DeliveryDate P_PrmtHubPRItemDisType DeliveryDate Delivery Date
PurReqnItemCurrency P_PrmtHubPRItemDisType PurReqnItemCurrency Currency
ProcmtHubPurchaseRequisition Purchase Req.
KEY ProcmtHubPurRequisitionItem P_PrmtHubPRItemDisType ProcmtHubPurRequisitionItem Requisn. item
KEY ProcurementHubSourceSystem P_PrmtHubPRItemDisType ProcurementHubSourceSystem Connected System ID
AccountAssignmentNumber
ProcmtHubWBSElementInternalID WBS Element
ProcmtHubMasterFixedAsset Asset
ProcmtHubProjectNetwork Network
ProcmtHubCostCenter Cost Center
ProcmtHubGLAccount G/L Account
ProcmtHubControllingArea CO Area
ChartOfAccounts Node Class
ValidityDate AccountAssignment ValidityDate Valid On
RequestedQuantity P_PrmtHubPRItemDisType RequestedQuantity Requested Quantity
OrderedQuantity P_PrmtHubPRItemDisType OrderedQuantity Quantity
PurReqnPriceQuantity P_PrmtHubPRItemDisType PurReqnPriceQuantity Price unit
BaseUnit P_PrmtHubPRItemDisType BaseUnit Unit of Measure
PurchaseRequisitionPrice P_PrmtHubPRItemDisType PurchaseRequisitionPrice Valuation Price
ProcmtHubAcctAssgmtCategory P_PrmtHubPRItemDisType ProcmtHubAcctAssgmtCategory Acct Assgmt Cat
PurchaseRequisitionItemText P_PrmtHubPRItemDisType PurchaseRequisitionItemText Short Text
ProcmtHubPurgDocItmCategory P_PrmtHubPRItemDisType ProcmtHubPurgDocItmCategory Item Category
ProcmtHubPurRequisitionType P_PrmtHubPRItemDisType ProcmtHubPurRequisitionType
ProcmtHubPurchasingGroup P_PrmtHubPRItemDisType ProcmtHubPurchasingGroup Purch. Group
ProcmtHubCompanyCode P_PrmtHubPRItemDisType ProcmtHubCompanyCode Company Code
ProcmtHubPurchasingOrg P_PrmtHubPRItemDisType ProcmtHubPurchasingOrg Purchasing Org.
ProcmtHubPlant P_PrmtHubPRItemDisType ProcmtHubPlant Plant
Material P_PrmtHubPRItemDisType Material Vehicle Model
MaterialGroup P_PrmtHubPRItemDisType MaterialGroup Product Group
ProcmtHubCreatedByUser P_PrmtHubPRItemDisType ProcmtHubCreatedByUser Entered By
CreationDate P_PrmtHubPRItemDisType CreationDate Time Stamp
PurReqnReleaseStatus P_PrmtHubPRItemDisType PurReqnReleaseStatus Proc.state
ProcessingStatus P_PrmtHubPRItemDisType ProcessingStatus Worklist Status
DeliveryDate P_PrmtHubPRItemDisType DeliveryDate Delivery Date
PurReqnItemCurrency P_PrmtHubPRItemDisType PurReqnItemCurrency Currency
ProcmtHubFixedSupplier P_PrmtHubPRItemDisType ProcmtHubFixedSupplier

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 P_PrmtHubPRItemWithAcctAssign.
-- 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: PPRHBWACAS

CREATE VIEW P_PrmtHubPRItemWithAcctAssign AS
SELECT
  PurReqn.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  PurReqn.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  PurReqn.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  AccountAssignment.ProcmtHubPurReqnAcctAssgmtNo AS AccountAssignmentNumber,
  AccountAssignment.ProcmtHubWBSElementInternalID AS ProcmtHubWBSElementInternalID,
  AccountAssignment.ProcmtHubMasterFixedAsset AS ProcmtHubMasterFixedAsset,
  AccountAssignment.ProcmtHubProjectNetwork AS ProcmtHubProjectNetwork,
  AccountAssignment.ProcmtHubCostCenter AS ProcmtHubCostCenter,
  AccountAssignment.ProcmtHubGLAccount AS ProcmtHubGLAccount,
  AccountAssignment.ProcmtHubControllingArea AS ProcmtHubControllingArea,
  AccountAssignment.ChartOfAccounts AS ChartOfAccounts,
  AccountAssignment.ValidityDate AS ValidityDate,
  PurReqn.RequestedQuantity AS RequestedQuantity,
  PurReqn.OrderedQuantity AS OrderedQuantity,
  PurReqn.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  PurReqn.BaseUnit AS BaseUnit,
  PurReqn.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  PurReqn.ProcmtHubAcctAssgmtCategory AS ProcmtHubAcctAssgmtCategory,
  PurReqn.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  PurReqn.ProcmtHubPurgDocItmCategory AS ProcmtHubPurgDocItmCategory,
  PurReqn.ProcmtHubPurRequisitionType AS ProcmtHubPurRequisitionType,
  PurReqn.ProcmtHubPurchasingGroup AS ProcmtHubPurchasingGroup,
  PurReqn.ProcmtHubCompanyCode AS ProcmtHubCompanyCode,
  PurReqn.ProcmtHubPurchasingOrg AS ProcmtHubPurchasingOrg,
  PurReqn.ProcmtHubPlant AS ProcmtHubPlant,
  PurReqn.Material AS Material,
  PurReqn.MaterialGroup AS MaterialGroup,
  PurReqn.ProcmtHubCreatedByUser AS ProcmtHubCreatedByUser,
  PurReqn.CreationDate AS CreationDate,
  PurReqn.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  PurReqn.ProcessingStatus AS ProcessingStatus,
  PurReqn.DeliveryDate AS DeliveryDate,
  PurReqn.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurReqn.ProcmtHubFixedSupplier AS ProcmtHubFixedSupplier
FROM P_PrmtHubPRItemDisType AS PurReqn
-- UNION ALL with additional select branch(es): P_PrmtHubPRItemDisType
;

Learn More