I_PaytReceiptCompanyCodeVH

DDL: I_PAYTRECEIPTCOMPANYCODEVH SQL: IPAYTRECPTCCVH Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT
8 Fields 2 Data Sources

Payment Receipt Company Code

I_PaytReceiptCompanyCodeVH is a Composite CDS View that provides data about "Payment Receipt Company Code" in SAP S/4HANA. It reads from 2 data sources (P_PaytRcptCnfgrdCompanyCode, I_CompanyCode) and exposes 8 fields with key field CompanyCode. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (2)

SourceAliasJoin Type
P_PaytRcptCnfgrdCompanyCode _PaytRcptCompanyCode from
I_CompanyCode I_CompanyCode inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPAYTRECPTCCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Payment Receipt Company Code view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
CityName I_CompanyCode CityName Name
Country I_CompanyCode Country Venue: Ctry/Reg
Currency I_CompanyCode Currency Valuation Crcy
CountryendasActiveCountry
_Country _Country
_Currency _Currency

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_PaytReceiptCompanyCodeVH.
-- 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: IPAYTRECPTCCVH

CREATE VIEW I_PaytReceiptCompanyCodeVH AS
SELECT
  I_CompanyCode.CompanyCode AS CompanyCode,
  I_CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_CompanyCode.CityName AS CityName,
  I_CompanyCode.Country AS Country,
  I_CompanyCode.Currency AS Currency,
  case when _PaytRcptCompanyCode.Country = 'XX' then 'TH' when _PaytRcptCompanyCode.Country <> 'XX' then _PaytRcptCompanyCode.Country end as ActiveCountry AS CountryendasActiveCountry
FROM P_PaytRcptCnfgrdCompanyCode AS _PaytRcptCompanyCode
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More