I_Aivs_Ai_Package

DDL: I_AIVS_AI_PACKAGE SQL: I_AIVS_PACKAGE Type: view
3 Fields 2 Data Sources 1 Associations

package

I_Aivs_Ai_Package is a CDS View that provides data about "package" in SAP S/4HANA. It reads from 2 data sources (sadlcdsi, sadlcdsu) and exposes 3 fields with key field Unit. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
sadlcdsi CdsInfo inner
sadlcdsu Package from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_Aivs_Ai_Usage _Usage _Usage.dlv_unit = $projection.Unit

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName I_AIVS_PACKAGE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label package view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Unit sadlcdsi dlv_unit SW Cmponent
Amount
_Usage _Usage

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 I_Aivs_Ai_Package.
-- 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: I_AIVS_PACKAGE

CREATE VIEW I_Aivs_Ai_Package AS
SELECT
  CdsInfo.dlv_unit AS Unit,
  count(*) AS Amount
FROM sadlcdsu AS Package
INNER JOIN sadlcdsi AS CdsInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Aivs_Ai_Usage AS _Usage ON _Usage.dlv_unit = Unit  -- association [0..*]
;

Learn More