P_ProdAllocPlngBusPartValHelp

DDL: P_PRODALLOCPLNGBUSPARTVALHELP SQL: PPABOBJ_PLNGBPVH Type: view COMPOSITE

P_ProdAllocPlngBusPartValHelp is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_ProdAllocPlngBusPartners, I_PartnerFunction) and exposes 3 fields with key field PartnerFunction.

Data Sources (2)

SourceAliasJoin Type
P_ProdAllocPlngBusPartners P_ProdAllocPlngBusPartners inner
I_PartnerFunction PartnerFunctionType from

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PPABOBJ_PLNGBPVH view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PartnerFunction I_PartnerFunction PartnerFunction Partner Functn
BusinessPartner P_ProdAllocPlngBusPartners BusinessPartner Issuing Authority
BusinessPartnerName P_ProdAllocPlngBusPartners BusinessPartnerName Extracted Customer Name

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 P_ProdAllocPlngBusPartValHelp.
-- 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: PPABOBJ_PLNGBPVH

CREATE VIEW P_ProdAllocPlngBusPartValHelp AS
SELECT
  PartnerFunctionType.PartnerFunction AS PartnerFunction,
  P_ProdAllocPlngBusPartners.BusinessPartner AS BusinessPartner,
  P_ProdAllocPlngBusPartners.BusinessPartnerName AS BusinessPartnerName
FROM I_PartnerFunction AS PartnerFunctionType
INNER JOIN P_ProdAllocPlngBusPartners ON /* join condition not captured in parsed metadata */
;