R_SetlMgmtUnivJrnlEntrBizVol

DDL: R_SETLMGMTUNIVJRNLENTRBIZVOL Type: view_entity BASIC
43 Fields 2 Data Sources

ACDOCA entries for Business Volume

R_SetlMgmtUnivJrnlEntrBizVol is a Basic CDS View that provides data about "ACDOCA entries for Business Volume" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItemRawData, I_Ledger) and exposes 43 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItemRawData JournalEntry from
I_Ledger Ledger inner

Annotations (9)

NameValueLevelField
EndUserText.label ACDOCA entries for Business Volume view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
AccountingDocumentItem I_GLAccountLineItemRawData AccountingDocumentItem Posting View Item
ReferenceDocumentType I_GLAccountLineItemRawData ReferenceDocumentType Reference Document Type
LogicalSystem I_GLAccountLineItemRawData LogicalSystem Logical System
ReferenceDocumentContext I_GLAccountLineItemRawData ReferenceDocumentContext Reference Document Context
ReferenceDocument I_GLAccountLineItemRawData ReferenceDocument Reference Document
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
AccountingDocumentType I_GLAccountLineItemRawData AccountingDocumentType Journal Entry Type
ControllingBusTransacType I_GLAccountLineItemRawData ControllingBusTransacType CO Bus. Transaction
AssignmentReference I_GLAccountLineItemRawData AssignmentReference Assignment Reference
LastChangeDateTime I_GLAccountLineItemRawData LastChangeDateTime Timestamp
AmountInTransactionCurrency I_GLAccountLineItemRawData AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency I_GLAccountLineItemRawData TransactionCurrency Transaction Currency
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAccountLineItemRawData AmountInCompanyCodeCurrency Local Crcy Amt
ControllingObjectCurrency I_GLAccountLineItemRawData ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency I_GLAccountLineItemRawData AmountInObjectCurrency Amount in Obj Crcy
AccountAssignmentType I_GLAccountLineItemRawData AccountAssignmentType Sndr AcctAssgmt Type
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
OriginCostCtrActivityType I_GLAccountLineItemRawData OriginCostCtrActivityType OrigAct.
CostCenter I_GLAccountLineItemRawData CostCenter Cost Center
ProfitCenter I_GLAccountLineItemRawData ProfitCenter Profit Center
OrderID I_GLAccountLineItemRawData OrderID Order ID
WBSElementInternalID I_GLAccountLineItemRawData WBSElementInternalID WBS Internal ID
FunctionalArea I_GLAccountLineItemRawData FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItemRawData BusinessArea Business Area
PartnerCostCenter I_GLAccountLineItemRawData PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter I_GLAccountLineItemRawData PartnerProfitCenter Profit Center
PartnerBusinessArea I_GLAccountLineItemRawData PartnerBusinessArea Trdg Part.BA
PartnerFunctionalArea I_GLAccountLineItemRawData PartnerFunctionalArea Rec. Fntcl Area
PartnerOrder I_GLAccountLineItemRawData PartnerOrder Partner Order
PartnerWBSElementInternalID I_GLAccountLineItemRawData PartnerWBSElementInternalID Partner WBS Element Internal ID
PartnerCompanyCode I_GLAccountLineItemRawData PartnerCompanyCode Partner Company Code
DocumentItemText I_GLAccountLineItemRawData DocumentItemText Text
Product I_GLAccountLineItemRawData SoldProduct Product Sold
SalesDocument I_GLAccountLineItemRawData SalesDocument SD Document
SalesDocumentItem I_GLAccountLineItemRawData SalesDocumentItem Sales Document Item
ConditionContract I_GLAccountLineItemRawData ConditionContract Condition Contract

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_SetlMgmtUnivJrnlEntrBizVol.
-- 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_SetlMgmtUnivJrnlEntrBizVol AS
SELECT
  JournalEntry.SourceLedger AS SourceLedger,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntry.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.LogicalSystem AS LogicalSystem,
  JournalEntry.ReferenceDocumentContext AS ReferenceDocumentContext,
  JournalEntry.ReferenceDocument AS ReferenceDocument,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.ControllingBusTransacType AS ControllingBusTransacType,
  JournalEntry.AssignmentReference AS AssignmentReference,
  JournalEntry.LastChangeDateTime AS LastChangeDateTime,
  JournalEntry.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntry.ControllingObjectCurrency AS ControllingObjectCurrency,
  JournalEntry.AmountInObjectCurrency AS AmountInObjectCurrency,
  JournalEntry.AccountAssignmentType AS AccountAssignmentType,
  JournalEntry.GLAccount AS GLAccount,
  JournalEntry.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  JournalEntry.CostCenter AS CostCenter,
  JournalEntry.ProfitCenter AS ProfitCenter,
  JournalEntry.OrderID AS OrderID,
  JournalEntry.WBSElementInternalID AS WBSElementInternalID,
  JournalEntry.FunctionalArea AS FunctionalArea,
  JournalEntry.BusinessArea AS BusinessArea,
  JournalEntry.PartnerCostCenter AS PartnerCostCenter,
  JournalEntry.PartnerProfitCenter AS PartnerProfitCenter,
  JournalEntry.PartnerBusinessArea AS PartnerBusinessArea,
  JournalEntry.PartnerFunctionalArea AS PartnerFunctionalArea,
  JournalEntry.PartnerOrder AS PartnerOrder,
  JournalEntry.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  JournalEntry.PartnerCompanyCode AS PartnerCompanyCode,
  JournalEntry.DocumentItemText AS DocumentItemText,
  JournalEntry.SoldProduct AS Product,
  JournalEntry.SalesDocument AS SalesDocument,
  JournalEntry.SalesDocumentItem AS SalesDocumentItem,
  JournalEntry.ConditionContract AS ConditionContract
FROM I_GLAccountLineItemRawData AS JournalEntry
INNER JOIN I_Ledger AS Ledger ON /* join condition not captured in parsed metadata */
;

Learn More