I_ProdAllocationSequenceGroupT

DDL: I_PRODALLOCATIONSEQUENCEGROUPT SQL: IPASQNC_GRP_T Type: view BASIC

Product Allocation Sequence Group - Text

I_ProdAllocationSequenceGroupT is a Basic CDS View that provides data about "Product Allocation Sequence Group - Text" in SAP S/4HANA. It reads from 1 data source (pasqnc_grp_t) and exposes 8 fields with key fields ProdAllocSequenceGroupUUID, Language. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
pasqnc_grp_t pasqnc_grp_t from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_ProdAllocationSequenceGroup _ProdAllocationSequenceGroup $projection.ProdAllocSequenceGroupUUID = _ProdAllocationSequenceGroup.ProdAllocSequenceGroupUUID
[1..1] I_ProductAllocationSequence _ProductAllocationSequence $projection.ProductAllocationSequenceUUID = _ProductAllocationSequence.ProductAllocationSequenceUUID

Annotations (12)

NameValueLevelField
EndUserText.label Product Allocation Sequence Group - Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
ObjectModel.dataCategory #TEXT view
ObjectModel.sapObjectNodeType.name ProdAllocSqncGroupTxt view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IPASQNC_GRP_T view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocSequenceGroupUUID prodallocsequencegroupuuid Product Allocation Sequence Group UUID
KEY Language language Report Text Language
ProdAllocSequenceGroupDesc prodallocsequencegroupdesc Description
ProductAllocationSequenceUUID productallocationsequenceuuid Product Allocation Sequence UUID
ProdAllocSqncGroupDescUUID prodallocsqncgroupdescuuid Product Allocation Sequence Group Description UUID
_ProductAllocationSequence _ProductAllocationSequence
_ProdAllocationSequenceGroup _ProdAllocationSequenceGroup
_Language _Language

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_ProdAllocationSequenceGroupT.
-- 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: IPASQNC_GRP_T

CREATE VIEW I_ProdAllocationSequenceGroupT AS
SELECT
  ProdAllocSequenceGroupUUID,
  Language,
  ProdAllocSequenceGroupDesc,
  ProductAllocationSequenceUUID,
  ProdAllocSqncGroupDescUUID
FROM pasqnc_grp_t
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocationSequenceGroup AS _ProdAllocationSequenceGroup ON ProdAllocSequenceGroupUUID = _ProdAllocationSequenceGroup.ProdAllocSequenceGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_ProductAllocationSequence AS _ProductAllocationSequence ON ProductAllocationSequenceUUID = _ProductAllocationSequence.ProductAllocationSequenceUUID  -- association [1..1]
;