I_PurchaseReqnAcctAssgmtTP

DDL: I_PURCHASEREQNACCTASSGMTTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources

Purchase Reqn Account Assignment - TP

I_PurchaseReqnAcctAssgmtTP is a Transactional CDS View that provides data about "Purchase Reqn Account Assignment - TP" in SAP S/4HANA. It reads from 1 data source (R_PurchaseReqnAcctAssgmtTP) and exposes 53 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseReqnAcctAssgmtTP R_PurchaseReqnAcctAssgmtTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Purchase Reqn Account Assignment - TP view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey PurchaseReqnAcctAssgmtNumber view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
KEY PurchaseReqnAcctAssgmtNumber PurchaseReqnAcctAssgmtNumber
CostCenter CostCenter Cost Center
MasterFixedAsset MasterFixedAsset Fixed Asset
ProjectNetwork ProjectNetwork Order
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
PurReqnItemCurrency PurReqnItemCurrency Currency
PurReqnNetAmount PurReqnNetAmount Net Value
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
ProfitCenter ProfitCenter Profit Center
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
CommitmentItem CommitmentItem Commitment item
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
OrderInternalID OrderInternalID Plan No.f.Oper.
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
CostCtrActivityType CostCtrActivityType Activity Type
BusinessProcess BusinessProcess Business Process
GrantID GrantID Sender Grant
ValidityDate ValidityDate Valid On
ChartOfAccounts ChartOfAccounts Node Class
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
PurchaseRequisitionType PurchaseRequisitionType Order Type
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
LastChangeDateTime LastChangeDateTime Timestamp
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure

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

CREATE VIEW I_PurchaseReqnAcctAssgmtTP AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseReqnAcctAssgmtNumber,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  BaseUnit,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  PurReqnItemCurrency,
  PurReqnNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitCenter,
  ProjectNetworkInternalID,
  CommitmentItem,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  CreationDate,
  GoodsRecipientName,
  REInternalFinNumber,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  EarmarkedFundsDocument,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  ValidityDate,
  ChartOfAccounts,
  WBSElementInternalID,
  WBSElementExternalID,
  PurchaseRequisitionType,
  Plant,
  PurchasingOrganization,
  PurchasingGroup,
  LastChangeDateTime
FROM R_PurchaseReqnAcctAssgmtTP
;

Learn More