VC_INTEGRATION_TCLA

DDL: VC_INTEGRATION_TCLA SQL: VCITCLA Type: view Package: IPS_DATA_REPLICATION

Extraction for TCLA

VC_INTEGRATION_TCLA is a CDS View that provides data about "Extraction for TCLA" in SAP S/4HANA. It reads from 1 data source (tcla) and exposes 28 fields with key field KLART. Part of development package IPS_DATA_REPLICATION.

Data Sources (1)

SourceAliasJoin Type
tcla tcla from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCITCLA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for TCLA view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY KLART klart Class Type
OBTAB obtab Table
SWOFL swofl Keywords
SMEFL smefl Characteristics
DOKFL dokfl Documents
TXTFL txtfl Texts
DINFL dinfl Stds data
STAND stand Std Class Type
MFKLS mfkls Multiple class.
TRACL tracl Master record
VARKLART varklart Var. class type
MULTOBJ multobj Multiple objs
KONFOBJ konfobj Config. object
INTKLART intklart Int. class type
AEBLGZUORD aeblgzuord Change Docs
AEDIEZUORD aediezuord ECH (time)
MIGRATION migration Migrated Payments
HIERARCHIE hierarchie Hier. allowed
AUSP_NEW ausp_new AUSP new
EFFE_ACT effe_act ECH (parameter)
EFFE_DATUM effe_datum Date
AEDIKZCLS aedikzcls ECH (time)
AEDICLSCREATE aediclscreate ECH create
AEDICLSCHANGE aediclschange ECH change
AEDICHGCRE aedichgcre ECH create/change
AEDICLSFROMSTATU aediclsfromstatu ECH from status
AEDIFROMSTATUS aedifromstatus ECH from status
AUSP_GEN ausp_gen Gen. tables

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 VC_INTEGRATION_TCLA.
-- 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.
-- SQL view name: VCITCLA

CREATE VIEW VC_INTEGRATION_TCLA AS
SELECT
  KLART,
  OBTAB,
  SWOFL,
  SMEFL,
  DOKFL,
  TXTFL,
  DINFL,
  STAND,
  MFKLS,
  TRACL,
  VARKLART,
  MULTOBJ,
  KONFOBJ,
  INTKLART,
  AEBLGZUORD,
  AEDIEZUORD,
  MIGRATION,
  HIERARCHIE,
  AUSP_NEW,
  EFFE_ACT,
  EFFE_DATUM,
  AEDIKZCLS,
  AEDICLSCREATE,
  AEDICLSCHANGE,
  AEDICHGCRE,
  AEDICLSFROMSTATU,
  AEDIFROMSTATUS,
  AUSP_GEN
FROM tcla
;