R_CostRevnProfitabilitySegment

DDL: R_COSTREVNPROFITABILITYSEGMENT Type: view_entity COMPOSITE
35 Fields 2 Data Sources

Cost Revenue Reassignment Profitability Segment

R_CostRevnProfitabilitySegment is a Composite CDS View that provides data about "Cost Revenue Reassignment Profitability Segment" in SAP S/4HANA. It reads from 2 data sources (I_AccountAssignmentType, I_GLAccountLineItemRawData) and exposes 35 fields with key fields FiscalYear, ReferenceDocument, ControllingArea, LedgerGLLineItem, ReferenceDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_AccountAssignmentType _AccountAssignmentType inner
I_GLAccountLineItemRawData _Item from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Cost Revenue Reassignment Profitability Segment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY ReferenceDocument
KEY ControllingArea I_GLAccountLineItemRawData ControllingArea Controlling Area
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY ReferenceDocumentItem I_GLAccountLineItemRawData ReferenceDocumentItem Reference item
CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
ReferenceDocumentType I_GLAccountLineItemRawData ReferenceDocumentType Reference Document Type
AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
ReferenceDocumentContext I_GLAccountLineItemRawData ReferenceDocumentContext Reference Document Context
TransactionSubitem I_GLAccountLineItemRawData TransactionSubitem Sub Transaction
ControllingDocumentItem I_GLAccountLineItemRawData ControllingDocumentItem Controlling Doc Item
SourceLedger I_GLAccountLineItemRawData SourceLedger Source Ledger
Customer I_GLAccountLineItemRawData Customer Sold-to Party
CustomerGroup I_GLAccountLineItemRawData CustomerGroup Customer Group
CustomerSupplierIndustry I_GLAccountLineItemRawData CustomerSupplierIndustry Industry
CustomerSupplierCountry I_GLAccountLineItemRawData CustomerSupplierCountry Customer or Supplier Country/Region
SalesDistrict I_GLAccountLineItemRawData SalesDistrict Sales District
SoldProduct I_GLAccountLineItemRawData SoldProduct Product Sold
SoldProductGroup I_GLAccountLineItemRawData SoldProductGroup Product Sold Group
SalesOrganization I_GLAccountLineItemRawData SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItemRawData DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_GLAccountLineItemRawData OrganizationDivision Org. Division
BillToParty I_GLAccountLineItemRawData BillToParty Inv. Recipient
ShipToParty I_GLAccountLineItemRawData ShipToParty Ship-To Party (obsolete)
WBSElementInternalID I_GLAccountLineItemRawData WBSElementInternalID WBS Internal ID
WBSElementExternalID
ServiceDocumentType I_GLAccountLineItemRawData ServiceDocumentType Transaction Type
ServiceDocument I_GLAccountLineItemRawData ServiceDocument Transaction ID
ServiceDocumentItem I_GLAccountLineItemRawData ServiceDocumentItem Service Document
FunctionalArea I_GLAccountLineItemRawData FunctionalArea Sendr Fctl Area
PartnerCompanyCode I_GLAccountLineItemRawData PartnerCompanyCode Partner Company Code
ControllingBusTransacType I_GLAccountLineItemRawData ControllingBusTransacType CO Bus. Transaction
BusinessTransactionCategory I_GLAccountLineItemRawData BusinessTransactionCategory Business Transaction Category
OriginCtrlgDebitCreditCode
DebitCreditCode I_GLAccountLineItemRawData DebitCreditCode Single-Character Flag

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_CostRevnProfitabilitySegment.
-- 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_CostRevnProfitabilitySegment AS
SELECT
  _Item.FiscalYear AS FiscalYear,
  cast(_Item.ReferenceDocument as referencedocument preserving type) AS ReferenceDocument,
  _Item.ControllingArea AS ControllingArea,
  _Item.LedgerGLLineItem AS LedgerGLLineItem,
  _Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Item.CompanyCode AS CompanyCode,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.ReferenceDocumentContext AS ReferenceDocumentContext,
  _Item.TransactionSubitem AS TransactionSubitem,
  _Item.ControllingDocumentItem AS ControllingDocumentItem,
  _Item.SourceLedger AS SourceLedger,
  _Item.Customer AS Customer,
  _Item.CustomerGroup AS CustomerGroup,
  _Item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Item.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Item.SalesDistrict AS SalesDistrict,
  _Item.SoldProduct AS SoldProduct,
  _Item.SoldProductGroup AS SoldProductGroup,
  _Item.SalesOrganization AS SalesOrganization,
  _Item.DistributionChannel AS DistributionChannel,
  _Item.OrganizationDivision AS OrganizationDivision,
  _Item.BillToParty AS BillToParty,
  _Item.ShipToParty AS ShipToParty,
  _Item.WBSElementInternalID AS WBSElementInternalID,
  cast(_Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type) AS WBSElementExternalID,
  _Item.ServiceDocumentType AS ServiceDocumentType,
  _Item.ServiceDocument AS ServiceDocument,
  _Item.ServiceDocumentItem AS ServiceDocumentItem,
  _Item.FunctionalArea AS FunctionalArea,
  _Item.PartnerCompanyCode AS PartnerCompanyCode,
  _Item.ControllingBusTransacType AS ControllingBusTransacType,
  _Item.BusinessTransactionCategory AS BusinessTransactionCategory,
  cast(_Item.OriginCtrlgDebitCreditCode as beknz_mask preserving type ) AS OriginCtrlgDebitCreditCode,
  _Item.DebitCreditCode AS DebitCreditCode
FROM I_GLAccountLineItemRawData AS _Item
INNER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON /* join condition not captured in parsed metadata */
;

Learn More