C_PurOrdAccrsAccrSubobjectTP

DDL: C_PURORDACCRSACCRSUBOBJECTTP SQL: CPOACSOTP Type: view_entity CONSUMPTION
76 Fields 1 Data Sources

Purchase Order Accrual Subobject

C_PurOrdAccrsAccrSubobjectTP is a Consumption CDS View that provides data about "Purchase Order Accrual Subobject" in SAP S/4HANA. It reads from 1 data source (R_PurOrdAccrsAccrSubobjectTP) and exposes 76 fields with key fields AccrualObjectLogicalSystem, PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber.

Data Sources (1)

SourceAliasJoin Type
R_PurOrdAccrsAccrSubobjectTP R_PurOrdAccrsAccrSubobjectTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order Accrual Subobject view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (76)

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
PurchasingDocumentCategoryNamelocalized
DocumentCurrency DocumentCurrency Document Currency
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingDocumentOrderDate PurchasingDocumentOrderDate PO Date
CreationDate CreationDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialNamelocalized
PurchasingDocumentItemText PurchasingDocumentItemText Short Text
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurgDocItemCategoryName PurgDocItemCategoryName Text for ItCat.
PurgDocProductType PurgDocProductType 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

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_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.
-- SQL view name: CPOACSOTP

CREATE VIEW C_PurOrdAccrsAccrSubobjectTP AS
SELECT
  AccrualObjectLogicalSystem,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  AccrualEngineAccrualObjectType,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  CompanyCodeName,
  ControllingArea,
  ValidityDate,
  PurchaseOrderOwner,
  PurchasingDocumentCategory,
  _PurchasingDocumentCategory._Text.PurchasingDocumentCategoryName : localized AS PurchasingDocumentCategoryNamelocalized,
  DocumentCurrency,
  PurchasingGroup,
  PurchasingDocumentOrderDate,
  CreationDate,
  LastChangeDateTime,
  CreatedByUser,
  CreatedByUserName,
  Supplier,
  Material,
  _Material._Text.MaterialName : localized AS MaterialNamelocalized,
  PurchasingDocumentItemText,
  PurchasingDocumentItemCategory,
  PurgDocItemCategoryName,
  PurgDocProductType,
  NetAmount,
  OrderQuantity,
  OrderQuantityUnit,
  Plant,
  MaterialGroup,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  GoodsReceiptIsNonValuated,
  MaterialType,
  RequisitionerName,
  ProfitCenter,
  CostCenter,
  GLAccount,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  GoodsRecepientName,
  ProjectNetwork,
  NetworkActivityInternalID
FROM R_PurOrdAccrsAccrSubobjectTP
;

Learn More