I_CABllbleItmDataPackage

DDL: I_CABLLBLEITMDATAPACKAGE Type: view_entity BASIC

Datenpakete abr. Pos.

I_CABllbleItmDataPackage is a Basic CDS View that provides data about "Datenpakete abr. Pos." in SAP S/4HANA. It reads from 1 data source (dfkkbixbitx_log) and exposes 11 fields with key fields CABllbleItmClass, CABllbleItmDataPackageID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dfkkbixbitx_log dfkkbixbitx_log from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LogicalSystem _LogicalSystem $projection.LogicalSystem = _LogicalSystem.LogicalSystem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
EndUserText.label Datenpakete abr. Pos. view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CABllbleItmDataPackageID view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CABllbleItmClass bitcat Class
KEY CABllbleItmDataPackageID bitdatapackid Data Package
CreatedByUser crname Last Changed By
CreationDate crdate Sizing Date
CreationTime crtime Time Created
CABllbleItmDataPackageExtRef ext_ref32 Ext. Reference
CABllbleItmDataPackageText text60 Text
LogicalSystem log_system Logical system
CABllbleItmDataTransfFileName file_name Uploaded File Name
CABllbleItmNumber bit_number Number of Items
_LogicalSystem _LogicalSystem

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_CABllbleItmDataPackage.
-- 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 I_CABllbleItmDataPackage AS
SELECT
  bitcat AS CABllbleItmClass,
  bitdatapackid AS CABllbleItmDataPackageID,
  crname AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  ext_ref32 AS CABllbleItmDataPackageExtRef,
  text60 AS CABllbleItmDataPackageText,
  log_system AS LogicalSystem,
  file_name AS CABllbleItmDataTransfFileName,
  bit_number AS CABllbleItmNumber
FROM dfkkbixbitx_log
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
;