R_PurOrdAccrsAccrSubobjectTP

DDL: R_PURORDACCRSACCRSUBOBJECTTP Type: view_entity TRANSACTIONAL
75 Fields 1 Data Sources 3 Associations

Purchase Order Accrual Subobject

R_PurOrdAccrsAccrSubobjectTP is a Transactional CDS View that provides data about "Purchase Order Accrual Subobject" in SAP S/4HANA. It reads from 1 data source (I_PurOrdAccrsAccrSubobject) and exposes 75 fields with key fields AccrualObjectLogicalSystem, PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdAccrsAccrSubobject I_PurOrdAccrsAccrSubobject from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUser $projection.CreatedByUser = _CreatedByUser.ContactCardID
[0..1] I_ProductTypeCode _ProductType $projection.PurgDocProductType = _ProductType.ProductTypeCode
[0..1] R_AccrEngineAccrualSubobjectTP _AccrSubobj $projection.AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _AccrSubobj.AccrualObjectLogicalSystem and $projection.CompanyCode = _AccrSubobj.CompanyCode and $projection.AccrualObject = _AccrSubobj.AccrualObject and $projection.AccrualSubobject = _AccrSubobj.AccrualSubobject

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order Accrual Subobject view
ObjectModel.sapObjectNodeType.name AccrualObject view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber AccountAssignmentNumber 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
CompanyCodeName CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area
ValidityDate ValidityDate Valid On
PurchaseOrderOwner PurchaseOrderOwner
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
DocumentCurrency DocumentCurrency Document Currency
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingDocumentOrderDate PurchasingDocumentOrderDate PO Date
CreationDate CreationDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByUser FullName Name
Supplier Supplier Supplier
Material Material Vehicle Model
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurgDocItemCategoryName
PurgDocProductType ProductType Product Type Group
NetAmount NetAmount Stated Amount
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
Plant Plant Valuation Area
MaterialGroup MaterialGroup Product Group
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
MaterialType MaterialType Material Type
RequisitionerName RequisitionerName Requisitioner
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
GoodsRecepientName GoodsRecepientName
ProjectNetwork ProjectNetwork Order
NetworkActivityInternalID NetworkActivityInternalID Counter
_AccrCompanyCode _AccrCompanyCode
_AccrLogicalSystem _AccrLogicalSystem
_AccrObj _AccrObj
_AccrObjectType _AccrObjectType
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CreatedByUser _CreatedByUser
_DocumentCurrency _DocumentCurrency
_GLAccount _GLAccount
_Material _Material
_MaterialGroup _MaterialGroup
_Network _Network
_NetworkActivity _NetworkActivity
_OrderQuantityUnit _OrderQuantityUnit
_Plant _Plant
_ProductType _ProductType
_ProfitCenter _ProfitCenter
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingDocumentItem _PurchasingDocumentItem
_PurchasingGroup _PurchasingGroup
_PurgDocAccountAssignment _PurgDocAccountAssignment
_PurgDocumentItemCategory _PurgDocumentItemCategory
_PurOrdOwner _PurOrdOwner
_Supplier _Supplier
_WBSElementBasicData _WBSElementBasicData
_AccrSubobj _AccrSubobj

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_PurOrdAccrsAccrSubobjectTP.
-- 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 R_PurOrdAccrsAccrSubobjectTP AS
SELECT
  AccrualObjectLogicalSystem,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  AccrualEngineAccrualObjectType,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  CompanyCodeName,
  ControllingArea,
  ValidityDate,
  PurchaseOrderOwner,
  PurchasingDocumentCategory,
  DocumentCurrency,
  PurchasingGroup,
  PurchasingDocumentOrderDate,
  CreationDate,
  LastChangeDateTime,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserName,
  Supplier,
  Material,
  PurchasingDocumentItemText,
  PurchasingDocumentItemCategory,
  _PurgDocumentItemCategory._Text[1:Language=$session.system_language].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  ProductType AS PurgDocProductType,
  NetAmount,
  OrderQuantity,
  OrderQuantityUnit,
  Plant,
  MaterialGroup,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  GoodsReceiptIsNonValuated,
  MaterialType,
  RequisitionerName,
  ProfitCenter,
  CostCenter,
  GLAccount,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  GoodsRecepientName,
  ProjectNetwork,
  NetworkActivityInternalID
FROM I_PurOrdAccrsAccrSubobject
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON PurgDocProductType = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN R_AccrEngineAccrualSubobjectTP AS _AccrSubobj ON AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrSubobj.AccrualObjectLogicalSystem AND CompanyCode = _AccrSubobj.CompanyCode AND AccrualObject = _AccrSubobj.AccrualObject AND AccrualSubobject = _AccrSubobj.AccrualSubobject  -- association [0..1]
;

Learn More