Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PurgDocAccountAssignmentObj

DDL: C_PURGDOCACCOUNTASSIGNMENTOBJ SQL: CPURGACCASSOBJ Type: view CONSUMPTION
17 Fields 1 Data Sources 3 Associations

Purchasing Document Account Assignments For Object Page

C_PurgDocAccountAssignmentObj is a Consumption CDS View that provides data about "Purchasing Document Account Assignments For Object Page" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignment) and exposes 17 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocAccountAssignment I_PurgDocAccountAssignment from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
[0..1] I_CostCenterText _CostCenterText I_PurgDocAccountAssignment.CostCenter = _CostCenterText.CostCenter and I_PurgDocAccountAssignment.ControllingArea = _CostCenterText.ControllingArea and _CostCenterText.Language = $session.system_language association[0..1] to I_PurchaseOrder as _PurchaseOrder on I_PurgDocAccountAssignment.PurchasingDocument = _PurchaseOrder.PurchaseOrder
[0..1] I_WBSElement _WBSelement I_PurgDocAccountAssignment.WBSElementInternalID = _WBSelement.WBSElementInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURGACCASSOBJ view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchasing Document Account Assignments For Object Page view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurgDocAccountAssignment PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurgDocAccountAssignment PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber I_PurgDocAccountAssignment AccountAssignmentNumber Serial Number
CostCenterName _CostCenterText CostCenterName Name
CostCenter I_PurgDocAccountAssignment CostCenter Cost Center
WBSElement _WBSelement WBSElement WBS Internal ID
Plant _PurchasingDocumentItem Plant Valuation Area
FixedAsset I_PurgDocAccountAssignment MasterFixedAsset Fixed Asset
OrderID I_PurgDocAccountAssignment OrderID Order ID
GLAccount I_PurgDocAccountAssignment GLAccount General Ledger
MultipleAcctAssgmtDistrPercent I_PurgDocAccountAssignment MultipleAcctAssgmtDistrPercent Distribution
OrderQuantityUnit _PurchasingDocumentItem OrderQuantityUnit Sales Unit
Quantity I_PurgDocAccountAssignment Quantity Value
DocumentCurrency _PurchasingDocumentItem DocumentCurrency Document Currency
PurgDocNetAmount I_PurgDocAccountAssignment PurgDocNetAmount Value
_PurchasingDocumentItem _PurchasingDocumentItem
_PurchaseOrder _PurchaseOrder

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 C_PurgDocAccountAssignmentObj.
-- 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: CPURGACCASSOBJ

CREATE VIEW C_PurgDocAccountAssignmentObj AS
SELECT
  I_PurgDocAccountAssignment.PurchasingDocument AS PurchasingDocument,
  I_PurgDocAccountAssignment.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  _CostCenterText.CostCenterName AS CostCenterName,
  I_PurgDocAccountAssignment.CostCenter AS CostCenter,
  _WBSelement.WBSElement AS WBSElement,
  _PurchasingDocumentItem.Plant AS Plant,
  I_PurgDocAccountAssignment.MasterFixedAsset AS FixedAsset,
  I_PurgDocAccountAssignment.OrderID AS OrderID,
  I_PurgDocAccountAssignment.GLAccount AS GLAccount,
  I_PurgDocAccountAssignment.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  _PurchasingDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_PurgDocAccountAssignment.Quantity AS Quantity,
  _PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
  I_PurgDocAccountAssignment.PurgDocNetAmount AS PurgDocNetAmount
FROM I_PurgDocAccountAssignment
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON I_PurgDocAccountAssignment.CostCenter = _CostCenterText.CostCenter AND I_PurgDocAccountAssignment.ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.Language = $session.system_language association[0..1] to I_PurchaseOrder as _PurchaseOrder on I_PurgDocAccountAssignment.PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSelement ON I_PurgDocAccountAssignment.WBSElementInternalID = _WBSelement.WBSElementInternalID  -- association [0..1]
;

Learn More