I_ProdAllocCharcText

DDL: I_PRODALLOCCHARCTEXT SQL: IPAOCHARCTXT Type: view COMPOSITE

Product allocation characteristic text

I_ProdAllocCharcText is a Composite CDS View that provides data about "Product allocation characteristic text" in SAP S/4HANA. It reads from 15 data sources and exposes 2 fields with key fields ProdAllocCharcCtlgPathIntID, Language.

Data Sources (15)

SourceAliasJoin Type
I_ProdAllocCharcCtlgPathTP BASEPATH left_outer
I_DataElementLabelText BASEPATH_DETEXT left_outer
I_DataElementLabelText BASEPATH_PARENT_DETEXT left_outer
I_ProdAllocCharcCtlgPathTP BASEPATH_PARENT_PATH left_outer
I_PartnerFunctionText BASEPATH_PFTEXT left_outer
I_AllocCharcCtlgPathTTP BASEPATH_TEXT left_outer
I_DataElementLabelText DETEXT left_outer
I_Language LANG left_outer
P_CharcCtlgClfnCForDateDesc P_CharcCtlgClfnCForDateDesc left_outer
I_DataElementLabelText PARENT_DETEXT left_outer
I_ProdAllocCharcCtlgPathTP PARENT_PATH left_outer
I_ProdAllocCharcCtlgPathTP PATH from
I_ProdAllocCharcCtlgPathRef PATHREF left_outer
I_PartnerFunctionText PFTEXT left_outer
I_AllocCharcCtlgPathTTP TEXT left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPAOCHARCTXT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Product allocation characteristic text view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.private false view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ProdAllocCharcCtlgPathIntID view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocCharcCtlgPathIntID I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathIntID Catalog Path Internal ID
KEY Language I_Language Language Report Text 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_ProdAllocCharcText.
-- 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: IPAOCHARCTXT

CREATE VIEW I_ProdAllocCharcText AS
SELECT
  PATH.ProdAllocCharcCtlgPathIntID AS ProdAllocCharcCtlgPathIntID,
  LANG.Language AS Language
FROM I_ProdAllocCharcCtlgPathTP AS PATH
LEFT OUTER JOIN I_Language AS LANG ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PartnerFunctionText AS PFTEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DataElementLabelText AS DETEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathTP AS PARENT_PATH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DataElementLabelText AS PARENT_DETEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AllocCharcCtlgPathTTP AS TEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathRef AS PATHREF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathTP AS BASEPATH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PartnerFunctionText AS BASEPATH_PFTEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AllocCharcCtlgPathTTP AS BASEPATH_TEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DataElementLabelText AS BASEPATH_DETEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathTP AS BASEPATH_PARENT_PATH ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DataElementLabelText AS BASEPATH_PARENT_DETEXT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CharcCtlgClfnCForDateDesc ON /* join condition not captured in parsed metadata */
;