ICA_CONSJOURNALENTRIES_6C

DDL: ICA_CONSJOURNALENTRIES_6C Type: view_entity
100 Fields 1 Data Sources 1 Associations

ICA: Consolidation Journal Entry Line Items

ICA_CONSJOURNALENTRIES_6C is a CDS View that provides data about "ICA: Consolidation Journal Entry Line Items" in SAP S/4HANA. It reads from 1 data source (ICA_CONSJOURNALENTRIES_6) and exposes 100 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ICA_CONSJOURNALENTRIES_6 ICA_CONSJOURNALENTRIES_6 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CnsldtnFSItem_2 _FSitem $projection.ritclg = _FSitem.ConsolidationChartOfAccounts and $projection.ritem = _FSitem.CnsldtnFinancialStatementItem

Annotations (5)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label ICA: Consolidation Journal Entry Line Items view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view

Fields (100)

KeyFieldSource TableSource FieldDescription
RCLNT RCLNT Client
method_id method_id Validation Method
DOCNR DOCNR Well doc.no.
DOCLN DOCLN Matching Document Line Item
GRREF GRREF Assignment Number
PSTAT PSTAT Processing Status
CSTAT CSTAT Communication Status
DUE_DATE DUE_DATE Net Due Date
CLEARING_STATUS CLEARING_STATUS Status
fiscyearper fiscyearper Period/Year
rldnr rldnr Ledger (Compat.)
rdimen rdimen Dimension
ryear ryear Ref. Year1
gjahr gjahr Settlement Year
ref_belnr ref_belnr Document Number
ref_docln ref_docln G/L Line Item
rrcty rrcty Record Type
BTTYPE BTTYPE Business Transaction Type
drcrk drcrk Debit/Credit
rvers rvers Version: Tax rt
rtcur rtcur Currency
rhcur rhcur Local Currency
rkcur rkcur Ledger curr.
runit runit Unit/Area
poper poper Posting periods
docct docct Document Categ.
rcomp rcomp Trading Partner
rbunit rbunit Consolidation Unit
ritclg ritclg Consolidation COA
ritem ritem Reporting Item
sa_role sa_role FS Item Role
rbuptr rbuptr Partner Unit
rcongr rcongr Consolidation Group
robukrs robukrs Orig. CC
sityp sityp Trip Schedule Type
subit subit Subitem
plevl plevl Posting Level
rtflg rtflg Currency Translation Indicator
docty docty Document Type
blart blart Rep. rec. doc. type
tsl tsl Trans. Currency
hsl hsl Local Crcy Amt
ksl ksl GrpCurr
msl msl Stat. KeyFig. Qty
tsl_csign
hsl_csign
ksl_csign
msl_csign
sgtxt sgtxt Text
budat budat Posting Date
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
awtyp awtyp Reference Document Type
aworg aworg Refer. Org.Unit
ktopl ktopl G/L Chart of Accounts
racct racct GL Account From
zuonr zuonr Finance Project
rcntr rcntr Cost Center
prctr prctr Profit Centers
rfarea rfarea R FuncArea
kokrs kokrs Org. Value
segment segment Segment number
scntr scntr Sender Cost Ctr
pprctr pprctr Partner PC
sfarea sfarea Sender FnArea
rassc rassc Trading Partner
psegment psegment Partner Segment
aufnr aufnr SettlementOrder
kunnr kunnr Stock customer
koart koart Account type
umskz umskz Special G/L Ind
mwskz mwskz Tax Code
xopvw xopvw OI Management
augdt augdt Clearing
augbl augbl Clrng doc.
auggj auggj Clrg Fiscal Yr
lifnr lifnr Vendor no.
matnr matnr Vehicle Model
matkl_mm matkl_mm Material Group
werks werks Receiving Plant
rmvct rmvct Transact. Type
ps_psp_pnr ps_psp_pnr WBS Element
ps_posid ps_posid WBS Element
ps_pspid ps_pspid Project def.
fkart fkart Ship. cost type
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
matnr_copa matnr_copa Product Sold
matkl matkl Product Sold Group
kdgrp kdgrp Customer group
land1 land1 Trip Ctry/Reg
brsch brsch Industry
bzirk bzirk Sales District
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
konzs konzs Group
XREVERSING XREVERSING Reversal doc.
XREVERSED XREVERSED Reversed
awref awref Reference Doc.
AWREF_REV AWREF_REV Reversal Ref.

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 ICA_CONSJOURNALENTRIES_6C.
-- 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 ICA_CONSJOURNALENTRIES_6C AS
SELECT
  RCLNT,
  method_id,
  DOCNR,
  DOCLN,
  GRREF,
  PSTAT,
  CSTAT,
  DUE_DATE,
  CLEARING_STATUS,
  fiscyearper,
  rldnr,
  rdimen,
  ryear,
  gjahr,
  ref_belnr,
  ref_docln,
  rrcty,
  BTTYPE,
  drcrk,
  rvers,
  rtcur,
  rhcur,
  rkcur,
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  sa_role,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rtflg,
  docty,
  blart,
  tsl,
  hsl,
  ksl,
  msl,
  case _FSitem.ConsolidationSignLogicType when 'C' then -tsl else tsl end AS tsl_csign,
  case _FSitem.ConsolidationSignLogicType when 'C' then -hsl else hsl end AS hsl_csign,
  case _FSitem.ConsolidationSignLogicType when 'C' then -ksl else ksl end AS ksl_csign,
  case _FSitem.ConsolidationSignLogicType when 'C' then -msl else msl end AS msl_csign,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  rassc,
  psegment,
  aufnr,
  kunnr,
  koart,
  umskz,
  mwskz,
  xopvw,
  augdt,
  augbl,
  auggj,
  lifnr,
  matnr,
  matkl_mm,
  werks,
  rmvct,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  XREVERSING,
  XREVERSED,
  awref,
  AWREF_REV
FROM ICA_CONSJOURNALENTRIES_6
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _FSitem ON ritclg = _FSitem.ConsolidationChartOfAccounts AND ritem = _FSitem.CnsldtnFinancialStatementItem  -- association [1..1]
;

Learn More