APS_V_AGV_DEP_TAB

DDL: APS_V_AGV_DEP_TAB SQL: AGVDEPTAB Type: view
11 Fields 1 Data Sources

View on DCDEPTB4LOG

APS_V_AGV_DEP_TAB is a CDS View that provides data about "View on DCDEPTB4LOG" in SAP S/4HANA. It reads from 1 data source (dcdeptb4log) and exposes 11 fields with key fields hex_uuid, uuid, from_type, from_name, from_level.

Data Sources (1)

SourceAliasJoin Type
dcdeptb4log dcdeptb4log from

Parameters (1)

NameTypeDefault
p_uuid abap.raw(16)

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName AGVDEPTAB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View on DCDEPTB4LOG view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY hex_uuid
KEY uuid uuid Waste Partner UUID
KEY from_type deptype Object type
KEY from_name depname Object name
KEY from_level
KEY to_type type Worklist Type
KEY to_name name Zone name
KEY to_level
KEY depkind depkind DD: type of a relationship
KEY sequence sequence Visit Sequence
action action User action

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 APS_V_AGV_DEP_TAB.
-- 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: AGVDEPTAB
-- Parameters: p_uuid : abap.raw(16)

CREATE VIEW APS_V_AGV_DEP_TAB AS
SELECT
  bintohex(uuid) AS hex_uuid,
  uuid,
  deptype AS from_type,
  depname AS from_name,
  -1 AS from_level,
  type AS to_type,
  name AS to_name,
  -1 AS to_level,
  depkind,
  sequence,
  action
FROM dcdeptb4log
;

Learn More