I_PurOrdAccountAssignmentTP_2

DDL: I_PURORDACCOUNTASSIGNMENTTP_2 Type: view_entity TRANSACTIONAL
85 Fields 1 Data Sources

PO Account Assignment Projection

I_PurOrdAccountAssignmentTP_2 is a Transactional CDS View that provides data about "PO Account Assignment Projection" in SAP S/4HANA. It reads from 1 data source (R_PurOrdAccountAssignmentTP) and exposes 85 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber.

Data Sources (1)

SourceAliasJoin Type
R_PurOrdAccountAssignmentTP R_PurOrdAccountAssignmentTP projection

Annotations (9)

NameValueLevelField
EndUserText.label PO Account Assignment Projection view
AccessControl.authorizationCheck #CHECK view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
CostCenter CostCenter Cost Center
MasterFixedAsset MasterFixedAsset Fixed Asset
ProjectNetwork ProjectNetwork Order
NetworkActivity NetworkActivity Operation/Activity
OrderQuantityUnit OrderQuantityUnit Sales Unit
Quantity Quantity Value
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent Distribution
DocumentCurrency DocumentCurrency Document Currency
PurgDocNetAmount PurgDocNetAmount 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
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID 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
LastChangedDate LastChangedDate Created On
GoodsRecipientName GoodsRecipientName Recipient Name
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
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
TaxCode TaxCode Tax Code
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
CostCtrActivityType CostCtrActivityType Activity Type
BusinessProcess BusinessProcess Business Process
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
ValidityDate ValidityDate Valid On
ChartOfAccounts ChartOfAccounts Node Class
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
CreationDate CreationDate Time Stamp
IsAcctLineFinal IsAcctLineFinal Final AA
AcctLineFinalReason AcctLineFinalReason Final AA Reason
CompanyCode CompanyCode Receiver Company Code
_BusinessArea _BusinessArea
_BusinessAreaText _BusinessAreaText
_BusinessProcess _BusinessProcess
_BusinessProcessText _BusinessProcessText
_CommitmentItemShortID _CommitmentItemShortID
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CostCenterActivityType _CostCenterActivityType
_CostCenterActivityTypeText _CostCenterActivityTypeText
_CostCenterText _CostCenterText
_FixedAssetWorklist _FixedAssetWorklist
_FunctionalArea _FunctionalArea
_FunctionalAreaText _FunctionalAreaText
_GLAccount _GLAccount
_GLAccountText _GLAccountText
_ProfitCenter _ProfitCenter
_ProfitCenterText _ProfitCenterText
_SalesDocumentScheduleLine _SalesDocumentScheduleLine
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_TaxCode _TaxCode
_TaxCodeText _TaxCodeText
_TaxJurisdiction _TaxJurisdiction
_TaxJurisdictionText _TaxJurisdictionText
_WBSElement _WBSElement
_WBSElementByInternalKey _WBSElementByInternalKey

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_PurOrdAccountAssignmentTP_2.
-- 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_PurOrdAccountAssignmentTP_2 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  CostCenter,
  MasterFixedAsset,
  ProjectNetwork,
  NetworkActivity,
  OrderQuantityUnit,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  DocumentCurrency,
  PurgDocNetAmount,
  IsDeleted,
  GLAccount,
  BusinessArea,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  FixedAsset,
  OrderID,
  UnloadingPointName,
  ControllingArea,
  CostObject,
  ProfitabilitySegment,
  ProfitCenter,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetworkInternalID,
  CommitmentItemShortID,
  FundsCenter,
  Fund,
  FunctionalArea,
  LastChangedDate,
  GoodsRecipientName,
  IsFinallyInvoiced,
  NetworkActivityInternalID,
  PartnerAccountNumber,
  JointVentureRecoveryCode,
  SettlementReferenceDate,
  OrderInternalID,
  OrderIntBillOfOperationsItem,
  TaxCode,
  TaxJurisdiction,
  NonDeductibleInputTaxAmount,
  CostCtrActivityType,
  BusinessProcess,
  GrantID,
  BudgetPeriod,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  ValidityDate,
  ChartOfAccounts,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CreationDate,
  IsAcctLineFinal,
  AcctLineFinalReason,
  CompanyCode
FROM R_PurOrdAccountAssignmentTP
;

Learn More