FARR_LCC_JournalEntryItem

DDL: FARR_LCC_JOURNALENTRYITEM Type: view_entity
11 Fields 3 Data Sources

Revenue Accounting-ACDOCA View for LCC

FARR_LCC_JournalEntryItem is a CDS View that provides data about "Revenue Accounting-ACDOCA View for LCC" in SAP S/4HANA. It reads from 3 data sources (P_ACDOCA, FARR_AcctgPrncpRepLdgrMapping, finsc_ld_cmp) and exposes 11 fields with key fields company_code, hkont, contract_id, pob_id, rldnr.

Data Sources (3)

SourceAliasJoin Type
P_ACDOCA _ACDOCA from
FARR_AcctgPrncpRepLdgrMapping _FARR_MAPPING inner
finsc_ld_cmp _FINSC inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Revenue Accounting-ACDOCA View for LCC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY company_code P_ACDOCA rbukrs Company Code
KEY hkont P_ACDOCA racct GL Account From
KEY contract_id P_ACDOCA ra_contract_id Contract
KEY pob_id P_ACDOCA ra_pob_id POB
KEY rldnr P_ACDOCA rldnr Ledger (Compat.)
KEY gjahr P_ACDOCA gjahr Settlement Year
KEY belnr P_ACDOCA belnr SD Document
KEY docln P_ACDOCA docln Matching Document Line Item
KEY shkzg P_ACDOCA drcrk Debit/Credit
betrh
hwaer

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 FARR_LCC_JournalEntryItem.
-- 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 FARR_LCC_JournalEntryItem AS
SELECT
  _ACDOCA.rbukrs AS company_code,
  _ACDOCA.racct AS hkont,
  _ACDOCA.ra_contract_id AS contract_id,
  _ACDOCA.ra_pob_id AS pob_id,
  _ACDOCA.rldnr AS rldnr,
  _ACDOCA.gjahr AS gjahr,
  _ACDOCA.belnr AS belnr,
  _ACDOCA.docln AS docln,
  _ACDOCA.drcrk AS shkzg,
  cast(_ACDOCA.hsl as farr_amount_lc preserving type) AS betrh,
  cast(_ACDOCA.rhcur as hwaer preserving type) AS hwaer
FROM P_ACDOCA AS _ACDOCA
INNER JOIN finsc_ld_cmp AS _FINSC ON /* join condition not captured in parsed metadata */
INNER JOIN FARR_AcctgPrncpRepLdgrMapping AS _FARR_MAPPING ON /* join condition not captured in parsed metadata */
;

Learn More