I_CAReconciliationKey

DDL: I_CARECONCILIATIONKEY Type: view_entity BASIC Package: FKK_GLTRANS
31 Fields 1 Data Sources

Reconciliation Key

I_CAReconciliationKey is a Basic CDS View that provides data about "Reconciliation Key" in SAP S/4HANA. It reads from 1 data source (dfkksumc) and exposes 31 fields with key field CAReconciliationKey. Part of development package FKK_GLTRANS.

Data Sources (1)

SourceAliasJoin Type
dfkksumc dfkksumc from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Reconciliation Key view
ObjectModel.representativeKey CAReconciliationKey view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CAReconciliationKey fikey Reconcil. Key
CreatedByUser ernam User Name
CreationDate cpudt Imported On
CAReservationObject resob Reserv. Object
CAReservationKey resky Object Key
CARecnclnKeyAggregationStatus fikvs Aggregation
CARecnclnKeyNmbrOfTotalsRecord sumsz Record counter
CARecnclnKeyIsIncomplete xerro Update Eerror
CARecnclnKeyCorrectionLevel korlv Correct. Level
CARecnclnKeyTrnsfdToGLPostgDte uebis Transfer To
CARecnclnKeyTrnsfdToGLCrrtnLvl ueklv Transf. to corr
CARecnclnKeyIsTransferredToGL xuevo Transfer all
CAReconciliationKeyIsClosed xclos Closed
CARecnclnKeyHasArchivedDocs xarch OrglChange archived
CAReconciliationKeyClosingDate cldat Closed On
CAReconciliationKeyClosingTime cltim P/T type class
ClosedByUser clnam Closed By
CARecnclnKeyLastTransferDate uecpu Last transfer
CANumberOfDocsTransferredToGL blcnt No. of G/L docs
CANumberOfTransfersToPrftAnlys cocnt CO-PA ACC Calls
CARecnclnKeyTrnsfdPrftAnlysSts xuecopa Transfer CO-PA
CARecnclnKeyHasMissingDocs xmiss Totals Incompl.
CARecnclnKeyStsOfDetStructures complete Totals status
CAAdjmtIsAllwdForTransferToGL xextkont Adjustments
ProfitabilitySegment_2 uebpanr Profit. segment
CARecnclnKeyLmtdItemizationSts limitem Limited Itemization
CARecnclnKeyHasCorrection xkorr Corr. with RFKKGL20
CARecnclnKeyBehaviorInRecncln limrecon Reconcil. Behavior
CARecnclnKeyHasDirectTransfer xdirtr Direct Transfer
CARecnclnKeyStsOfTotalsRecords fikst Status
CAProfitabilitySgmtTransfDate uebpadat Date

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 I_CAReconciliationKey.
-- 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 I_CAReconciliationKey AS
SELECT
  fikey AS CAReconciliationKey,
  ernam AS CreatedByUser,
  cpudt AS CreationDate,
  resob AS CAReservationObject,
  resky AS CAReservationKey,
  fikvs AS CARecnclnKeyAggregationStatus,
  sumsz AS CARecnclnKeyNmbrOfTotalsRecord,
  xerro AS CARecnclnKeyIsIncomplete,
  korlv AS CARecnclnKeyCorrectionLevel,
  uebis AS CARecnclnKeyTrnsfdToGLPostgDte,
  ueklv AS CARecnclnKeyTrnsfdToGLCrrtnLvl,
  xuevo AS CARecnclnKeyIsTransferredToGL,
  xclos AS CAReconciliationKeyIsClosed,
  xarch AS CARecnclnKeyHasArchivedDocs,
  cldat AS CAReconciliationKeyClosingDate,
  cltim AS CAReconciliationKeyClosingTime,
  clnam AS ClosedByUser,
  uecpu AS CARecnclnKeyLastTransferDate,
  blcnt AS CANumberOfDocsTransferredToGL,
  cocnt AS CANumberOfTransfersToPrftAnlys,
  xuecopa AS CARecnclnKeyTrnsfdPrftAnlysSts,
  xmiss AS CARecnclnKeyHasMissingDocs,
  complete AS CARecnclnKeyStsOfDetStructures,
  xextkont AS CAAdjmtIsAllwdForTransferToGL,
  uebpanr AS ProfitabilitySegment_2,
  limitem AS CARecnclnKeyLmtdItemizationSts,
  xkorr AS CARecnclnKeyHasCorrection,
  limrecon AS CARecnclnKeyBehaviorInRecncln,
  xdirtr AS CARecnclnKeyHasDirectTransfer,
  fikst AS CARecnclnKeyStsOfTotalsRecords,
  uebpadat AS CAProfitabilitySgmtTransfDate
FROM dfkksumc
;

Learn More