I_PaymentReceiptTypeVH

DDL: I_PAYMENTRECEIPTTYPEVH SQL: IPAYTRECPTTYVH Type: view COMPOSITE
25 Fields 2 Data Sources

Payment Receipt Type

I_PaymentReceiptTypeVH is a Composite CDS View that provides data about "Payment Receipt Type" in SAP S/4HANA. It reads from 2 data sources (P_PaymentReceiptType, P_PaymentReceiptType1) and exposes 25 fields with key fields CompanyCode, Country, PaymentReceiptType, Country, PaymentReceiptType.

Data Sources (2)

SourceAliasJoin Type
P_PaymentReceiptType ReceiptType from
P_PaymentReceiptType1 ReceiptType union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPAYTRECPTTYVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
VDM.viewType #COMPOSITE view
EndUserText.label Payment Receipt Type view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PaymentReceiptType1 CompanyCode Receiver Company Code
KEY Country P_PaymentReceiptType1 Country Venue: Ctry/Reg
KEY PaymentReceiptType P_PaymentReceiptType1 PaymentReceiptType
BusinessPlace P_PaymentReceiptType1 BusinessPlace Business Place
BasedOnPaymentReceiptID P_PaymentReceiptType1 BasedOnPaymentReceiptID UxFunction Create With Reference
PaymentReceiptTypeName P_PaymentReceiptType1 PaymentReceiptTypeName
IsDefaultValue P_PaymentReceiptType1 IsDefaultValue IsDefault
PrintQueue P_PaymentReceiptType1 PrintQueue EnablePrint
EmailTemplate P_PaymentReceiptType1 EmailTemplate EnableEmail
PaymentType P_PaymentReceiptType1 PaymentType PrePaymentReceiptType
JITScenario P_PaymentReceiptType1 JITScenario Scenario
CAInvcgDocPrntOutpCtrlIsEnbld P_PaymentReceiptType1 CAInvcgDocPrntOutpCtrlIsEnbld ODN enable
CompanyCode Is Payment Detail Mandatory
KEY Country P_PaymentReceiptType1 Country Venue: Ctry/Reg
KEY PaymentReceiptType P_PaymentReceiptType1 PaymentReceiptType
BusinessPlace P_PaymentReceiptType1 BusinessPlace Business Place
BasedOnPaymentReceiptID P_PaymentReceiptType1 BasedOnPaymentReceiptID UxFunction Create With Reference
PaymentReceiptTypeName P_PaymentReceiptType1 PaymentReceiptTypeName
IsDefaultValue P_PaymentReceiptType1 IsDefaultValue IsDefault
PrintQueue P_PaymentReceiptType1 PrintQueue EnablePrint
EmailTemplate P_PaymentReceiptType1 EmailTemplate EnableEmail
PaymentType P_PaymentReceiptType1 PaymentType PrePaymentReceiptType
JITScenario P_PaymentReceiptType1 JITScenario Scenario
CAInvcgDocPrntOutpCtrlIsEnbld P_PaymentReceiptType1 CAInvcgDocPrntOutpCtrlIsEnbld ODN enable
PaymentMethod P_PaymentReceiptType1 PaymentMethod Is Payment Detail Mandatory

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_PaymentReceiptTypeVH.
-- 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: IPAYTRECPTTYVH

CREATE VIEW I_PaymentReceiptTypeVH AS
SELECT
  ReceiptType.CompanyCode AS CompanyCode,
  ReceiptType.Country AS Country,
  ReceiptType.PaymentReceiptType AS PaymentReceiptType,
  ReceiptType.BusinessPlace AS BusinessPlace,
  ReceiptType.BasedOnPaymentReceiptID AS BasedOnPaymentReceiptID,
  ReceiptType.PaymentReceiptTypeName AS PaymentReceiptTypeName,
  ReceiptType.IsDefaultValue AS IsDefaultValue,
  ReceiptType.PrintQueue AS PrintQueue,
  ReceiptType.EmailTemplate AS EmailTemplate,
  ReceiptType.PaymentType AS PaymentType,
  ReceiptType.JITScenario AS JITScenario,
  ReceiptType.CAInvcgDocPrntOutpCtrlIsEnbld AS CAInvcgDocPrntOutpCtrlIsEnbld,
  ReceiptType.PaymentMethod AS PaymentMethod
FROM P_PaymentReceiptType AS ReceiptType
-- UNION with additional select branch(es): P_PaymentReceiptType1
;

Learn More