Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

{toc}

Basic Information

Application

GSV - Global Spent Visibility

Query Name

PCA 06_00_00 : Monitoring gaps payment

Query Technical Name

GSV_QRY_ODS_FIAP1_PCA_060000

Info Provider Name

FIAP: Line Item

Info Provider Technical Name

ODSFIAP1

Usage type

Direct execution in Analyzer

Expected users

Purchasing family

Purpose of this query

The Report allows to show the gap between the theoretical payment date and the day when the payment order is given to the bank.

Variables screen

Several variables are available in the report to allow filtering. Some are mandatory :

Fiscal Period (mandatory)* : Based on the posting dates of the accounting documents (Invoice).
Target Currency (mandatory)* : Some key figures will be converted to the selected currency. Note that both local and selected currency will be displayed.

All other variables are not mandatory and correspond to characteristics described below.

warning
Although the "Company" variable is not mandatory, if you have only access to Asia Pacific entities, it is mandatory to select the list of companies. Otherwise no data will be displayed.
/warning

Convert Unit* : By default BW displays in base unit, but by selecting a unit in this variable you can ask BW to convert to a single unit. More on quantity conversion here.

Due to the displayed dimensions by default, the advised period of time to run the query is the month.

Filters

  • * endors*: Only Standard Vendors (Z010) are included. Non standard (governements for taxes for example) are excluded.
    Account Document Type: Only the following documents are included.*

Code

Description

KA

Vendor document

KG

Vendor Credit Memo

KN

Net Vendors

KR

Vendor Invoice

RA

Sub cred memo stlmt

RE

Invoice - receipt

RN

Invoice - Net

ZW

Maint. interfac inv

ZC

BR-COMEX Document

Characteristics

Key Figures

Definition

Currency Conversion

Some of the key figures are in "Curr" meaning "Local Currency" (Legal Entity/Company currency) but others are on "Target Currency". These will show the amounts converted from local currency to the currency selected in the query prompt.

The conversion in this queries applies the CAR3 exchange rate available at the Posting date of the invoice (FI Document Posting Date).

The best way to get IT support is to use the new Service One Platform.