P_APOvrdCurrConvert

DDL: P_APOVRDCURRCONVERT SQL: PAPOVRDCURRC Type: view COMPOSITE Package: FINS_FIS_AP_APPS

convert currency

P_APOvrdCurrConvert is a Composite CDS View that provides data about "convert currency" in SAP S/4HANA. It reads from 1 data source (P_APOvrdCategory) and exposes 16 fields. Part of development package FINS_FIS_AP_APPS.

Data Sources (1)

SourceAliasJoin Type
P_APOvrdCategory P_APOvrdCategory from

Parameters (4)

NameTypeDefault
P_KeyDate abap.dats
P_AgingGridMeasureInDays abap.int4
P_CriticalThreshold abap.dec(5, 2)
P_DisplayCurrency vdm_v_display_currency

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PAPOVRDCURRC view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
Supplier Supplier
GLAccount GLAccount General Ledger
FinancialAccountType FinancialAccountType Fin. Account Type
Creditor Creditor Supplier
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
KeyDate KeyDate Maturity Key Date
CompanyCodeCurrency CompanyCodeCurrency Local Currency
SupplierAccountGroup SupplierAccountGroup Account group
IsCriticallyOverdue
PaymentBlockingReason PaymentBlockingReason Pmnt block
SpecialGLCode SpecialGLCode Special G/L Ind
BusinessArea BusinessArea Business Area
DisplayCurrency

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 P_APOvrdCurrConvert.
-- 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: PAPOVRDCURRC
-- Parameters: P_KeyDate : abap.dats, P_AgingGridMeasureInDays : abap.int4, P_CriticalThreshold : abap.dec(5, 2), P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW P_APOvrdCurrConvert AS
SELECT
  CompanyCode,
  FiscalYear,
  cast ( Creditor as md_supplier) AS Supplier,
  GLAccount,
  FinancialAccountType,
  Creditor,
  AccountingDocumentType,
  AccountingDocumentCategory,
  KeyDate,
  CompanyCodeCurrency,
  SupplierAccountGroup,
  cast( IsCriticallyOverdue as farp_ind_critical_ovrd ) AS IsCriticallyOverdue,
  PaymentBlockingReason,
  SpecialGLCode,
  BusinessArea,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency
FROM P_APOvrdCategory
;