P_PrmtHubPRItemSAcctAssign

DDL: P_PRMTHUBPRITEMSACCTASSIGN SQL: PPRHBWSACAS Type: view CONSUMPTION
34 Fields 2 Data Sources

P View-Cntrl PR with Single Acct Assign

P_PrmtHubPRItemSAcctAssign is a Consumption CDS View that provides data about "P View-Cntrl PR with Single Acct Assign" in SAP S/4HANA. It reads from 2 data sources (I_PrmtHbRpldPurReqnAcctAssgmt, I_PrmtHbRpldPurchaseReqnItem) and exposes 34 fields with key fields ProcmtHubPurchaseRequisition, ProcmtHubPurRequisitionItem, ProcurementHubSourceSystem.

Data Sources (2)

SourceAliasJoin Type
I_PrmtHbRpldPurReqnAcctAssgmt AccountAssignment inner
I_PrmtHbRpldPurchaseReqnItem PurReqn from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRHBWSACAS 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-Cntrl PR with Single Acct Assign view

Fields (34)

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

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_PrmtHubPRItemSAcctAssign.
-- 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: PPRHBWSACAS

CREATE VIEW P_PrmtHubPRItemSAcctAssign AS
SELECT
  PurReqn.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  PurReqn.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  PurReqn.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  AccountAssignment.ProcmtHubPurReqnAcctAssgmtNo AS AccountAssignmentNumber,
  AccountAssignment.ProcmtHubGLAccount AS ProcmtHubGLAccount,
  AccountAssignment.ProcmtHubCostCenter AS ProcmtHubCostCenter,
  AccountAssignment.ProcmtHubProjectNetwork AS ProcmtHubProjectNetwork,
  AccountAssignment.ProcmtHubMasterFixedAsset AS ProcmtHubMasterFixedAsset,
  AccountAssignment.ProcmtHubWBSElementInternalID AS ProcmtHubWBSElementInternalID,
  AccountAssignment.ValidityDate AS ValidityDate,
  AccountAssignment.ProcmtHubControllingArea AS ProcmtHubControllingArea,
  AccountAssignment.ChartOfAccounts AS ChartOfAccounts,
  PurReqn.RequestedQuantity AS RequestedQuantity,
  PurReqn.OrderedQuantity AS OrderedQuantity,
  PurReqn.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  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.ProcmtHubProduct AS Material,
  PurReqn.ProcmtHubProductGroup 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,
  PurReqn.IsDeleted AS IsDeleted
FROM I_PrmtHbRpldPurchaseReqnItem AS PurReqn
INNER JOIN I_PrmtHbRpldPurReqnAcctAssgmt AS AccountAssignment ON /* join condition not captured in parsed metadata */
;

Learn More