APS_V_AGV_NODES

DDL: APS_V_AGV_NODES SQL: AGVNODES Type: view Package: S_APS_ODATA_REPAIR_CDS_APP
15 Fields 1 Data Sources

View on DCGENTB4LOG

APS_V_AGV_NODES is a CDS View that provides data about "View on DCGENTB4LOG" in SAP S/4HANA. It reads from 1 data source (dcgentb4log) and exposes 15 fields with key fields hex_uuid, uuid, type, name, lvl. Part of development package S_APS_ODATA_REPAIR_CDS_APP.

Data Sources (1)

SourceAliasJoin Type
dcgentb4log dcgentb4log from

Parameters (1)

NameTypeDefault
p_uuid abap.raw(16)

Annotations (5)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY hex_uuid
KEY uuid uuid Waste Partner UUID
KEY type type Worklist Type
KEY name name Zone name
KEY lvl level Risk Level
KEY as4local as4local Activation State
rc rc Return Code
arbgb arbgb Message ID
msgnr msgnr Message
par1 par1 30 Characters
par2 par2 30 Characters
par3 par3 30 Characters
par4 par4 30 Characters
prelevel prelevel Flag (X or Blank)
actexecuted actexecuted Char01

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

CREATE VIEW APS_V_AGV_NODES AS
SELECT
  bintohex(uuid) AS hex_uuid,
  uuid,
  type,
  name,
  level AS lvl,
  as4local,
  rc,
  arbgb,
  msgnr,
  par1,
  par2,
  par3,
  par4,
  prelevel,
  actexecuted
FROM dcgentb4log
;

Learn More