I_CN_ReqnStrategyPaytMethodVH

DDL: I_CN_REQNSTRATEGYPAYTMETHODVH SQL: ICNSTGYPAYMETHVH Type: view COMPOSITE

Requisition Strategy Payment Method Value Help

I_CN_ReqnStrategyPaytMethodVH is a Composite CDS View that provides data about "Requisition Strategy Payment Method Value Help" in SAP S/4HANA. It reads from 6 data sources and exposes 9 fields with key fields CompanyCode, PaymentMethod, PaymentMethod.

Data Sources (6)

SourceAliasJoin Type
I_CompanyCode t001 inner
I_CompanyCode t001 inner
I_PaytReceiptPaytMethVH t042e from
I_PaytReceiptPaytMethVH t042e union_all
I_PaymentMethod t042z inner
I_PaymentMethod t042z inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICNSTGYPAYMETHVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey PaymentMethod view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #COMPOSITE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Requisition Strategy Payment Method Value Help view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PaytReceiptPaytMethVH CompanyCode Receiver Company Code
KEY PaymentMethod I_PaytReceiptPaytMethVH PaymentMethod Pymt Meth.
PaymentMethodName I_PaymentMethod PaymentMethodName Text
IsPaytMethForIncomingPayments I_PaytReceiptPaytMethVH IsPaytMethForIncomingPayments Incoming Payments
CompanyCodeasCompanyCode
KEY PaymentMethod I_PaytReceiptPaytMethVH PaymentMethod Pymt Meth.
PaymentMethodName I_PaymentMethod PaymentMethodName Text
IsPaytMethForIncomingPayments I_PaytReceiptPaytMethVH IsPaytMethForIncomingPayments Incoming Payments
PaytMethIsUsdForBillOfExchange I_PaymentMethod PaytMethIsUsdForBillOfExchange Bill of Exchange Will Be Created

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_CN_ReqnStrategyPaytMethodVH.
-- 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: ICNSTGYPAYMETHVH

CREATE VIEW I_CN_ReqnStrategyPaytMethodVH AS
SELECT
  t042e.CompanyCode AS CompanyCode,
  t042e.PaymentMethod AS PaymentMethod,
  t042z.PaymentMethodName AS PaymentMethodName,
  t042e.IsPaytMethForIncomingPayments AS IsPaytMethForIncomingPayments,
  t042z.PaytMethIsUsdForBillOfExchange as PaytMethIsUsdForBillOfExchange AS CompanyCodeasCompanyCode,
  t042z.PaytMethIsUsdForBillOfExchange AS PaytMethIsUsdForBillOfExchange
FROM I_PaytReceiptPaytMethVH AS t042e
INNER JOIN I_CompanyCode AS t001 ON /* join condition not captured in parsed metadata */
INNER JOIN I_PaymentMethod AS t042z ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PaytReceiptPaytMethVH
;