I_SrvcContrGLAcctLineItmCube_2

DDL: I_SRVCCONTRGLACCTLINEITMCUBE_2 Type: view COMPOSITE
79 Fields 1 Data Sources 1 Associations

GL Account Item for Srvc Contract - Cube

I_SrvcContrGLAcctLineItmCube_2 is a Composite CDS View (Cube) that provides data about "GL Account Item for Srvc Contract - Cube" in SAP S/4HANA. It reads from 1 data source (P_SrvcContrLinItmFinConvData) and exposes 79 fields with key fields ServiceContract, ServiceContractItem, SemanticTag, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SrvcContrLinItmFinConvData P_SrvcContrLinItmFinConvData from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocumentItem _ServiceDocItemExt $projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceContract = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceContractItem = _ServiceDocItemExt.ServiceLineExternalID

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCCONTRGLCUB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label GL Account Item for Srvc Contract - Cube view
Metadata.allowExtensions true view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY SemanticTag SemanticTag Semantic Tag
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
CalendarYear CalendarYear Year
CalendarWeek CalendarWeek Calendar Week
ServiceObjectType ServiceObjectType Object Type
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
ServiceContractDescription ServiceContractDescription
ServiceContractType ServiceContractType Transaction Type
RefBusinessSolutionOrder RefBusinessSolutionOrder
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
SoldToPartyFullName SoldToPartyFullName
BusinessPartnerFullName SoldToPartyFullName
ShipToParty ShipToParty Ship-To Party (obsolete)
ResponsibleEmployee ResponsibleEmployee Employee Resp.
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
ContactPersonBusinessPartnerId ContactPerson Contact Person Key
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DisplayCurrency DisplayCurrency Display Currency
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
TotalSrvcContrValueInDC TotalSrvcContrValueInDC
RevenueAmountInDisplayCrcy RevenueAmountInDisplayCrcy
CostAmountInDisplayCurrency CostAmountInDisplayCurrency
SrvcContrProfitabilityInDC SrvcContrProfitabilityInDC
YTDSrvcContrPrftMarginAmtInDC YTDSrvcContrPrftMarginAmtInDC
YTDSrvcContrRevnAmtInDC YTDSrvcContrRevnAmtInDC
YTDSrvcContrCostInDC YTDSrvcContrCostInDC
NumberOfDays NumberOfDays Number of Days
ServiceDocumentIsOpen ServiceDocumentIsOpen
ServiceDocumentItemCanclnParty ServiceDocumentItemCanclnParty
ServiceDocumentItmCanclnReason ServiceDocumentItmCanclnReason
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_SoldToPartyRegion _SoldToPartyRegion
_RespEmployee _RespEmployee
_CompanyCodeCurrency _CompanyCodeCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceObjectType _ServiceObjectType
_JournalEntry _JournalEntry
_SemanticTag _SemanticTag
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_SoldToPartyCountry _SoldToPartyCountry
_SoldToParty _SoldToParty
_RespEmployeeID _RespEmployeeID
_ContactPerson _ContactPerson
_ShipToParty _ShipToParty
_SolutionOrderVH _SolutionOrderVH

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_SrvcContrGLAcctLineItmCube_2.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_SrvcContrGLAcctLineItmCube_2 AS
SELECT
  ServiceContract,
  ServiceContractItem,
  SemanticTag,
  AccountingDocument,
  LedgerGLLineItem,
  CompanyCode,
  FiscalYear,
  CalendarYear,
  CalendarWeek,
  ServiceObjectType,
  CalendarQuarter,
  CalendarMonth,
  ServiceContractDescription,
  ServiceContractType,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  SoldToPartyFullName,
  SoldToPartyFullName AS BusinessPartnerFullName,
  ShipToParty,
  ResponsibleEmployee,
  RespEmployeeBusinessPartnerId,
  ContactPerson AS ContactPersonBusinessPartnerId,
  CreationDate,
  PostingDate,
  CompanyCodeCurrency,
  DisplayCurrency,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  TotalSrvcContrValueInDC,
  RevenueAmountInDisplayCrcy,
  CostAmountInDisplayCurrency,
  SrvcContrProfitabilityInDC,
  YTDSrvcContrPrftMarginAmtInDC,
  YTDSrvcContrRevnAmtInDC,
  YTDSrvcContrCostInDC,
  NumberOfDays,
  ServiceDocumentIsOpen,
  ServiceDocumentItemCanclnParty,
  ServiceDocumentItmCanclnReason
FROM P_SrvcContrLinItmFinConvData
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceContract = _ServiceDocItemExt.ServiceOrderItem AND ServiceContractItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;

Learn More