I_JP_InvoiceSummaryPayerVH

DDL: I_JP_INVOICESUMMARYPAYERVH Type: view_entity COMPOSITE
26 Fields 2 Data Sources

Invoice Summary Payer

I_JP_InvoiceSummaryPayerVH is a Composite CDS View that provides data about "Invoice Summary Payer" in SAP S/4HANA. It reads from 2 data sources (I_Customer_VH, P_JP_invcsummaryhierarch) and exposes 26 fields with key field Customer.

Data Sources (2)

SourceAliasJoin Type
I_Customer_VH _Customer from
P_JP_invcsummaryhierarch _Isjphierarchy inner

Annotations (11)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
Search.searchable true view
EndUserText.label Invoice Summary Payer view
Consumption.ranked true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer_VH Customer Sold-to Party
CompanyCode P_JP_invcsummaryhierarch bukrs Value
OrganizationBPName1 I_Customer_VH OrganizationBPName1 Name 1
OrganizationBPName2 I_Customer_VH OrganizationBPName2 Name 2
Country I_Customer_VH Country Country/Region
CityName I_Customer_VH CityName City
StreetName I_Customer_VH StreetName Street
PostalCode I_Customer_VH PostalCode Postal Code
CustomerName I_Customer_VH CustomerName Customer Name
CustomerAccountGroup I_Customer_VH CustomerAccountGroup Account group
AuthorizationGroup I_Customer_VH AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_Customer_VH IsBusinessPurposeCompleted Purpose Complete Flag
IsCompetitor I_Customer_VH IsCompetitor Competitors
BusinessPartner I_Customer_VH BusinessPartner Business Partner
BusinessPartnerType I_Customer_VH BusinessPartnerType Business Partner Type
DataControllerSet I_Customer_VH DataControllerSet Data Ctrlr. Set
DataController1 I_Customer_VH DataController1 Data Controller
DataController2 I_Customer_VH DataController2 Data Controller
DataController3 I_Customer_VH DataController3 Data Controller
DataController4 I_Customer_VH DataController4 Data Controller
DataController5 I_Customer_VH DataController5 Data Controller
DataController6 I_Customer_VH DataController6 Data Controller
DataController7 I_Customer_VH DataController7 Data Controller
DataController8 I_Customer_VH DataController8 Data Controller
DataController9 I_Customer_VH DataController9 Data Controller
DataController10 I_Customer_VH DataController10 Data Controller

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_JP_InvoiceSummaryPayerVH.
-- 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_JP_InvoiceSummaryPayerVH AS
SELECT
  _Customer.Customer AS Customer,
  _Isjphierarchy.bukrs AS CompanyCode,
  _Customer.OrganizationBPName1 AS OrganizationBPName1,
  _Customer.OrganizationBPName2 AS OrganizationBPName2,
  _Customer.Country AS Country,
  _Customer.CityName AS CityName,
  _Customer.StreetName AS StreetName,
  _Customer.PostalCode AS PostalCode,
  _Customer.CustomerName AS CustomerName,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.IsCompetitor AS IsCompetitor,
  _Customer.BusinessPartner AS BusinessPartner,
  _Customer.BusinessPartnerType AS BusinessPartnerType,
  _Customer.DataControllerSet AS DataControllerSet,
  _Customer.DataController1 AS DataController1,
  _Customer.DataController2 AS DataController2,
  _Customer.DataController3 AS DataController3,
  _Customer.DataController4 AS DataController4,
  _Customer.DataController5 AS DataController5,
  _Customer.DataController6 AS DataController6,
  _Customer.DataController7 AS DataController7,
  _Customer.DataController8 AS DataController8,
  _Customer.DataController9 AS DataController9,
  _Customer.DataController10 AS DataController10
FROM I_Customer_VH AS _Customer
INNER JOIN P_JP_invcsummaryhierarch AS _Isjphierarchy ON /* join condition not captured in parsed metadata */
;

Learn More