R_SrvcEntrShtAccrsAccrSubobjTP

DDL: R_SRVCENTRSHTACCRSACCRSUBOBJTP Type: view_entity TRANSACTIONAL
61 Fields 1 Data Sources 3 Associations

Service Entry Sheet Accrual Subobject

R_SrvcEntrShtAccrsAccrSubobjTP is a Transactional CDS View that provides data about "Service Entry Sheet Accrual Subobject" in SAP S/4HANA. It reads from 1 data source (I_SrvcEntrShtAccrsAccrSubobj) and exposes 61 fields with key fields AccrualObjectLogicalSystem, PurchasingDocument, PurchasingDocumentItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrvcEntrShtAccrsAccrSubobj I_SrvcEntrShtAccrsAccrSubobj from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUser $projection.CreatedByUser = _CreatedByUser.ContactCardID
[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
[0..1] R_AccrEngineAccrSubobjItemTP _AccrSubobjItem $projection.AccrualEngineAccrualObjectType = _AccrSubobjItem.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _AccrSubobjItem.AccrualObjectLogicalSystem and $projection.CompanyCode = _AccrSubobjItem.CompanyCode and $projection.AccrualObject = _AccrSubobjItem.AccrualObject and $projection.AccrualSubobject = _AccrSubobjItem.AccrualSubobject

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Service Entry Sheet Accrual Subobject 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 (61)

KeyFieldSource TableSource FieldDescription
KEY AccrualObjectLogicalSystem AccrualObjectLogicalSystem Logical System
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccrualEngineAccrualObjectType AccrualEngineAccrualObjectType Component
CompanyCode CompanyCode Receiver Company Code
AccrualObject AccrualObject External Reference of Accrual Object
AccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrualSubobjectCreatedByUser AccrualSubobjectCreatedByUser
AccrualSubobjectCreationDate AccrualSubobjectCreationDate
AccrSubobjCreationDateTime AccrSubobjCreationDateTime
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
PurgDocExternalItemCategory
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
_AccrCompanyCode _AccrCompanyCode
_AccrLogicalSystem _AccrLogicalSystem
_AccrObj _AccrObj
_AccrObjectType _AccrObjectType
_ControllingArea _ControllingArea
_CreatedByUser _CreatedByUser
_DocumentCurrency _DocumentCurrency
_Material _Material
_MaterialGroup _MaterialGroup
_OrderQuantityUnit _OrderQuantityUnit
_Plant _Plant
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingDocumentItem _PurchasingDocumentItem
_PurchasingGroup _PurchasingGroup
_PurgDocumentItemCategory _PurgDocumentItemCategory
_PurOrdOwner _PurOrdOwner
_Supplier _Supplier
_AccrSubobj _AccrSubobj
_AccrSubobjItem _AccrSubobjItem

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_SrvcEntrShtAccrsAccrSubobjTP.
-- 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_SrvcEntrShtAccrsAccrSubobjTP AS
SELECT
  AccrualObjectLogicalSystem,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccrualEngineAccrualObjectType,
  CompanyCode,
  AccrualObject,
  AccrualSubobject,
  AccrualSubobjectCreatedByUser,
  AccrualSubobjectCreationDate,
  AccrSubobjCreationDateTime,
  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,
  _PurgDocumentItemCategory._Text[1:Language=$session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  NetAmount,
  OrderQuantity,
  OrderQuantityUnit,
  Plant,
  MaterialGroup,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  GoodsReceiptIsNonValuated,
  MaterialType,
  RequisitionerName
FROM I_SrvcEntrShtAccrsAccrSubobj
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- 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]
LEFT OUTER JOIN R_AccrEngineAccrSubobjItemTP AS _AccrSubobjItem ON AccrualEngineAccrualObjectType = _AccrSubobjItem.AccrualEngineAccrualObjectType AND AccrualObjectLogicalSystem = _AccrSubobjItem.AccrualObjectLogicalSystem AND CompanyCode = _AccrSubobjItem.CompanyCode AND AccrualObject = _AccrSubobjItem.AccrualObject AND AccrualSubobject = _AccrSubobjItem.AccrualSubobject  -- association [0..1]
;

Learn More