P_BPLegalEntityValueHelp

DDL: P_BPLEGALENTITYVALUEHELP SQL: PGLOBCOMPNAMEVH Type: view BASIC Package: ODATA_CUSTOMER_LIST
2 Fields 2 Data Sources

Legal Entity of Organization

P_BPLegalEntityValueHelp is a Basic CDS View that provides data about "Legal Entity of Organization" in SAP S/4HANA. It reads from 2 data sources (tb032, tb032t) and exposes 2 fields with key field LegalEntityOfOrganization. Part of development package ODATA_CUSTOMER_LIST.

Data Sources (2)

SourceAliasJoin Type
tb032 _BPLegalEntity from
tb032t _Text left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PGLOBCOMPNAMEVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
Consumption.ranked true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY LegalEntityOfOrganization
LegalEntityOfOrgShortName

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_BPLegalEntityValueHelp.
-- 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: PGLOBCOMPNAMEVH

CREATE VIEW P_BPLegalEntityValueHelp AS
SELECT
  cast(_BPLegalEntity.legal_org as farp_legal_org) AS LegalEntityOfOrganization,
  cast ( _Text.textshort as farp_bnk_com_legal_org_short) AS LegalEntityOfOrgShortName
FROM tb032 AS _BPLegalEntity
LEFT OUTER JOIN tb032t AS _Text ON /* join condition not captured in parsed metadata */
;

Learn More