R_PurchaseReqnAcctAssgmtTP

DDL: R_PURCHASEREQNACCTASSGMTTP SQL: RPURREQACC Type: view_entity TRANSACTIONAL
56 Fields 1 Data Sources 4 Associations

Purchase Requisition Account Assignment

R_PurchaseReqnAcctAssgmtTP is a Transactional CDS View that provides data about "Purchase Requisition Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurReqnAcctAssgmt) and exposes 56 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnAcctAssgmt I_PurReqnAcctAssgmt from

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_PurchaseRequisitionTP _PurReqn $projection.PurchaseRequisition = _PurReqn.PurchaseRequisition
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.baseunit
[0..1] I_Currency _Currency _Currency.Currency = $projection.purreqnitemcurrency ----Extension
[0..1] E_Purreqnacctassgmt _PurReqnAcctAssgmtExtension $projection.PurchaseRequisition = _PurReqnAcctAssgmtExtension.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurReqnAcctAssgmtExtension.PurchaseRequisitionItem and $projection.PurchaseReqnAcctAssgmtNumber = _PurReqnAcctAssgmtExtension.PurchaseReqnAcctAssgmtNumber

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Requisition Account Assignment view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurReqnAcctAssgmt PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurReqnAcctAssgmt PurchaseRequisitionItem Requisn. item
KEY PurchaseReqnAcctAssgmtNumber I_PurReqnAcctAssgmt PurchaseReqnAcctAssgmtNumber
CostCenter I_PurReqnAcctAssgmt CostCenter Cost Center
MasterFixedAsset I_PurReqnAcctAssgmt MasterFixedAsset Fixed Asset
ProjectNetwork I_PurReqnAcctAssgmt ProjectNetwork Order
BaseUnit _PurchaseRequisitionItem BaseUnit Unit of Measure
Quantity I_PurReqnAcctAssgmt Quantity Value
MultipleAcctAssgmtDistrPercent I_PurReqnAcctAssgmt MultipleAcctAssgmtDistrPercent Distribution
PurReqnItemCurrency _PurchaseRequisitionItem PurReqnItemCurrency Currency
PurReqnNetAmount I_PurReqnAcctAssgmt PurReqnNetAmount Net Value
IsDeleted I_PurReqnAcctAssgmt IsDeleted TRUE
GLAccount I_PurReqnAcctAssgmt GLAccount General Ledger
BusinessArea I_PurReqnAcctAssgmt BusinessArea Business Area
SalesOrder I_PurReqnAcctAssgmt SalesOrder SD Document
SalesOrderItem I_PurReqnAcctAssgmt SalesOrderItem Sales Order Item
SalesOrderScheduleLine I_PurReqnAcctAssgmt SalesOrderScheduleLine SOrder schedule
FixedAsset I_PurReqnAcctAssgmt FixedAsset Sub-number
OrderID I_PurReqnAcctAssgmt OrderID Order ID
UnloadingPointName I_PurReqnAcctAssgmt UnloadingPointName Unloading Point Name
ControllingArea I_PurReqnAcctAssgmt ControllingArea Controlling Area
CostObject I_PurReqnAcctAssgmt CostObject Cost Object
ProfitCenter I_PurReqnAcctAssgmt ProfitCenter Profit Center
ProjectNetworkInternalID I_PurReqnAcctAssgmt ProjectNetworkInternalID Plan No.f.Oper.
CommitmentItem I_CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID
FundsCenter I_PurReqnAcctAssgmt FundsCenter Funds Center
Fund I_PurReqnAcctAssgmt Fund Sender Fund
FunctionalArea I_PurReqnAcctAssgmt FunctionalArea Sendr Fctl Area
CreationDate I_PurReqnAcctAssgmt CreationDate Time Stamp
GoodsRecipientName I_PurReqnAcctAssgmt GoodsRecipientName Recipient Name
REInternalFinNumber
NetworkActivityInternalID I_PurReqnAcctAssgmt NetworkActivityInternalID Counter
PartnerAccountNumber I_PurReqnAcctAssgmt PartnerAccountNumber Partner
JointVentureRecoveryCode I_PurReqnAcctAssgmt JointVentureRecoveryCode Recovery Ind.
SettlementReferenceDate I_PurReqnAcctAssgmt SettlementReferenceDate Reference date
OrderInternalID I_PurReqnAcctAssgmt OrderInternalID Plan No.f.Oper.
OrderIntBillOfOperationsItem I_PurReqnAcctAssgmt OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
EarmarkedFundsDocument I_PurReqnAcctAssgmt EarmarkedFundsDocument Earmarked Funds
CostCtrActivityType I_PurReqnAcctAssgmt CostCtrActivityType Activity Type
BusinessProcess I_PurReqnAcctAssgmt BusinessProcess Business Process
GrantID I_PurReqnAcctAssgmt GrantID Sender Grant
ValidityDate I_PurReqnAcctAssgmt ValidityDate Valid On
ChartOfAccounts I_PurReqnAcctAssgmt ChartOfAccounts Node Class
WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
ProcmtHubWBSElementExternalID I_PurReqnAcctAssgmt ProcmtHubWBSElementExternalID
NetworkActivity I_PurReqnAcctAssgmt NetworkActivity Operation/Activity
LastChangeDateTime _PurchaseRequisitionItem LastChangeDateTime Timestamp
PurchaseRequisitionType _PurchaseRequisitionItem PurchaseRequisitionType Order Type
Plant _PurchaseRequisitionItem Plant Valuation Area
PurchasingOrganization _PurchaseRequisitionItem PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseRequisitionItem PurchasingGroup Purchasing Group
_PurchaseRequisitionItem _PurchaseRequisitionItem
_PurReqn _PurReqn
_UnitOfMeasure _UnitOfMeasure
_Currency _Currency

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_PurchaseReqnAcctAssgmtTP.
-- 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: RPURREQACC

CREATE VIEW R_PurchaseReqnAcctAssgmtTP AS
SELECT
  I_PurReqnAcctAssgmt.PurchaseRequisition AS PurchaseRequisition,
  I_PurReqnAcctAssgmt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  I_PurReqnAcctAssgmt.CostCenter AS CostCenter,
  I_PurReqnAcctAssgmt.MasterFixedAsset AS MasterFixedAsset,
  I_PurReqnAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  _PurchaseRequisitionItem.BaseUnit AS BaseUnit,
  I_PurReqnAcctAssgmt.Quantity AS Quantity,
  I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  _PurchaseRequisitionItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_PurReqnAcctAssgmt.PurReqnNetAmount AS PurReqnNetAmount,
  I_PurReqnAcctAssgmt.IsDeleted AS IsDeleted,
  I_PurReqnAcctAssgmt.GLAccount AS GLAccount,
  I_PurReqnAcctAssgmt.BusinessArea AS BusinessArea,
  I_PurReqnAcctAssgmt.SalesOrder AS SalesOrder,
  I_PurReqnAcctAssgmt.SalesOrderItem AS SalesOrderItem,
  I_PurReqnAcctAssgmt.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  I_PurReqnAcctAssgmt.FixedAsset AS FixedAsset,
  I_PurReqnAcctAssgmt.OrderID AS OrderID,
  I_PurReqnAcctAssgmt.UnloadingPointName AS UnloadingPointName,
  I_PurReqnAcctAssgmt.ControllingArea AS ControllingArea,
  I_PurReqnAcctAssgmt.CostObject AS CostObject,
  I_PurReqnAcctAssgmt.ProfitCenter AS ProfitCenter,
  I_PurReqnAcctAssgmt.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  I_CommitmentItem.CommitmentItem AS CommitmentItem,
  cast( I_PurReqnAcctAssgmt.CommitmentItemShortID as fmis_ci_internalname ) AS CommitmentItemShortID,
  I_PurReqnAcctAssgmt.FundsCenter AS FundsCenter,
  I_PurReqnAcctAssgmt.Fund AS Fund,
  I_PurReqnAcctAssgmt.FunctionalArea AS FunctionalArea,
  I_PurReqnAcctAssgmt.CreationDate AS CreationDate,
  I_PurReqnAcctAssgmt.GoodsRecipientName AS GoodsRecipientName,
  cast( I_PurReqnAcctAssgmt.RealEstateObject as recaimkeyfi) AS REInternalFinNumber,
  I_PurReqnAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  I_PurReqnAcctAssgmt.PartnerAccountNumber AS PartnerAccountNumber,
  I_PurReqnAcctAssgmt.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_PurReqnAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  I_PurReqnAcctAssgmt.OrderInternalID AS OrderInternalID,
  I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  I_PurReqnAcctAssgmt.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_PurReqnAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  I_PurReqnAcctAssgmt.BusinessProcess AS BusinessProcess,
  I_PurReqnAcctAssgmt.GrantID AS GrantID,
  I_PurReqnAcctAssgmt.ValidityDate AS ValidityDate,
  I_PurReqnAcctAssgmt.ChartOfAccounts AS ChartOfAccounts,
  I_WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  I_PurReqnAcctAssgmt.ProcmtHubWBSElementExternalID AS ProcmtHubWBSElementExternalID,
  I_PurReqnAcctAssgmt.NetworkActivity AS NetworkActivity,
  _PurchaseRequisitionItem.LastChangeDateTime AS LastChangeDateTime,
  _PurchaseRequisitionItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  _PurchaseRequisitionItem.Plant AS Plant,
  _PurchaseRequisitionItem.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseRequisitionItem.PurchasingGroup AS PurchasingGroup
FROM I_PurReqnAcctAssgmt
LEFT OUTER JOIN R_PurchaseRequisitionTP AS _PurReqn ON PurchaseRequisition = _PurReqn.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = baseunit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = purreqnitemcurrency  -- association [0..1]
LEFT OUTER JOIN E_Purreqnacctassgmt AS _PurReqnAcctAssgmtExtension ON PurchaseRequisition = _PurReqnAcctAssgmtExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnAcctAssgmtExtension.PurchaseRequisitionItem AND PurchaseReqnAcctAssgmtNumber = _PurReqnAcctAssgmtExtension.PurchaseReqnAcctAssgmtNumber  -- association [0..1]
;

Learn More