APS_ODA_PACKAGE_ASSIGNMENT_API

DDL: APS_ODA_PACKAGE_ASSIGNMENT_API Type: view_entity
15 Fields 2 Data Sources

ORD Package Assignment

APS_ODA_PACKAGE_ASSIGNMENT_API is a CDS View that provides data about "ORD Package Assignment" in SAP S/4HANA. It reads from 2 data sources (aps_oda_t_packa, aps_oda_w_packa) and exposes 15 fields with key field id.

Data Sources (2)

SourceAliasJoin Type
aps_oda_t_packa aps_oda_t_packa union
aps_oda_w_packa aps_oda_w_packa from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ORD Package Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
package_id package_id Report Chain ID
docu_link docu_link URL
released released TRUE
object_type object_type Type
object_id object_id Transaction ID
create_user create_user User Name
change_user change_user User Name
package_id package_id Report Chain ID
docu_link docu_link URL
released released TRUE
object_type object_type Type
object_id object_id Transaction ID
create_user create_user User Name
change_user change_user User Name

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_ODA_PACKAGE_ASSIGNMENT_API.
-- 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 APS_ODA_PACKAGE_ASSIGNMENT_API AS
SELECT
  id,
  package_id,
  docu_link,
  released,
  object_type,
  object_id,
  create_user,
  change_user
FROM aps_oda_w_packa
-- UNION with additional select branch(es): aps_oda_t_packa
;

Learn More