I_ToBeReversedPaymentDocument

DDL: I_TOBEREVERSEDPAYMENTDOCUMENT SQL: FAP_FSCM_RR Type: view BASIC
6 Fields 2 Data Sources

Payment document to be reversed

I_ToBeReversedPaymentDocument is a Basic CDS View that provides data about "Payment document to be reversed" in SAP S/4HANA. It reads from 2 data sources (fap_fscm_rr_key, reguh) and exposes 6 fields with key field BusinessTransactionDocUUID.

Data Sources (2)

SourceAliasJoin Type
fap_fscm_rr_key _key from
reguh reguh left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAP_FSCM_RR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
EndUserText.label Payment document to be reversed view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessTransactionDocUUID fap_fscm_rr_key guid UUID 22 char.
PaymentRunDate fap_fscm_rr_key laufd Run On
PaymentRunIdentification fap_fscm_rr_key laufi Settlement ID
CompanyCode fap_fscm_rr_key zbukr Paying CoCd
PaymentDocument fap_fscm_rr_key vblnr Payment Doc.No.
PaymentOrder reguh pyord Payment Order

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_ToBeReversedPaymentDocument.
-- 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: FAP_FSCM_RR

CREATE VIEW I_ToBeReversedPaymentDocument AS
SELECT
  _key.guid AS BusinessTransactionDocUUID,
  _key.laufd AS PaymentRunDate,
  _key.laufi AS PaymentRunIdentification,
  _key.zbukr AS CompanyCode,
  _key.vblnr AS PaymentDocument,
  reguh.pyord AS PaymentOrder
FROM fap_fscm_rr_key AS _key
LEFT OUTER JOIN reguh ON /* join condition not captured in parsed metadata */
;

Learn More