I_ActyTypeDIPSourceMatlDetnRef

DDL: I_ACTYTYPEDIPSOURCEMATLDETNREF SQL: IATDSMDR Type: view BASIC Package: ODATA_WHERE_USED_ACTIVITY_TYPE
15 Fields 1 Data Sources

Sources and Matl. Determination Activity Type References

I_ActyTypeDIPSourceMatlDetnRef is a Basic CDS View that provides data about "Sources and Matl. Determination Activity Type References" in SAP S/4HANA. It reads from 1 data source (P_ActyTypeDIPSourceMatlDetnRef) and exposes 15 fields with key fields DynItemProcessorPrfl, RRBDynItmProfileUsage, DIPProfileMaterialDetnLineNmbr, DIPProfileItemSelSrceLineNmbr, ActivityTypeFieldName. Part of development package ODATA_WHERE_USED_ACTIVITY_TYPE.

Data Sources (1)

SourceAliasJoin Type
P_ActyTypeDIPSourceMatlDetnRef P_ActyTypeDIPSourceMatlDetnRef from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IATDSMDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sources and Matl. Determination Activity Type References view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #META view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DynItemProcessorPrfl DynItemProcessorPrfl DIP Profile
KEY RRBDynItmProfileUsage RRBDynItmProfileUsage DI usage
KEY DIPProfileMaterialDetnLineNmbr DIPProfileMaterialDetnLineNmbr Source Select. Index
KEY DIPProfileItemSelSrceLineNmbr DIPProfileItemSelSrceLineNmbr Source Select. Index
KEY ActivityTypeFieldName ActivityTypeFieldName UI Group FieldName
DIPProfileUsageText DIPProfileUsageText
DIPProfileText DIPProfileText User Group
Material Material Vehicle Model
DIPProfileSource DIPProfileSource
AllocationSetId AllocationSetId Group ID
CostCtrActivityTypeRangeFrom CostCtrActivityTypeRangeFrom Value from
CostCtrActivityTypeRangeTo CostCtrActivityTypeRangeTo Value to
CostCtrActivityType CostCtrActivityType Activity Type
DIPProfileSelectionSrceText DIPProfileSelectionSrceText User Group
SelectedValueIsExcluded SelectedValueIsExcluded Checkbox

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_ActyTypeDIPSourceMatlDetnRef.
-- 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: IATDSMDR

CREATE VIEW I_ActyTypeDIPSourceMatlDetnRef AS
SELECT
  DynItemProcessorPrfl,
  RRBDynItmProfileUsage,
  DIPProfileMaterialDetnLineNmbr,
  DIPProfileItemSelSrceLineNmbr,
  ActivityTypeFieldName,
  DIPProfileUsageText,
  DIPProfileText,
  Material,
  DIPProfileSource,
  AllocationSetId,
  CostCtrActivityTypeRangeFrom,
  CostCtrActivityTypeRangeTo,
  CostCtrActivityType,
  DIPProfileSelectionSrceText,
  SelectedValueIsExcluded
FROM P_ActyTypeDIPSourceMatlDetnRef
;

Learn More