P_BSOrdGLAcctLineItemCube

DDL: P_BSORDGLACCTLINEITEMCUBE Type: view COMPOSITE
57 Fields 1 Data Sources 1 Associations

P_BSOrdGLAcctLineItemCube is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 57 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem, Ledger, SourceLedger. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[1] P_ServiceDocLinItmFinData _BSolnOrdLinItmFinData $projection.BusinessSolutionOrder = _BSolnOrdLinItmFinData.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _BSolnOrdLinItmFinData.BusinessSolutionOrderItem and $projection.SalesOrganization = _BSolnOrdLinItmFinData.SalesOrganization

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PBSGLLINITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY BusinessSolutionOrder ServiceDocument Transaction ID
KEY BusinessSolutionOrderItem ServiceDocumentItem Service Document
KEY Ledger _BSolnOrdLinItmFinData Ledger Ledger
KEY SourceLedger _BSolnOrdLinItmFinData SourceLedger Source Ledger
KEY CompanyCode _BSolnOrdLinItmFinData CompanyCode Receiver Company Code
KEY FiscalYear _BSolnOrdLinItmFinData FiscalYear G/L Fiscal Year
KEY AccountingDocument _BSolnOrdLinItmFinData AccountingDocument Journal Entry
KEY LedgerGLLineItem _BSolnOrdLinItmFinData LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy _BSolnOrdLinItmFinData GLAccountHierarchy
KEY SemanticTag _BSolnOrdLinItmFinData SemanticTag Semantic Tag
KEY ValidityStartDate _BSolnOrdLinItmFinData ValidityStartDate Validity Start Date
KEY ValidityEndDate _BSolnOrdLinItmFinData ValidityEndDate ValidTo
ServiceDocumentItemObjectType ServiceDocumentItemObjectType
BusSolnOrdType ServiceDocumentType Transaction Type
BusSolnOrdDescription ServiceDocumentDescription
BusSolnOrdItmDescription ServiceDocumentItemDescription
BusSolnOrdItmStatus ServiceDocumentItemStatus
BusSolnOrdStatus _ServiceDocument ServiceDocumentStatus
TransactionCurrency TransactionCurrency Transaction Currency
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SoldToParty SoldToParty Sold-to Party
PostingDate _BSolnOrdLinItmFinData PostingDate Posting Date for GR
CompanyCodeCurrency _BSolnOrdLinItmFinData CompanyCodeCurrency Local Currency
RevenueAmountInCompanyCodeCrcy _BSolnOrdLinItmFinData RevenueAmountInCompanyCodeCrcy
CostAmountInCompanyCodeCrcy _BSolnOrdLinItmFinData CostAmountInCompanyCodeCrcy
RecognizedMarginAmtInCCCrcy _BSolnOrdLinItmFinData RecognizedMarginAmtInCCCrcy
FiscalYearVariant _BSolnOrdLinItmFinData FiscalYearVariant FY Variant
FiscalPeriod _BSolnOrdLinItmFinData FiscalPeriod Tax period
FiscalQuarter _BSolnOrdLinItmFinData FiscalQuarter
Product _BSolnOrdLinItmFinData Product Product Sold
_ServiceObjType _ServiceObjType
_Ledger _BSolnOrdLinItmFinData _Ledger
_SourceLedger _BSolnOrdLinItmFinData _SourceLedger
_CompanyCode _BSolnOrdLinItmFinData _CompanyCode
_FiscalYear _BSolnOrdLinItmFinData _FiscalYear
_JournalEntry _BSolnOrdLinItmFinData _JournalEntry
_Hierarchy _BSolnOrdLinItmFinData _Hierarchy
_SemanticTag _BSolnOrdLinItmFinData _SemanticTag
_FiscalYearVariant _BSolnOrdLinItmFinData _FiscalYearVariant
_ServiceDocumentType _ServiceDocumentType
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocumentStatus _ServiceDocument _ServiceDocumentStatus
_SrvcDocLifecycleStatus _ServiceDocument _SrvcDocLifecycleStatus
_TransactionCurrency _TransactionCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_BSolnOrdLinItmFinData _BSolnOrdLinItmFinData

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 P_BSOrdGLAcctLineItemCube.
-- 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 P_BSOrdGLAcctLineItemCube AS
SELECT
  ServiceObjectType,
  ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItem AS BusinessSolutionOrderItem,
  _BSolnOrdLinItmFinData.Ledger AS Ledger,
  _BSolnOrdLinItmFinData.SourceLedger AS SourceLedger,
  _BSolnOrdLinItmFinData.CompanyCode AS CompanyCode,
  _BSolnOrdLinItmFinData.FiscalYear AS FiscalYear,
  _BSolnOrdLinItmFinData.AccountingDocument AS AccountingDocument,
  _BSolnOrdLinItmFinData.LedgerGLLineItem AS LedgerGLLineItem,
  _BSolnOrdLinItmFinData.GLAccountHierarchy AS GLAccountHierarchy,
  _BSolnOrdLinItmFinData.SemanticTag AS SemanticTag,
  _BSolnOrdLinItmFinData.ValidityStartDate AS ValidityStartDate,
  _BSolnOrdLinItmFinData.ValidityEndDate AS ValidityEndDate,
  ServiceDocumentItemObjectType,
  ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentDescription AS BusSolnOrdDescription,
  ServiceDocumentItemDescription AS BusSolnOrdItmDescription,
  ServiceDocumentItemStatus AS BusSolnOrdItmStatus,
  _ServiceDocument.ServiceDocumentStatus AS BusSolnOrdStatus,
  TransactionCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  _BSolnOrdLinItmFinData.PostingDate AS PostingDate,
  _BSolnOrdLinItmFinData.CompanyCodeCurrency AS CompanyCodeCurrency,
  _BSolnOrdLinItmFinData.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInCompanyCodeCrcy,
  _BSolnOrdLinItmFinData.CostAmountInCompanyCodeCrcy AS CostAmountInCompanyCodeCrcy,
  _BSolnOrdLinItmFinData.RecognizedMarginAmtInCCCrcy AS RecognizedMarginAmtInCCCrcy,
  _BSolnOrdLinItmFinData.FiscalYearVariant AS FiscalYearVariant,
  _BSolnOrdLinItmFinData.FiscalPeriod AS FiscalPeriod,
  _BSolnOrdLinItmFinData.FiscalQuarter AS FiscalQuarter,
  _BSolnOrdLinItmFinData.Product AS Product,
  _BSolnOrdLinItmFinData._Ledger AS _Ledger,
  _BSolnOrdLinItmFinData._SourceLedger AS _SourceLedger,
  _BSolnOrdLinItmFinData._CompanyCode AS _CompanyCode,
  _BSolnOrdLinItmFinData._FiscalYear AS _FiscalYear,
  _BSolnOrdLinItmFinData._JournalEntry AS _JournalEntry,
  _BSolnOrdLinItmFinData._Hierarchy AS _Hierarchy,
  _BSolnOrdLinItmFinData._SemanticTag AS _SemanticTag,
  _BSolnOrdLinItmFinData._FiscalYearVariant AS _FiscalYearVariant,
  _ServiceDocument._ServiceDocumentStatus AS _ServiceDocumentStatus,
  _ServiceDocument._SrvcDocLifecycleStatus AS _SrvcDocLifecycleStatus
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN P_ServiceDocLinItmFinData AS _BSolnOrdLinItmFinData ON BusinessSolutionOrder = _BSolnOrdLinItmFinData.BusinessSolutionOrder AND BusinessSolutionOrderItem = _BSolnOrdLinItmFinData.BusinessSolutionOrderItem AND SalesOrganization = _BSolnOrdLinItmFinData.SalesOrganization  -- association [1]
;

Learn More