I_SrvcEntrShtAccrSubobject

DDL: I_SRVCENTRSHTACCRSUBOBJECT SQL: ISESACKEY Type: view BASIC
15 Fields 1 Data Sources

Service Entry Sheet Accruals

I_SrvcEntrShtAccrSubobject is a Basic CDS View that provides data about "Service Entry Sheet Accruals" in SAP S/4HANA. It reads from 1 data source (I_AccrEngineAccrualSubobject) and exposes 15 fields with key fields AccrualObjectLogicalSystem, PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_AccrEngineAccrualSubobject _obj from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISESACKEY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Service Entry Sheet Accruals 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 (15)

KeyFieldSource TableSource FieldDescription
KEY AccrualObjectLogicalSystem I_AccrEngineAccrualSubobject AccrualObjectLogicalSystem Logical System
KEY PurchasingDocument
KEY PurchasingDocumentItem
AccrualEngineAccrualObjectType I_AccrEngineAccrualSubobject AccrualEngineAccrualObjectType Component
CompanyCode I_AccrEngineAccrualSubobject CompanyCode Receiver Company Code
AccrualObject I_AccrEngineAccrualSubobject AccrualObject External Reference of Accrual Object
AccrualSubobject I_AccrEngineAccrualSubobject AccrualSubobject External Reference of Accrual Subobject
AccrualSubobjectCreatedByUser I_AccrEngineAccrualSubobject AccrualSubobjectCreatedByUser User Name
AccrualSubobjectCreationDate I_AccrEngineAccrualSubobject AccrualSubobjectCreationDate Time Stamp
AccrSubobjCreationDateTime I_AccrEngineAccrualSubobject AccrSubobjCreationDateTime
AccrSubobjLastChangeDateTime I_AccrEngineAccrualSubobject AccrSubobjLastChangeDateTime
_AccrLogicalSystem I_AccrEngineAccrualSubobject _AccrLogicalSystem
_AccrObjectType I_AccrEngineAccrualSubobject _AccrObjectType
_AccrCompanyCode I_AccrEngineAccrualSubobject _AccrCompanyCode
_AccrObj I_AccrEngineAccrualSubobject _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_SrvcEntrShtAccrSubobject.
-- 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: ISESACKEY

CREATE VIEW I_SrvcEntrShtAccrSubobject AS
SELECT
  _obj.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  cast( _ref.ebeln as vdm_purchaseorder ) AS PurchasingDocument,
  cast( _ref.ebelp as vdm_purchaseorderitem ) AS PurchasingDocumentItem,
  _obj.AccrualEngineAccrualObjectType AS AccrualEngineAccrualObjectType,
  _obj.CompanyCode AS CompanyCode,
  _obj.AccrualObject AS AccrualObject,
  _obj.AccrualSubobject AS AccrualSubobject,
  _obj.AccrualSubobjectCreatedByUser AS AccrualSubobjectCreatedByUser,
  _obj.AccrualSubobjectCreationDate AS AccrualSubobjectCreationDate,
  _obj.AccrSubobjCreationDateTime AS AccrSubobjCreationDateTime,
  _obj.AccrSubobjLastChangeDateTime AS AccrSubobjLastChangeDateTime,
  _obj._AccrLogicalSystem AS _AccrLogicalSystem,
  _obj._AccrObjectType AS _AccrObjectType,
  _obj._AccrCompanyCode AS _AccrCompanyCode,
  _obj._AccrObj AS _AccrObj
FROM I_AccrEngineAccrualSubobject AS _obj
;

Learn More