I_PurchaseOrderAccrSubobject

DDL: I_PURCHASEORDERACCRSUBOBJECT SQL: IPOACKEY Type: view BASIC
13 Fields 2 Data Sources

PurOrdAccrs: Subobject Keys Mapping

I_PurchaseOrderAccrSubobject is a Basic CDS View that provides data about "PurOrdAccrs: Subobject Keys Mapping" in SAP S/4HANA. It reads from 2 data sources (I_AccrEngineAccrualSubobject, ace_ref_resolver) and exposes 13 fields with key fields AccrualObjectLogicalSystem, PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber.

Data Sources (2)

SourceAliasJoin Type
I_AccrEngineAccrualSubobject _obj from
ace_ref_resolver _ref inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPOACKEY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PurOrdAccrs: Subobject Keys Mapping view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY PurchasingDocument
KEY PurchasingDocumentItem
KEY AccountAssignmentNumber ace_ref_resolver zekkn Account Assgmt No.
AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
CompanyCode CompanyCode Receiver Company Code
AccrualObject AccrualObject External Reference of Accrual Object
AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrSubobjLastChangeDateTime AccrSubobjLastChangeDateTime
_AccrLogicalSystem _AccrLogicalSystem
_AccrObjectType _AccrObjectType
_AccrCompanyCode _AccrCompanyCode
_AccrObj _AccrObj

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_PurchaseOrderAccrSubobject.
-- 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: IPOACKEY

CREATE VIEW I_PurchaseOrderAccrSubobject AS
SELECT
  AccrualObjectLogicalSystem,
  cast( _ref.ebeln as vdm_purchaseorder ) AS PurchasingDocument,
  cast( _ref.ebelp as vdm_purchaseorderitem ) AS PurchasingDocumentItem,
  _ref.zekkn AS AccountAssignmentNumber,
  AccrualEngineAccrualObjectType,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrSubobjLastChangeDateTime
FROM I_AccrEngineAccrualSubobject AS _obj
INNER JOIN ace_ref_resolver AS _ref ON /* join condition not captured in parsed metadata */
;

Learn More