I_SrvcDocTypeAllwdItemCategory

DDL: I_SRVCDOCTYPEALLWDITEMCATEGORY Type: view_entity COMPOSITE

Allowed item categories for process type

I_SrvcDocTypeAllwdItemCategory is a Composite CDS View that provides data about "Allowed item categories for process type" in SAP S/4HANA. It reads from 24 data sources and exposes 50 fields with key fields ServiceDocumentType, ServiceDocItemCategory, ServiceDocItemCategory, ServiceDocItemCategory, ServiceDocItemCategory. It has 2 associations to related views.

Data Sources (24)

SourceAliasJoin Type
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination from
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union
I_SrvcDocItmCatDetermination I_SrvcDocItmCatDetermination union

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocumentType _ServiceDocumentType $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType
[1..1] I_ServiceDocItemCategory _ServiceDocItemCategory $projection.ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allowed item categories for process type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType Transaction Type
KEY ServiceDocItemCategory ServiceDocItemCategory AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory1 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory2 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory3 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory4 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory5 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory6 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory7 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory8 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory9 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory10 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory11 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory12 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory13 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory14 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory15 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory16 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory17 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory18 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory19 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory20 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory21 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory22 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
KEY ServiceDocItemCategory SrvcDocAltvItemCategory23 AltrntveItemCty
_ServiceDocumentType _ServiceDocumentType
_ServiceDocItemCategory _ServiceDocItemCategory

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_SrvcDocTypeAllwdItemCategory.
-- 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_SrvcDocTypeAllwdItemCategory AS
SELECT
  ServiceDocumentType,
  ServiceDocItemCategory
FROM I_SrvcDocItmCatDetermination
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocItemCategory AS _ServiceDocItemCategory ON ServiceDocItemCategory = _ServiceDocItemCategory.ServiceDocItemCategory  -- association [1..1]
-- UNION with additional select branch(es): I_SrvcDocItmCatDetermination
;