R_PPS_PurchaseReqnAcctAssgmt

DDL: R_PPS_PURCHASEREQNACCTASSGMT Type: view_entity COMPOSITE
60 Fields 1 Data Sources

PPS Account Assignment

R_PPS_PurchaseReqnAcctAssgmt is a Composite CDS View that provides data about "PPS Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PPS_PurReqnAcctAssgmt) and exposes 60 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurReqnAcctAssgmtNmbr.

Data Sources (1)

SourceAliasJoin Type
I_PPS_PurReqnAcctAssgmt I_PPS_PurReqnAcctAssgmt from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label PPS Account Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.extensibility.extensible true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
KEY PurReqnAcctAssgmtNmbr PurReqnAcctAssgmtNmbr Ser.no.acc.ass.
Plant Plant Valuation Area
CostCenter CostCenter Cost Center
MasterFixedAsset MasterFixedAsset Fixed Asset
ProjectNetwork ProjectNetwork Order
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
PurReqnNetAmount PurReqnNetAmount Net Value
PurReqnItemCurrency PurReqnItemCurrency Currency
IsDeleted IsDeleted TRUE
GLAccount GLAccount General Ledger
BusinessArea BusinessArea Business Area
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SalesOrderScheduleLine SalesOrderScheduleLine SOrder schedule
FixedAsset FixedAsset Sub-number
OrderID OrderID Order ID
UnloadingPointName UnloadingPointName Unloading Point Name
ControllingArea ControllingArea Controlling Area
CostObject CostObject Cost Object
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementInternalID_2 WBSElementInternalID_2
WBSElement WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementExternalID_2 WBSElementExternalID_2 WBS Element External ID
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
CommitmentItemShortID CommitmentItemShortID Commitment Item Short ID
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
FunctionalArea FunctionalArea Sendr Fctl Area
CreationDate CreationDate Time Stamp
GoodsRecipientName GoodsRecipientName Recipient Name
REInternalFinNumber REInternalFinNumber Real Estate Key
NetworkActivityInternalID NetworkActivityInternalID Counter
PartnerAccountNumber PartnerAccountNumber Partner
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
SettlementReferenceDate SettlementReferenceDate Reference date
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
CostCtrActivityType CostCtrActivityType Activity Type
BusinessProcess BusinessProcess Business Process
GrantID GrantID Sender Grant
ValidityDate ValidityDate Valid On
BudgetPeriod BudgetPeriod Budget Period
CompanyCode
PubSecSplitBatchNumberID PubSecSplitBatchNumberID Dist.Batch No.
PubSecSplitAuthznGroup PubSecSplitAuthznGroup Auth.Group
_PurchaseReqnItemBsc _PurchaseReqnItemBsc
_BusinessAreaText _BusinessAreaText
_SalesOrderItem _SalesOrderItem
_SalesOrder _SalesOrder
_Plant _Plant
_WBSElementBasicData _WBSElementBasicData
_Order _Order
_ProjectNetwork _ProjectNetwork

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 R_PPS_PurchaseReqnAcctAssgmt.
-- 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.

CREATE VIEW R_PPS_PurchaseReqnAcctAssgmt AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurReqnAcctAssgmtNmbr,
  Plant,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  Quantity,
  BaseUnit,
  MultipleAcctAssgmtDistrPercent,
  PurReqnNetAmount,
  PurReqnItemCurrency,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementInternalID_2,
  cast( WBSElement as ps_posid_edit preserving type ) AS WBSElement,
  WBSElementExternalID,
  WBSElementExternalID_2,
  ProjectNetworkInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  CreationDate,
  GoodsRecipientName,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  ValidityDate,
  BudgetPeriod,
  _Plant._ValuationArea.CompanyCode AS CompanyCode,
  PubSecSplitBatchNumberID,
  PubSecSplitAuthznGroup
FROM I_PPS_PurReqnAcctAssgmt
;

Learn More