VC_INTEGRATION_DD03L

DDL: VC_INTEGRATION_DD03L SQL: VCIDD03L Type: view Package: CPS_DATA_REPLICATION
31 Fields 1 Data Sources

Extraction for DD03L

VC_INTEGRATION_DD03L is a CDS View that provides data about "Extraction for DD03L" in SAP S/4HANA. It reads from 1 data source (t681) and exposes 31 fields with key fields TABNAME, FIELDNAME, AS4LOCAL, AS4VERS, POSITION. Part of development package CPS_DATA_REPLICATION.

Data Sources (1)

SourceAliasJoin Type
t681 t681 left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VCIDD03L view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #META view
Analytics.dataExtraction.enabled true view
EndUserText.label Extraction for DD03L view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY TABNAME tabname Table/Constant Value
KEY FIELDNAME fieldname UI Group FieldName
KEY AS4LOCAL as4local Activation State
KEY AS4VERS as4vers Version
KEY POSITION position Test Position
KEYFLAG keyflag Key field
MANDATORY mandatory Yes/No
ROLLNAME rollname Repr. Data Elem
CHECKTABLE checktable Table Name
ADMINFIELD adminfield Admin. field
INTTYPE inttype Interest Type
INTLEN intlen Length
REFTABLE reftable Reference table
PRECFIELD precfield Name of include
REFFIELD reffield Reference field
CONROUT conrout Check module
NOTNULL notnull NOT NULL forced
DATATYPE datatype Field Type
LENG leng No. of Characters
DECIMALS decimals Rounding Places
DOMNAME domname Domain
SHLPORIGIN shlporigin Origin
TABLETYPE tabletype Table
DEPTH depth Draught
COMPTYPE comptype Type of a reporting component
REFTYPE reftype Reference Type
LANGUFLAG languflag Text Lang.
DBPOSITION dbposition Table position
ANONYMOUS anonymous Anonymous
OUTPUTSTYLE outputstyle Output
SRS_ID srs_id SRS ID

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_DD03L.
-- 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: VCIDD03L

CREATE VIEW VC_INTEGRATION_DD03L AS
SELECT
  TABNAME,
  FIELDNAME,
  AS4LOCAL,
  AS4VERS,
  POSITION,
  KEYFLAG,
  MANDATORY,
  ROLLNAME,
  CHECKTABLE,
  ADMINFIELD,
  INTTYPE,
  INTLEN,
  REFTABLE,
  PRECFIELD,
  REFFIELD,
  CONROUT,
  NOTNULL,
  DATATYPE,
  LENG,
  DECIMALS,
  DOMNAME,
  SHLPORIGIN,
  TABLETYPE,
  DEPTH,
  COMPTYPE,
  REFTYPE,
  LANGUFLAG,
  DBPOSITION,
  ANONYMOUS,
  OUTPUTSTYLE,
  SRS_ID
LEFT OUTER JOIN t681 ON /* join condition not captured in parsed metadata */
;

Learn More