Reference Guide For Invoice Solution
Reference Guide For Invoice Solution
VIMZ230402-RGD-EN-01
OpenText™ Vendor Invoice Management for SAP® Solutions
Reference Guide for Invoice Solution
VIMZ230402-RGD-EN-01
Rev.: 2024-Oct-29
This documentation has been created for OpenText™ Vendor Invoice Management for SAP® Solutions 23.4 SPS2.
It is also valid for subsequent software releases unless OpenText has made newer documentation available with the product,
on an OpenText website, or by any other means.
Tel: +1-519-888-7111
Toll Free Canada/USA: 1-800-499-6544 International: +800-4996-5440
Fax: +1-519-888-0677
Support: [Link]
For more information, visit [Link]
Disclaimer
Every effort has been made to ensure the accuracy of the features and techniques presented in this publication. However,
Open Text Corporation and its affiliates accept no responsibility and offer no warranty whether expressed or implied, for the
accuracy of this publication.
Table of Contents
1 About OpenText Vendor Invoice Management (VIM) for
SAP Solutions .......................................................................... 13
1.1 Architectural Overview ..................................................................... 15
1.2 About this document ........................................................................ 16
1.2.1 Target audience .............................................................................. 16
1.2.2 Related documentation .................................................................... 16
Part 2 Reporting 31
OpenText Vendor Invoice Management (VIM) for SAP Solutions is an ABAP add-on
solution to SAP S/4HANA. It automates the processing of incoming documents into
SAP.
If the business rules pass, the document is posted in SAP without human
intervention. Although a straight through, no-touch process is the ultimate objective,
OpenText VIM for SAP also supports the fast and efficient handling and resolution
of exceptions. Exceptions are routed via workflow to the relevant user or user group
based on the role assigned to the exception.
For managers, OpenText VIM for SAP offers a comprehensive suite of operational
and analytical reports. In addition, it offers the tools to identify common exceptions
that should be addressed to achieve even higher levels of automation.
• Invoice Solution
• Procure to Pay Solutions
– Order Confirmation
– Delivery Note
– Quotation
• Order to Cash Solutions
– Sales Order
– Remittance Advice
Since OpenText VIM for SAP resides inside SAP, enrichments and business rules
have direct access to SAP master and transactional data, which avoids complex
interfaces and the replication and duplication of data.
VIM Solutions use features offered by its powerful feature rich Foundation.
• Inbound
• Process
• Workplace
• Analytics
Beside the components of this graphic, OpenText VIM for SAP offers additional
components such as SAP NetWeaver Business Warehouse or BW/4Hana for specific
solutions which are not shown in this basis architectural overview.
• OpenText Vendor Invoice Management for SAP Solutions - User Guide for Invoice
Solution (VIMZ-UGD)
• OpenText Vendor Invoice Management for SAP Solutions - Installation Guide (VIMZ-
IGD)
• OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD)
• OpenText Vendor Invoice Management for SAP Solutions - Administration Guide
(VIMZ-AGD)
• OpenText Vendor Invoice Management for SAP Solutions - Reference Guide for Invoice
Solution (VIMZ-RGD)
• OpenText Vendor Invoice Management for SAP Solutions - Scenario Guide for Invoice
Solution (VIMZ-CCS)
• OpenText Vendor Invoice Management for SAP Solutions - Security Guide (VIMZ-
GSM)
• OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Foundation (VIMZ-CGF)
• OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Solutions Beyond Invoice (BOCPZ-CCS)
• OpenText Vendor Invoice Management for SAP Solutions - User Guide for Solutions
Beyond Invoice (BOCPZ-UGD)
• Restrictions
• Important dependencies
• New features
• Known issues
• Fixed issues
• Documentation extensions
The Release Notes are updated continuously. The latest version of the Release Notes
is available on OpenText My Support.
A third party interface is one channel to import an invoice to OpenText VIM for
SAP. Third party vendors provide the routing of invoices from the vendor to the
customer. “Middlemen” handle the responsibility of sending the invoice from
vendor to customer. These middlemen may also communicate back to the vendor
regarding the progress of the invoice processing on customer side. Third party
vendors can use any middleware technology like EDI, and so on.
Figure 2 depicts the suggested data and process flow for a third party service
provider scenario.
Process flow
1. The third party provider module receives digitally signed invoices from
vendors.
2. The third party provider module verifies the authenticity of the digital
signature using Digital Signature Application.
5. The third party provider module archives the invoice image to the OpenText™
Archive Center via HTTP Post action.
Note: HTTP Post is obsolete and may not work with recent archive server
software. Use HTTP Put instead.
6. The third party provider module calls the second API (FM2) to trigger the
invoice processing in SAP S/4HANA.
7. While invoice processing continues in SAP S/4HANA, the third party provider
module can query the status of the document by calling the third API (FM3).
• Ensure that the original invoice sent by the vendor is transmitted unaltered to the
customer.
• Ensure that a Digital Signature infrastructure is agreed on and implemented
according to the customer and partner needs.
• Ensure that the OpenText VIM for SAP APIs are implemented so that correct
data is passed to OpenText VIM for SAP.
Note: OpenText VIM for SAP workflow is started directly when you use this
scenario. Therefore, the status of the steps before the start of the workflow
cannot be monitored with tools like VIM Central Workplace. As soon as the
workflow is started, the document is visible in VIM Analytics and other
reports.
The third party service provider scenario includes 3 Interface Remote Functions.
Import parameters
The third party provider must enter the correct parameters to match the SAP
ArchiveLink® configuration.
Export parameters
Error handling
If the RFC raises an exception, the call has failed. The call can be resubmitted if
possible. If the RC returns value 8, a data error has occurred. This record should be
placed into a separate queue for error handling. Resubmitting without investigation
will not make much sense.
Import parameters
2. Channel info:
Structure/OPT/VIM_1REXTDATA:
For each invoice field passed, the External Partner must specify field name
(EXTFIELD) and value (EXTVALUE).
4. Other optional parameters:
Export parameters
Error handling If the RFC raises an exception, the call has failed. The call can be resubmitted if
possible. If the RC returns value 8, a data error has occurred. This record should be
placed into a separate queue for error handling. Resubmitting without investigation
will not make much sense.
Basic scenarios The function supports two basic scenarios concerning the import parameters, the
mapping scenario and the data scenario. Consider these scenarios. Which one of
these basic scenarios is taken, will be decided by the content of parameter
I_DOC_HEADER. If this parameter is initial, the mapping scenario is assumed. If
this parameter is not initial, the data scenario is assumed.
Mapping scenario
In this scenario, mapping is performed according to the value of CHANNEL_ID.
Data is expected in table EXTDATA_HEAD and EXTDATA_ITEM. Data
provided in I_DOC_ITEMS will be ignored.
Parameters DOCTYPE and AR_OBJECT can be left empty. Their values are
calculated according to configuration and document type determination engine.
If one or both of these parameters are provided, the given value will override
the configuration.
Data scenario
In this scenario, data is taken from I_DOC_HEADER and I_DOC_ITEMS. Data
provided in EXTDATA_HEAD and EXTDATA_ITEMS is ignored.
Parameters DOCTYPE and AR_OBJECT can be left empty. Their values are
calculated according to configuration and document type determination engine.
If one or both of these parameters are provided, the given value will override
the configuration.
If you are providing a posting date BUDAT in the data scenario, be sure to
assign a value to the posting date determination method POST_DATE_DET as well.
The appropriate value is E for provided externally.
Additional notes
The document class (TIF, PDF, and so on) is determined the following way:
Import parameters
1. Channel info:
Export parameters
Error handling
If the RFC raises an exception, the call has failed. The call can be resubmitted if
possible. If the RC returns value 8, a data error has occurred. This record should be
placed into a separate queue for error handling. Resubmitting without investigation
will not make much sense.
Notes
• Error messages will be stored in the application log. The RETURN table will
not be filled.
• RC will always be 0.
The function delivers the document status of documents with the following
peculiarities on import and export parameters:
CHANNEL_ID
The function delivers documents which have the specified channel ID. If
CHANNEL_ID is empty, only documents with empty channel ID are
considered.
SYSTEM
The function delivers documents from the specified logical system. If SYSTEM is
empty, the documents are checked in all active systems of the system landscape.
DOC_QUERY
If this table parameter is empty, all documents are delivered.
DOC_QUERY-DOCID
The function delivers the document with the specified document number(s).
DOC_QUERY-LOGICAL_SYSTEM
This import parameter is ignored.
DOC_STATUS
The resulting table is sorted by document numbers. This gives an easy overview
on the status of documents in different systems.
DOC_STATUS-LOGICAL_SYSTEM
This export parameter shows the logical system where the information of the
table entry was taken from.
• VIM Analytics
• VIM Analytics Current Liability Report
• Automation Report
• Central Reporting, comprising the following reports:
– Summary Report
– Central Audit Report
– Key Process Analytics Report
– Exception Analysis Report
– Productivity Report
– Aging Report
This part describes how to work with the mentioned reports as an end user.
VIM Analytics (VAN) is one of the most important and widely used reports in
OpenText VIM for SAP. It provides a detailed view of vendor invoices with an
exhaustive list of selection fields to filter from.
With the wide range of selection fields available in VAN, invoices can be filtered by
DP number, vendor, company, status, due date, accounting data, work item data,
and many other options.
VAN makes it easier for a user to search for a particular DP, track status, check
triggered exceptions, find out the current agent, and view document attachments for
an invoice or invoices. In addition, this report enables a user with forward
navigation to DP document and SAP screens to drill down further for more details.
The user can see DP information on a single screen, including a detail pane offering
additional runtime information. This pane includes the following views:
• Process View
This view displays open and completed OpenText VIM for SAP processes
together with the current workflow status, the current agent and exception
reason of this particular process.
• Image View
This view displays the scanned, linked images.
• History View
This view displays the OpenText VIM for SAP process and approval history.
• Comments View
This view displays the comments that have been added during the OpenText
VIM for SAP process and during the approval process.
Invoices posted directly from SAP or using a OpenText VIM for SAP process can
both be viewed and tracked in this report.
VIM Analytics is highly optimized for SAP® HANA database systems and supports
queries on mass data swiftly.
/OPT/VIM_VA2
This transaction launches VIM Analytics with the full set of more than 80
selection fields.
/OPT/VIM_VA21 (AP Basic) - using report variant /OPT/VA2_L01
This transaction launches VIM Analytics with a subset of selection fields tailored
to an accounting expert. This variant allows searches for specific invoices using
invoice data like invoice numbers, document date, total amount, and reference
number.
/OPT/VIM_VA22 (AP Advanced) - using report variant /OPT/VA2_L02
This transaction launches VIM Analytics with a subset of selection fields tailored
to a higher level accounting expert or special roles as duplicate checker, financial
administrator or tax expert. This variant allows searches for specific invoices
using invoice data like invoice numbers, document date, total amount, reference
number, but also process data, accounting data and due dates.
/OPT/VIM_VA23 (Procurement) - using report variant /OPT/VA2_L03
This transaction launches VIM Analytics with a subset of selection fields tailored
to a purchase agent in the procurement department. This variant allows searches
for specific invoices using invoice data like invoice numbers, document date,
total amount, reference number and requisitioner, but also purchasing data.
/OPT/VIM_VA24 (Monitor) - using report variant /OPT/VA2_L04
This transaction launches VIM Analytics with a subset of selection fields tailored
to a person who needs to monitor invoices and their processes. This variant
allows searches for invoice data like document date, total amount and reference
number, but also accounting data, due dates, document dates and OpenText
VIM for SAP exceptions.
Tip: You can switch between the different report variants with Get Variant .
Note: This new logic includes some restrictions on the possible values for the
Target System field. Some documents with unexpected values in Target
System might not be visible any more. If you want to use the old logic, set up
your system as Single System Landscape. The old logic does not try to match the
target system values of the documents to the SLD.
You can start or run VAN on the central system or on any of the satellite system as
defined in the SLD. In version 7.5 SP4, the following new reports are introduced for
this:
/OPT/VIM_ This transaction launches VAN to read DP data from one remote system.
VA25
To start remote enabled VAN for a single remote system:
2. Enter the Target System (logical system of satellite or remote system) or click
to select it from a list.
3. To launch the new VAN (/OPT/VIM_VA2 transaction) on the remote system, click
.
/OPT/VIM_ This transaction launches VAN to read DP data from two or more remote systems.
VA26
To start remote enabled VAN for multiple remote systems:
Target System
Systems according to the SLD configuration from logon system. For more
information, see Section 4.4 “Working with the System Landscape Directory
(SLD)” in OpenText Vendor Invoice Management for SAP Solutions - Scenario
Guide for Invoice Solution (VIMZ-CCS).
DP Document Type
DP document types from the selected target systems (satellite or central)
Company Code
Company codes from the selected target systems (satellite or central)
Users can additionally restrict the data selection, based on other selection fields,
for example PO, DP, or Cost Center numbers. Therefore, users must know the
respective values. The reason for this is that currently the F4 help is not enabled
for master and transaction data fields because the data is not available on the
current (logon) system.
Note: Your screen might look different as the display of selection fields
can be customized.
The selection screen controls all functions of VIM Analytics. The selection screen
comprises the application toolbar and selection field panel. The following list
summarizes the features of these panels.
Application toolbar
Using the buttons in the application toolbar, you can perform the following
actions:
Execute
VIM Analytics creates and displays a report, using the current settings in
the selection field panel.
Example: You search for Document Currency = EUR and click to save the
selection criteria. Next time, you can click to retrieve the search you saved
before. This is useful if you often perform a selection with different search criteria.
Report Options The Report Options section enables you to edit the settings for your report:
Layout
Click to select a layout variant from the list. With baseline, a basic and an
extended layout variant are available. You can create a layout variant for the
result list. Use the ALV buttons Change Layout and Save Layout on the result
list.
Reporting Currency
The amount fields in the result list like Gross invoice amount, Discount
Amount 1, and Discount Amount 2 can be displayed in document currency but
also in any user-defined reporting currency.
Select the reporting currency. You can set a default reporting currency by setting
the user parameter FWS. If no user parameter is maintained, USD is used as
default reporting currency.
Invoice Data
Transaction/Event
Categorization of invoice documents into invoices, credit memos, subsequent
debits, subsequent credits and down payments
Reference
Reference document number from the invoice
Purchasing Document
Purchasing document number
Note: Both the actual purchasing document in line items and potential
purchasing documents from header level and purchase order list (PO list)
are taken into account.
Purchasing Group
Purchasing group assigned to purchasing document
Note: Both the actual purchasing document in line items and potential
purchasing documents from header level and purchase order list (PO list)
are taken into account.
Plant
Plant from the invoice line items
Freight Order
Freight Order number/Freight Booking number
Freight order is a transportation document that is used for road and rail
transportation. Freight booking is a transportation document that is used for air
and ocean transportation
Air Waybill
Air Waybill is a document that covers both domestic and international flights
transporting goods to a specified destination. A House Air Waybill (HAWB) is
issued by a freight forwarder. It details the agreement between the freight
forwarder and the shipper. The HAWB is used when a freight
forwarder consolidates multiple shipments into one master shipment under a
single Master Air Waybill (MAWB).
Process Data
• Invoices of all Process Types. This means invoices with and without
OpenText VIM for SAP processes
• Parked/Blocked Inv., w/o DP. This means invoices with at least one
OpenText VIM for SAP process (parking, blocking, approval) but without a
DP process.
• Invoices without VIM Process. This means invoices without any OpenText
VIM for SAP process
Invoice Type
Type of invoice, indicating whether the invoice is purchase order based or not
Specific Scenario
Specific Scenario provides predefined scenarios, for example All Invoices,
Open Invoices, and Completed Invoices.
Selected Status
Selected Status enables you to select for the status of the SAP invoice or for
the OpenText VIM for SAP processing status. The value help offers a big
range of different status values. SAP statuses start with the prefix SAP_. They
represent different states of the SAP invoice, for example Parked, Posted, or
Blocked. Statuses without prefix SAP_ represent DP statuses.
Accounting Data
Due Dates
Due date
Due date of invoice
Days to Due
Number of days until the invoice is due for payment
This field allows negative values, as well, to get invoices whose due date was a
number of days ago.
Note: A possible difference of time zones between payer and invoicing
party is not taken into account.
Overdue
Check box to indicate that the invoice is overdue for net payment
Note: A possible difference of time zones between payer and invoicing
party is not taken into account.
Days to Cash Discount Date 1
Number of days until the cash discount applied to the shortest payment period
is due
This field allows negative values, as well, to get invoices whose cash discount 1
was a number of days ago.
Note: A possible difference of time zones between payer and invoicing
party is not taken into account.
Days to Cash Discount Date 2
Number of days until the cash discount applied to the second payment period is
due
This field allows negative values, as well, to get invoices whose cash discount 2
was a number of days ago.
Note: A possible difference of time zones between payer and invoicing
party is not taken into account.
Workflow Type
Type of the OpenText VIM for SAP workflow that is or was active for processing
an invoice.
Example:
• The work item could be created but the condition for the step Create
Work Item is not yet fulfilled (SAP work item status: CHECKED).
• The work item cannot be executed yet and therefore cannot be seen in
the Business Workplace or the VIM Invoice Workplace yet (SAP work
item status: WAITING).
51 - In Process
These are workflows with a current work item that has one of the following
statuses:
52 - Completed
These are workflows with the following statuses:
54 - Error in Workflow
These are workflows with a current work item that has the following status:
Document Dates
Start Date
Date when the invoice entered the SAP system
DP Start Date
Date when the DP workflow started
Parking Date
Date when the parked SAP invoice was created or when the SAP invoice was
parked
Update Date
Date of the last change of the invoice.
Note: Even doing an approval step is defined as a change in this context.
Process Flow
The following sections explain the general layout and the various areas of the report
results.
1. In the selection screen, enter the criteria you want to run a report for.
1
Menu toolbar
2
Application toolbar
3
Result list
4
Detail pane
Personal layout You can change the layout of the report results screen, according to your needs:
When you leave the report results screen, using the , , or button,
VIM Analytics remembers your current state, and will show it again the next time
you open the report results.
Layout variants Using the button, you can define and save layout variants in the result list, the
Processes tab, and the Line Items tab in the detail pane.
Refresh
Get the newest data for the displayed report results.
Choose Layout
Choose, change, save, and manage layouts. Click the small arrow on the right
side of the Choose Layout button.
Choose Layout
Select a saved layout from the list.
Change Layout
Add columns to the result list by shifting columns from Column Set to
Displayed Columns, using the arrow button.
Remove columns from the result list by shifting columns from Displayed
Columns to Column Set, using the arrow button.
Change the order of displayed columns using the up and down arrows in
Displayed Columns.
Click to save your layout.
Save Layout
Save your current layout status under an existing or a new name.
To keep the layout only for you, select the User-specific check box.
To load the layout as default layout when the result list is opened, select the
Default setting check box.
Manage Layouts
Define default settings of layouts and delete layouts.
Dashboard
Access the OpenText unified dashboard for the selected document.
Vendor Workspace
Display the Vendor Workspace (OpenText™ Content Management for SAP®
Solutions) for the work item in a separate window. OpenText Content
Management for SAP Solutions allows you to access related OpenText™
Content Server items in the business workspace without leaving the SAP
system.
For a comprehensive description, see Section 6 “Working in SAP ERP with the
Business Content window” in OpenText Content Management for SAP Solutions -
User Guide (ERLK-UGD)
Result list (ALV The result list provides details on invoice header level. The most important fields of
grid) the result list are described in “Understanding result list fields” on page 47.
OpenText delivers one basic and one extended layout variant for the result list in the
baseline. However, you can define your own layout variant to add fields to the
result list, to remove fields from the result list, or to change the sorting of the result
list.
Note: For performance reasons, OpenText recommends that you restrict the
layout to those columns that you really need.
Underlined values, for example in the Document Number or the Exception Reason
column, serve as links to pages with detailed information.
The asterisk (*) in a cell indicates that there is more than one value in this cell. This
can be the case with, for example, Purchasing Document, Current Agent or
accounting objects. Cells showing an asterisk do not serve as links. (Exception:
Current Agent in the Processes tab of the detail pane)
Current Agent
Agent that is currently assigned for processing the invoice
If multiple different agents are assigned, * is displayed.
Cycle Time
Duration of OpenText VIM for SAP processes from the entry time (Start Date/
Start Time) of the OpenText VIM for SAP invoice in the SAP system to the end
time (End Date/End Time) of the latest OpenText VIM for SAP process
Days to Cash Disc.1
Days to due date for cash discount applied to the shortest payment period
Days to Cash Disc.2
Days to due date for cash discount applied to the second payment period
Days to Due
Number of days until the invoice is due for net payment.
This field is cleared for completed invoices (this means obsolete, deleted, or
cancelled invoices and confirmed duplicates) or if the invoice is already fully or
partially paid.
Discount 1 Percentage
Cash discount percentage rate applied to the shortest payment period
Discount 2 Percentage
Cash discount percentage rate applied to the second payment period
Discount Amount 1
Amount of cash discount for the shortest payment period in document currency
Discount Amount 1 in Rep. Crcy
Amount of cash discount for the shortest payment period in reporting currency
(as entered in the selection screen)
Discount Amount 2
Amount of cash discount for the second payment period in document currency
Discount Amount 2 in Rep. Crcy
Amount of cash discount for the second payment period in reporting currency
(as entered in the selection screen)
Discount Light Icon
Icon that is indicating,
DP ID before restart
ID of a previous DP document that was deleted and for which a new DP process
was started
Due Date
Due date of the invoice
End at
Time at which the last OpenText VIM for SAP process was finished
End on
Date when the last OpenText VIM for SAP process was finished
Enter at
Time at which the invoice entered the SAP system
Enter on
Date when the invoice entered the SAP system
Exception Reason
Current exception of the invoice, for example the current process type of a DP
document or the parking reason of a parked invoice
Invoice Type
Type of invoice, indicating whether the invoice is purchase order based or not
Net Amount
Net Amount, as calculated in the DP indexing screen
Paid at
Time of the last partial or complete payment
Paid on
Date of the last partial or complete payment
Parked at
Time at which the parked SAP invoice was created or at which the SAP invoice
was parked
Parked on
Date when the parked SAP invoice was created or when the SAP invoice was
parked
Plant
Plant from invoice line items
If multiple different plants are assigned, * is displayed.
Posted at
Time at which the posted SAP invoice was created or at which the SAP invoice
was posted
Posted by
User who created the posted SAP invoice or who posted the SAP invoice
Posted on
Date when the posted SAP invoice was created or when the SAP invoice was
posted
Posting Date
Posting Date in the invoice; this date is used when entering the document in
Financial Accounting or Controlling
Predecessor Object Key
Object key of an invoice that was deleted or cancelled and re-entered by another
invoice
Priority
Document priority
Purchasing Document
Purchasing document number from invoice header, invoice items and purchase
order list.
If multiple different purchase orders are assigned, * is displayed.
Reversal Doc#
Number of reversal document
Revsed F_Year
Fiscal year of reversal document
SAP Process Status
Status ID of the SAP invoice
Start at
Time at which the DP workflow started
Start on
Date when the DP workflow started
Tax Code
SAP tax code
Unblock at
Time at which the payment block was removed from the MM invoice document
or posting time if there was no payment block
Unblock on
Date when the payment block was removed from the MM invoice document or
posting date if there was no payment block
Update Date
Date of the last change of the invoice
Update Time
Time of the last change of the invoice
Vendor Name
First and last name of the vendor as entered in the invoice. If there are no values
in the invoice, the names of the vendor are taken from the vendor master data.
• Processes
• Image
• Line Items
• History
• Comments
• Vendor Workspace
If you change the selection in the result list, the detail pane automatically switches to
the newly selected document.
Processes
This tab shows the OpenText VIM for SAP workflows of the document that is
selected in the result list.
The ALV grid control of the Processes tab provides some action buttons.
Click the small arrow on the right side of the button to choose or change the
layout. For more information, see Choose Layout on page 46.
The Process State column displays one of the following icons, indicating the status
of the workflow:
The font and background color in the lines of the Processes tab indicate whether
user interaction is required.
Black
Black font indicates that user interaction is required.
Gray
Gray font and a very light gray as background color indicate completed
workflows or workflows that are currently processed in background.
Red
The background color is red if the process is on error.
In case of a parallel workflow, the Processes tab displays more than one line with
different agents.
Image
This tab displays the scanned image of the original invoice that is selected in the
result list.
Line Items
This tab displays the line items of the document that is selected in the result list.
The ALV grid control of the Line Items tab provides an action button.
Click the small arrow on the right side of the button to choose or change the
layout. For more information, see Choose Layout on page 46.
History
This tab displays the history of the document that is selected in the result list. It
displays Process History and Approval History.
The ALV grid control of the History tab provides an action button.
Click the small arrow on the right side of the button to choose or change the
layout. For more information, see Choose Layout on page 46.
Comments
This tab displays the comments of the document that is selected in the result list. It
displays Process Comments and Approval Comments.
Vendor Workspace
This tab displays the OpenText Content Management for SAP Solutions plug-in for
the work item. OpenText Content Management for SAP Solutions allows you to
access related OpenText Content Server items in the business workspace without
leaving the SAP system.
For a comprehensive description, see Section 6 “Working in SAP ERP with the
Business Content window” in OpenText Content Management for SAP Solutions - User
Guide (ERLK-UGD)
Dialog Flag
Indicator whether the current task is a dialog task or not (background task)
Document ID
DP Document ID
End at
Time at which the OpenText VIM for SAP workflow was finished
End on
Date when the OpenText VIM for SAP workflow was finished
Exception Reason
Current exception of the OpenText VIM for SAP process, for example the
current DP process type, the parking reason or the block reason
Fiscal Year
Fiscal year of the SAP invoice document
Note: This field is populated only for OpenText VIM for SAP processes
that are related to a SAP FI invoice or a SAP MM invoice, for example at
the parking workflow of a SAP FI invoice or of a SAP MM invoice.
Invoice Item
Item number of SAP invoice that is processed by the OpenText VIM for SAP
workflow
Note: This field is populated only for the block workflow on SAP MM
invoice line items
Note: This field is populated only for OpenText VIM for SAP processes
that are related to a SAP MM invoice, for example at the blocking
workflow of a SAP MM invoice.
Option Id
ID of the last process option executed
Option Text
Text of the last process option executed
Option Type
Type of the last process option executed
Park Reason
Parking reason in case of a parking workflow
Priority
Priority of the OpenText VIM for SAP workflow
Process State
For a description of this field, see “Processes” on page 52.
Process Type
DP process type
Start at
Time at which the OpenText VIM for SAP workflow was started
Start on
Date when the OpenText VIM for SAP workflow was started
Update Date
Date when the OpenText VIM for SAP workflow was processed the last time
Update Time
Time at which the OpenText VIM for SAP workflow was processed the last time
WF Type Text
Text for the OpenText VIM for SAP workflow type
Example:
WI Status
Current status of the OpenText VIM for SAP workflow. The following values are
available:
50 - Waiting
These are workflows with a current work item that is not yet visible in the
VIM Invoice Workplace. This can have one of the following reasons:
• The work item could be created but the condition for the step Create
Work Item is not yet fulfilled (SAP work item status: CHECKED).
• The work item cannot be executed yet and therefore cannot be seen in
the Business Workplace or the VIM Invoice Workplace yet (SAP work
item status: WAITING).
51 - In Process
These are workflows with a current work item that has one of the following
statuses:
52 - Completed
These are workflows with the following statuses:
54 - Error in Workflow
These are workflows with a current work item that has the following status:
WI Status Text
Text for the current status of the OpenText VIM for SAP workflow
Workflow
Work item ID of the workflow instance
Workflow Definition
Technical ID of the workflow template
Workflow Type
ID of OpenText VIM for SAP workflow type
Example:
Amount
Amount in document currency
Amount in Rep. Crcy.
Amount in reporting currency (as entered in the selection screen)
Document ID
DP Document ID
Document Item ID
ID of DP document line item
Item
Item number of purchasing document
Text
Line item text
G/L Account, Cost Center, and other accounting objects
Accounting object of invoice line item or purchase order in case of PO based DP
document
These key figures and many more can be determined by ALV grid standard features.
This section gives you an idea how this works and what is possible. For more
detailed information to the ALV grid and its features, see the SAP documentation.
1. Launch the new VAN report with selection criteria Current Role not equal to
the empty value.
To get all invoices displayed, you may have to change the value for selection
field Maximum Number of Records.
Important
If you have thousands or even millions of invoices, ensure that you add
further selective selection criteria, for example a range for the document
date, a vendor and a company code. If runtime is still slow, ask your
system administrator to check for appropriate database indexes.
2. In the list of all invoices that are currently being processed, click the small arrow
on the right side of the Choose Layout button.
4. In the Change Layout dialog box, select the Current Role column and use the
arrow buttons to set this column at the first position of the Displayed Columns
pane.
5. Select the Number of Documents column and use the arrow buttons to set this
column at the second position of the Displayed Columns pane.
6. Select the Aggregation check box for the Number of Documents column.
8. In the Results list, select the first column header (the Current Role column) and
press the Subtotal button to get subtotals per role.
You may want to see the lines with the subtotals as a summary without the
documents in between. In this case, continue with the following steps.
9. Click the small arrow on the right side of the Subtotal button.
11. In the Determine drilldown totals level dialog box, select Level 1 Current
Role.
13. You may want to know which invoice documents there are in detail for one
role. In this case, click the icon next to the current role.
You may want to return to the view where all documents are shown with
subtotals. In this case, continue with the following steps.
14. Click the small arrow on the right side of the Subtotal button.
16. In the Determine drilldown totals level dialog box, select Level 0 Non-total
lines.
Note: You can save your preferred layout with the Save Layout option of
the Choose Layout button.
Important
If you have thousands or even millions of invoices, ensure that you enter
selective selection criteria. If runtime is still slow, ask your system
administrator to check for appropriate database indexes and the
configuration of the VAN report.
2. Click the small arrow on the right side of the Choose Layout button.
4. In the Change Layout dialog box, select the Vendor column and use the arrow
buttons to set this column at the first position of the Displayed Columns pane.
5. Select the Processing Time (in Sec) column and use the arrow buttons to set
this column at the second position of the Displayed Columns pane.
7. Select the second column header (the ProcTime column) in the Results list, and
click the small arrow on the right side of the Total button.
8. If you want to get the average processing time of documents per vendor, click
Mean Value.
If you want to get the maximum processing time of documents per vendor, click
Maximum.
9. In the Results list, select the first column header (the Vendor column) and click
the Subtotal button to get the subtotals per vendor.
You may want to see the lines with the subtotals as a summary without the
documents in between. In this case, continue with the following steps.
10. Click the small arrow on the right side of the Subtotal button.
12. In the Determine drilldown totals level dialog box, select Level 1 Vendor.
You may want to return to the view where all documents are shown with
subtotals. In this case, continue with the following steps.
15. Click the small arrow on the right side of the Subtotal button.
17. In the Determine drilldown totals level dialog box, select Level 0 Non-total
lines.
Note: You can save your preferred layout with the Save Layout option of
the Choose Layout button.
[Link] Example 3: Getting the total invoice amount per company code,
separated in PO and Non PO invoices
You want to see the total invoice amount per company code. For every company
code, you want to have a subtotal for PO based and for Non PO based invoices.
Getting the total invoice amount per company code, separated in PO and NPO
invoices:
Important
If you have thousands or even millions of invoices, ensure that you enter
selective selection criteria. If runtime is still slow, ask your system
administrator to check for appropriate database indexes and the
configuration of the VAN report.
2. Click the small arrow on the right side of the Choose Layout button.
4. In the Change Layout dialog box, select the Company Code column and use the
arrow buttons to set this column at the first position of the Displayed Columns
pane.
5. Select the Invoice Type Text column and use the arrow buttons to set this
column at the second position of the Displayed Columns pane.
6. Select the Total Amount in Rep. Crcy column and Reporting Currency, and use
the arrow buttons to set theses columns at the third and fourth position of the
Displayed Columns pane.
7. Select the Aggregation check box for the Total Amount in Rep. Crcy column.
9. Select the first column (Company Code) and the second column (Invoice Type
Text) in the Results list and click the Subtotal button to get subtotals for the
company code and invoice type combination.
You may want to see the lines with the subtotal as a summary without the
documents in between. In this case, continue with the following steps.
10. Click the small arrow on the right side of the Subtotal button.
12. In the Determine drilldown totals level dialog box, select Level 1 Invoice Type
Text.
14. You may want to know which invoice documents there are in detail for one
company code and invoice type combination. In this case, click the icon next
to the invoice type text.
All invoice documents of this company code and invoice type combination are
shown.
You may want to return to the view where all documents are shown with
subtotals. In this case, continue with the following steps.
15. Click the small arrow on the right side of the Subtotal button.
17. In the Determine drilldown totals level dialog box, select Level 0 Non-total
lines.
Note: You can save your preferred layout with the Save Layout option of
the Choose Layout button.
• When working without ABAP Core Data Services views (ABAP CDS
views), the selection fields Overall Process Status and Maximum
Number of Records are not working as restrictive selection criteria. Find
more details in Selection fields for the Overall Process Status
VIM Analytics There are additional recommendations when VIM Analytics was configured to work
without ABAP without ABAP CDS views on your system.
CDS views
Tips
• On a SAP® HANA database system, you can easily check if VIM Analytics
was configured to work with ABAP CDS views: Have a look at the title of
VIM Analytics. If it is VIM Analytics powered by SAP HANA, VIM
Analytics works with the ABAP CDS views. If it is VIM Analytics, VIM
Analytics does not use ABAP CDS views.
• On any database system different to SAP HANA, contact your system
administrator to get the information if VIM Analytics was configured to
work with ABAP CDS views or not.
The VIM Analytics Current Liability Report is part of VIM Analytics. It offers you a
clear data report on documents that are parked in the system. The purpose of the
Current Liability Report is to provide the Accounts Payable department with
accurate information about the current liabilities at any point in time.
As a primary use, the Current Liability Report helps the Accounts Payable
department to do the accruals at month or period end. The Current Liability Report
provides you with various views of the data, enabling you to analyze the liability
information from various forms. The various views address the different accrual
procedures used by various companies.
The Current Liability Report considers parked invoice documents and optionally
credit memos that are in parked status. It also considers DP documents that were
created but have not been processed as SAP documents. Both PO invoices and Non
PO invoices are supported. There are various controls within the report, allowing
you to calculate sub totals, or to download to Excel.
You can restrict the output to lines that are within a certain amount range. This is
useful if your company’s internal policy is to ignore all lines that are below a certain
money limit.
Note: Your screen might look different as you can configure what
selection fields should appear in the screen, using the Edit menu in the
menu toolbar.
Application toolbar
In the Application toolbar, the following button is available:
Execute the query. This action opens the report views screen, based on the
search criteria entered in the selection field panel.
Notes
• Your screen and the selection criteria might differ from the screenshot.
• For search criteria with two entry fields joined by a to, you can enter a value
range.
• If you run the query without entering any criteria, the report will consider all
criteria values.
• The following list only covers elements whose meaning is not obvious.
General Information
Include Documents
In this panel, enter search criteria regarding which documents should be included.
DP In Process
Select this check box to include DP documents that are still in process in the
result, for example, a document without an SAP document number that is not
deleted.
Note: If you are searching for DP documents by selecting the DP In
Process check box, the Company Code, Vendor, and Fiscal Year search
criteria are also considered when querying for DP documents.
In this panel, enter search criteria for the invoice's header item.
Document Number
Enter the accounting document number of the invoice.
Fiscal Year
Enter the fiscal year when the invoice was blocked or parked.
DP Information
In this panel, enter search criteria for the Document Processing information.
Tip: Where applicable, click the icon for a list of available values.
Views
Groupings
Header Groups
Allows you to group the result based on the header level; see “Document header
grouping” on page 79.
Line Groups
Allows you to group the result based on the line level; see “Document lines
grouping” on page 81.
You can select views and groupings in the Report View Group By field of the
selection screen, see “General Information” on page 71. But also in the report views
screen, you can toggle between views and groupings in the menu bar and the
application toolbar.
Executing a search in the selection screen displays the report views screen, based on
the search criteria entered in the selection field panel.
Switch
Toggle sections in the report views screen on and off:
Header Off/Header On
Hide and unhide the Overview section.
Total On/Total Off
Hide and unhide the display of the Total in the report views screen.
The Related List for the Chosen Items shows details of the documents that belong
to the chosen grouping. There are two different panels in the screen:
Note: The DP Information panel only appears if you have selected the DP
In Process check box in the General Information panel of the selection
field panel. Moreover, the report views screen must be grouped By
Company Code or By Vendor.
In the example screenshot, the panel shows all DP documents that belong to
Company Code 3000 and Vendor 3000 from the ALV Grid.
Note: You might notice that when you switch from one view to another view,
the total number of items does not equal or some of the items are missing. This
is by design; some of the items might be missing the appropriate grouping
column. For example, if you choose WBS Element grouping and the item does
not have any WBS Element, it will not be included in the Group View by WBS
Element.
To display the SAP Document Header View, click SAP Doc View in the application
toolbar.
The SAP Document Header View comprises the following columns in the ALV
Grid:
Note: The following list only covers columns whose meaning is not obvious.
Reference #
Reference number of the vendor
Total Amount
Gross amount specified in the header level
Line Amount
Line amount of the invoice
# of Lines
Total number of lines in the SAP document. In case of PO invoices, it is the
number of PO lines in the invoice. In case of Non PO invoices, it is the number
of G/L lines.
User Name
User who created the invoice
To display the SAP Document Lines View, click SAP Lines View in the application
toolbar.
The SAP Document Lines View comprises the following columns in the ALV Grid:
Note: The following list only covers columns whose meaning is not obvious.
Invoice Item
Line item of the invoice
Balance Sheets Account
Balance Sheets Account, if field is checked
Cost Center
Number of the Cost Center
Internal Order
Internal Order of the invoice's line item
WBS element
WBS Element of the invoice's line item
Line Amount
Amount from the invoice lines in reporting currency
Posting key
Type of transaction that is entered in a line item
Network
Network number for account assignment
Debit/Credit Ind.
Debit or Credit indicator: S = debit; H = credit
Activity
Activity of the invoice's line item
Chart of Accounts
Key that uniquely identifies a chart of accounts
Controlling Area
Highest organizational unit in Controlling
Purchasing Document
Purchase Order document ID
Item
Number that uniquely identifies an item in a purchasing document
Note: If you have entered search criteria other than Fiscal Year, Company
Code and Vendor in the selection screen, those other criteria are not
considered in the DP Information View because those criteria are not relevant
in DP documents.
The DP Information View comprises the following columns in the ALV Grid:
Note: The following list only covers columns whose meaning is not obvious.
Document ID
DP document number
Credit Memo
An X in this column indicates that the DP document is a credit memo.
Document Date
Date when this DP document was created
Reference
Reference number of the vendor
Purchasing Document
PO of the document
• Company Code
• Vendor
To group the report results by Company Code or Vendor, click the appropriate
Group by button in the application toolbar. The following example screenshot
shows a grouping by Company Code.
A section In the A section of the example screenshot, all items have a Company Code, a
Vendor # and a Vendor Name assigned. This indicates that all documents are
already processed and have a Company Code and a Vendor Number. If you have
selected the DP In Process check box in the General Information panel of the
selection field panel, the row will also include DP items. These DP items have been
indexed with both Company Code and Vendor Number.
B section In the B section of the example screenshot, all items have no Company Code and no
Vendor # assigned. The Vendor Name is DP not Indexed. This indicates that the
documents in this section are DP documents that were created but not indexed at all.
Note: This section is displayed only if you have selected the DP In Process
check box in the General Information panel of the selection field panel.
The document header grouping comprises the following columns in the ALV Grid:
Note: The following list only covers columns whose meaning is not obvious.
# of Docs
Number of documents in the group
Total Amount
Gross amount specified in the header level
Line Amount
Amount from all invoice lines of the invoice
Example: If you select the grouping By Cost Center/ GL account, the result is grouped based
on the Cost Center first and then based on the GL Account.
To group the report results by document lines, click the appropriate menu entry in
the Line Groups menu. The following example screenshot shows a grouping By
Cost Center/ GL account.
The document lines grouping comprises the following columns in the ALV Grid:
Notes
• The following list only covers columns whose meaning is not obvious.
• Depending on the grouping, some of the columns might not be displayed.
Internal Order
Internal Order number of the invoice's line item
WBS Element
WBS Element of the invoice's line item
Network
Network ID
Activity
Activity ID
G/L Account
General Ledger Account
# of Lines Included
Number of accounting lines in the group
Line Amount
Amount from all invoice lines of the invoice
The Automation Report is a tool that provides data about automated and manual
processing steps of OpenText VIM for SAP documents.
Note: The Automation Report has been designed to track documents coming
in using a channel that includes OCR extraction. If no OCR extraction has been
done for the document, you do not find the document in the Automation
Report.
The data is contained in table /OPT/VT_ATM_SRC. The table is filled by the ATM
collection report, which can be scheduled in the background. For details about the
ATM collection report, see Section 29 “Automation report” in OpenText Vendor
Invoice Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
The program “Automation Report” allows to view and export the table contents.
The current version of the Automation Report does not do any counting or
calculation.
2. In the Automation Report selection field screen, configure parameters for the
report.
Invoice Information
Report Options
Layout
Select one of the defined layouts if you have saved a personal layout using
the ALV grid control, before. For more information, see “Custom layouts
for the ALV grid” on page 89.
Notes
• Change documents for object class /OPT/VIM_IDXDAT build the basis of data
for the automation report.
• Change documents are technically stored in two SAP tables: CDHDR for the
header data and CDPOS for the detailed data.
• Invoice data
• Automation data
Invoice data
Note: Fields that are marked with an asterisk in the tables are not visible in the
screenshot.
Automation data
Note: Fields that are marked with an asterisk in the table are not visible in the
screenshot.
The Invoice Life Cycle Report (ILC) is a tool that provides data about the complete
life cycle of a OpenText VIM for SAP document. All OpenText VIM for SAP
processes that a document goes through can be monitored using the ILC.
The source data for the ILC is contained in the /OPT/VT_ILC_SRC table. This table is
filled by the ILC collection report, which can be scheduled in the background. For
details about the ILC collection report, see Section 7.1.2 “Scheduling batch jobs for
Invoice Life Cycle” in OpenText Vendor Invoice Management for SAP Solutions -
Administration Guide (VIMZ-AGD).
2. In the Life Cycle Report selection screen, configure the following parameters
for the report:
Process Data
Document ID
Enter the DP ID of the document in OpenText VIM for SAP.
Company Code
Enter the company code in the DP document.
Vendor
Enter the vendor in the DP document.
Document Date
Enter the date of the document.
DP Document Type
Enter the document type of the DP document (NPO_S4, PO_S4, and so on).
Process Type
Enter the current exception of the document (for example Invalid vendor
number or Invalid UOM).
Document Status
Enter the current status of the DP document (for example Posted, Indexed,
or Obsolete).
Fiscal Year
Enter the fiscal year of the document.
Current Agent
Enter the current agent with whom the document is currently available.
Current Role
Enter the current role with whom the document is currently available.
The ILC report can be displayed in 2 forms based on the following selection:
Layout
Note: To get the data in ILC, the ILC collection report must be executed once in
Full mode to get the data in the source table.
VIM Analytics
Click this button to navigate to VIM Analytics for the selected documents.
Sync
Click this button to update the source table for the selected document instantly.
This is useful if any changes have been made in the DP and the ILC collection
report has not been run.
Note: If you do not want to update the document instantly in the source
table using the Sync button, it is updated when the ILC collection report
runs again the next time.
Hierarchy ALV In the current version, the hierarchy ALV does not provide any add-on functionality
in the ALV grid control, apart from the standard ALV grid options.
• The first line for all documents is the header line. It contains the fields that are
common for all logs, such as Company Code, Vendor, DP Document Type, and
so on.
• The lines after the header line contain the information of the work item. All the
processes that the DP document has gone through, are displayed in descending
order. This means, the latest work item is displayed on top. The work item
information lists the respective exceptions, status, responsible agents, and so on.
Hierarchy ALV Like in the classical ALV, the results are displayed with header and work item data
separated.
The first line always shows the header. Click the + icon to expand the details and
display the work item data.
Description (column
Technical field name Meaning - usage - notes
name)
DP document number to
identify the document. The
DOCID Document ID
document ID matches /OPT/
VIM_1HEAD.
Description (column
Technical field name Meaning - usage - notes
name)
The logical system for which
the ILC is run. (currently not
LOGSYS Logical system
supporting multiple backend
systems)
The SAP accounting document
Accounting document
BELNR_FI number for the DP from /OPT/
number
VIM_2HEAD
Description (column
Technical Field Name Meaning - Usage - Notes
name)
The ID of the work item logs, the
LINEID Line number
order in which they were executed.
Description of the action from /
FUNC_TEXT Function text
OPT/VT_ILC_SRC
Log type (DP, AP, BL, and Type of work item log from /OPT/
LOGTYPE
so on) VT_ILC_SRC
Description (column
Technical Field Name Meaning - Usage - Notes
name)
The actual start date of the WI
START_DATE Actual start date
process
The actual start time of the WI
START_TIME Actual start time
process
The actual end date of the WI
END_DATE Actual end date
process
The actual end time of the WI
END_TIME Actual end time
process
Time taken for the WI process to be
completed
Processing time (in
PROCTIME Calculated only for the dialog
seconds)
processes and not for background
processes
Selection screen
You control all functions of the particular report using a common selection
screen.
Note: In the Key Process Analytics Report, the selection is integrated into
the main screen that also shows the individual report panels. However, the
functionality is equal to the other reports.
Report screen
The report screen comprises: Header Section, ALV Grid Control, Report Results
(ALV Grid), and Details Screen
Notes
• In the Central Audit Report, only ALV Grid Control and Report Results
(ALV Grid) are available.
• The Key Process Analytics Report does not display the results in a report
screen but in individual report panels; see “Using the individual report
panels” on page 112.
The selection screen opens. It comprises the application toolbar and the selection
field panel.
Application toolbar
You can perform the following action:
Execute.
The report creates and displays a report, using the current settings in the
selection field panel.
Tips
Channel or Channel ID
Enter the Channel ID. The channel indicates the input mode of invoices into
OpenText VIM for SAP. For example, the channel ID IDOC stands for
invoices imported using Electronic Data Interchange.
This parameter is not available in the Summary Report.
Currency or Reporting Currency
Mandatory field. Enter the currency for the report. The amounts of all
documents will be translated into this currency, using the exchange rate
valid at the Currency Translation Date.
The currency parameters are not available in the Central Audit Report, the
Productivity Report, and the Aging Report.
Layout
Enter the layout for the report if you have saved a personal layout using the
ALV grid control, before.
Header Section
The header section of the report screen displays date and time of the last update,
and of the current run of the respective report.
Tip: If you feel the data needs to be updated, contact your administrator.
For some reports, the header section also shows the selection criteria that you
have entered in the selection field panel.
Details Screen
The details screen differs for the particular reports. The following button in the
ALV grid control of the details screen is common for all reports that have a
details screen (except the Aging Report):
Image
You can display the scanned image of the original invoice of a OpenText
VIM for SAP document in the Image Viewer that is installed and configured
on your desktop: Select a line in the table and click Image.
For individual settings of the details screens, see the respective Details Screen
sections of the particular reports.
Notes
• The Key Process Analytics Report does not display the results in a report
screen but in individual report panels; see “Using the individual report
panels” on page 112.
• In the Central Audit Report, only ALV Grid Control and Report Results
(ALV Grid) are available.
1
Header section
2
ALV grid control
3
Report results (ALV grid)
For a description of the elements that are common for all reports, see “Using the
report screen” on page 99.
In process
• Approval
Pre Processed
Processed
• Posted
Others
• Cancelled
• Deleted
• Confirmed Duplicate
• Obsolete
• Rescan Complete
Tip: The selected line in the ALV Grid must contain data. Otherwise, the
Summary Report drill down list cannot be displayed.
The Central Audit Report is a slimmed VIM Analytics (VAN). The main difference
to VAN is that the Central Audit Report serves as a single point of access in a
multiple backend scenario. Therefore, you must run the Central Audit Report in the
central system. The Central Audit Report lists documents from all systems, central
and satellite. By 2 clicks in the Central Audit Report's report screen, you can directly
access VAN on the respective satellite system. You do not have to log on to the
satellite system, when using trusted RFC connections.
Note: Ask your administrator whether trusted RFC connections are used. The
administrator can configure RFC connections, using the System Landscape
Directory (SLD).
The selection screen of the Central Audit Report contains the most important
selection fields of VAN. Additionally, it provides an additional selection field for the
systems of a multiple backend scenario.
Note: The Central Audit Report considers only documents that have a DP
document number.
Workflow Log
Select a document's line in the ALV Grid and click this button to display
detailed workflow information.
Image
Select a document's line in the ALV Grid and click this button to display the
scanned image of the original invoice in the Image Viewer installed and
configured on your desktop.
Dashboard
Select a document's line in the ALV Grid and click this button to access the
OpenText unified dashboard.
Link to VAN
Select a document's line in the ALV Grid and click Link to VAN to open VAN
for the selected document, see “VIM Analytics: Detailed Invoice Report“
on page 33.
In a multiple backend scenario, VAN is opened directly on the system where the
document resides. You do not have to log on to the system, when using trusted
RFC connections.
Note: Ask your administrator whether trusted RFC connections are used.
The administrator can configure RFC connections, using the System
Landscape Directory (SLD).
Logical System
The Logical System column at the very left of the ALV Grid indicates on which
system in the multiple backend system the document resides.
MultiAgent
The column MultiAgent might be marked for a document. This indicates that
more than one agent is assigned to the document. In this case, click the link in
the Current Role column to display the IDs and names of the assigned agents.
The Key Process Analytics Report reports about a variety of key figures regarding
the OpenText VIM for SAP process: It shows the accumulated amounts of all
documents in the DP workflow, in parked state and in posted state.
The individual report panels of the Key Process Analytics Report highlight the
following aspects:
Total Liability
This panel provides an overview of the total liability.
Amounts that are exceeding certain thresholds are highlighted in orange or red.
Your administrator can customize these thresholds.
Processed / In Process Documents
This panel provides an overview of OpenText VIM for SAP invoices, processed
and currently in process.
If the number or percentage of processed or in process documents exceeds
certain thresholds, the respective cells are highlighted in orange or red. Your
administrator can customize these thresholds.
Channel Analysis
This panel provides an overview of OpenText VIM for SAP invoices per
channel.
First Pass
This panel provides an overview of first pass OpenText VIM for SAP invoices,
that means OpenText VIM for SAP invoices that could be posted without any
exceptions.
If the number or percentage of first pass OpenText VIM for SAP invoices goes
below certain thresholds, the respective cells are highlighted in orange or red.
Your administrator can customize these thresholds.
Top Exceptions by Count
This panel provides an overview of the most frequent exceptions during the
OpenText VIM for SAP process. You can select the number of exceptions to be
listed.
Top Vendors by Amount
This panel provides an overview of the vendors with the highest purchase
amount, based on the gross amount of all OpenText VIM for SAP invoices. You
can select the number of vendors to be listed.
The Key Process Analytics Report supports the conversion of amount fields to
different currencies.
You can display report data as graphics, using standard SAP ALV grid functionality.
You can choose between different chart types, for example bar chart or pie chart.
The main screen comprises the application toolbar, the Frame Selection panel
and the individual report panels.
For a description of the elements that are common for all reports, see “Using the
selection screen” on page 97.
Application toolbar
You can perform the following action:
Refresh.
Alternatively, press the RETURN key.
The Key Process Analytics Report creates and displays a report, using
the current settings in the Frame Selection panel. The report results
are displayed in the individual report panels.
Note: A new selection from the database is triggered only if you
change the selection criteria.
• If the report is too slow, you can try to increase the parameter, for
example to 20,000.
• If the report is terminating, you can try to decrease the parameter,
for example to 5,000.
The individual report panels in the main screen get populated with data.
All report panels are displayed using the standard SAP ALV list viewer with the
respective ALV grid control. The ALV grid control provides various standard SAP
buttons for the ALV list viewer. For example, you can change the layout of the
report, move, remove or add columns.
Category
The following states of documents are listed:
• Blocked Documents
• Parked Documents
• Pre-Process Documents (all documents that are still in process and did not
yet result in an SAP invoice)
Total Amount
Total Amount of all documents
Crcy
Reporting Currency, as selected in the Frame Selection panel
Details To show details for a specific cell in the Total Amount column, double-click the cell
in the ALV grid. The Document List opens, showing detailed information on the
OpenText VIM for SAP documents of the Category referred to in the selected cell.
Tips
• The selected cell in the ALV grid must contain data. Otherwise, the
Document List cannot be displayed.
• For the columns Category and Crcy, no document lists are available.
Threshold func- In the Total Liability panel, the threshold functionality is available. Your
tionality administrator can define threshold values for an attention status and a critical status.
If the attention value is exceeded in a cell, the cell is highlighted in orange. If the
critical value is exceeded in a cell, the cell is highlighted in red.
Invoice Type
• PO Invoices
• NPO Invoices
• Unclassified
Total # Processed
Total number of invoices that are already processed, that means with status
Posted.
You can add the following columns using the ALV grid control:
PO Based
Indicator if the invoice is PO based or not. Possible values: Y for Yes, N for No, U
for Unclassified.
This column can be useful if you export the data, for example to Microsoft Excel.
Processed (%)
Percentage of invoices that are already processed, that means with status
Posted.
In Process (%)
Percentage of invoices that are currently in process
Details To show details for a specific cell, double-click the cell in the ALV grid. The
Document List opens, showing detailed information on the OpenText VIM for SAP
documents according to Invoice Type and Document Status referred to in the
selected cell.
Tip: The selected cell in the ALV grid must contain data. Otherwise, the
Document List cannot be displayed.
The ALV grid control in the Document List contains the following button:
Image
You can display the scanned image of the original invoice of a OpenText VIM
for SAP document in the Image Viewer installed and configured on your
desktop: Select a line in the table and click Image.
Threshold func- In the Processed / In Process Documents panel, the threshold functionality is
tionality available. Your administrator can define threshold values for an attention status and
a critical status. If the attention value is exceeded in a cell, the cell is highlighted in
orange. If the critical value is exceeded in a cell, the cell is highlighted in red.
The Channel Analysis panel provides an overview of OpenText VIM for SAP
invoices by Channel ID. The channel indicates the input mode of invoices into
OpenText VIM for SAP, for example OCR. The Channel Analysis panel comprises
the following columns:
Note: The following list only covers columns whose meaning is not obvious.
Channel ID
Channel ID, for example IDOC for invoices imported using Electronic Data
Interchange
Channel Text
Description of the channel
Total # Unclassified
Total number of unclassified invoices (not yet classified as PO or NPO invoices)
You can add the following columns using the ALV grid control:
PO Invoices (%)
Percentage of PO invoices
NPO Invoices (%)
Percentage of NPO invoices
Unclassified (%)
Percentage of unclassified invoices
Details To show details for a specific cell, double-click the cell in the ALV grid. The
Document List opens, showing detailed information on the OpenText VIM for SAP
documents, according to Invoice Type and Channel ID referred to in the selected
cell.
Tip: The selected cell in the ALV grid must contain data. Otherwise, the
Document List cannot be displayed.
The First Pass panel provides an overview of first pass OpenText VIM for SAP
invoices, that means OpenText VIM for SAP invoices that could be posted without
any exceptions. The following types of exceptions can happen:
Not every DP process type, parking reason and blocking reason is automatically
seen as an exception. Which DP process type, which parking reason and which
blocking reason is actually treated as an exception, is defined in the configuration of
exceptions for Central Reporting. For more information, see Section 30.5 “Activating
Central Reporting Baseline and maintaining reporting tables” in OpenText Vendor
Invoice Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD), especially “To maintain exceptions for Central Reporting” and “To map
exceptions for several back end systems”.
Note: The following list only covers columns whose meaning is not obvious.
You can add the following columns using the ALV grid control:
PO Based
Indicator if the invoice is PO based or not. Possible values: Y for Yes, N for No.
This column can be useful if you export the data, for example to Microsoft Excel.
Details To show details for a specific cell, double-click the cell in the ALV grid. The
Document List opens, showing detailed information on the OpenText VIM for SAP
documents, according to the Invoice Type referred to in the selected cell.
Tips
• The selected cell in the ALV grid must contain data. Otherwise, the
Document List cannot be displayed.
• There is no Document List available for the column Total # Documents.
Threshold func- In the First Pass panel, the threshold functionality is available. Your administrator
tionality can define threshold values for an attention status and a critical status. If the value in
a cell falls below the attention value, the cell is highlighted in orange. If the value in
a cell falls below the critical value, the cell is highlighted in red.
The Top Exceptions by Count panel provides an overview of the most frequent
exceptions during the OpenText VIM for SAP process.
You can select the number of exceptions to be listed in the panel. Therefore, the ALV
grid control of the Top Exceptions by Count panel provides the Top button:
Top
Click this button to select the number of exceptions that are listed. Possible
values: 3, 5, 10, or 20
Note: The following list only covers columns whose meaning is not obvious.
Exception ID
ID of the exception in the system
Exception Text
Description of the Exception
Details To show details for a specific line, double-click the line in the ALV grid. The Work
Items with Exception List opens, showing detailed information on the work items,
according to the Exception ID referred to in the selected line.
The Top Vendors by Amount panel provides an overview of the vendors with the
highest purchase amount, based on the gross amount of all OpenText VIM for SAP
invoices.
You can select the number of vendors to be listed in the panel. Therefore, the ALV
grid control of the Top Vendors by Amount panel provides the Top button.
Top
Click this button to select the number of exceptions that are listed. Possible
values: 3, 5, 10, or 20
Note: The following list only covers columns whose meaning is not obvious.
Name 1
Vendor name
Total Amount
Total amount for the vendor
Currency
Reporting Currency, as selected in the Frame Selection panel
You can add the following column using the ALV grid control:
Name 2
Only useful if this field is maintained for the vendors in the system
Details To show details for a specific line, double-click the line in the ALV grid. The
Document List opens, showing detailed information on the OpenText VIM for SAP
documents, according to the Logical System and the Vendor referred to in the
selected line.
The Exception Analysis Report reports all work items with exceptions, grouped by
exception, company code or vendor. The Exception Analysis Report provides the
following features:
• Finds and tracks exceptions with the highest impact on your business.
• Monitors how often exceptions occur.
• Finds companies or vendors who cause the highest number of exceptions.
• Indicates the invoice amount that is affected by work items with exceptions.
Time Characteristics
Date Range
Enter the date range you want to run the report for. The date refers to
the Created at date of the document.
Comparison Period
Click Previous Week, Previous Month, Previous Quarter or Previous
Year. The date refers to the Created at date of the document.
Grouping
Select the parameter to group the report by. Click Exception, Vendor or
Company Code.
For a description of the elements that are common for all reports, see “Using the
report screen” on page 99.
Group By
Click this button to change the grouping of the report. This has the same effect
as the Grouping settings in the selection screen. Click Exception, Vendor or
Company Code.
If the report is grouped by Vendor or Company Code, the logical systems are
displayed at the very left of the table, followed by the Vendor or Company Code
information. If the report is grouped by Exception, the Exception information is
displayed at the very left of the table.
Next to the right, the following columns are displayed, first for the selected period,
next for the comparison period, indicated by Previous Period or Prev. in the column
title:
Notes
• You can change the layout of the report results; for example, you can shift,
remove or add columns. So, your actual table might differ from the
following description.
• The following list only covers columns whose meaning is not obvious.
Total Amount
This value is recalculated from the original currency to the reporting currency.
Avg. Time
Average time of work on the work item
Avg. Wait Time
Average time elapsed on one OpenText VIM for SAP document before all the
work items related to this OpenText VIM for SAP document have been touched
by a user for the first time.
One OpenText VIM for SAP document can comprise several work items. Every
work item has a wait time before it is touched for the first time. The report sums
up these wait times and averages them.
Note: The columns containing time data display the time in <xx>d <xx>h
<xx>m <xx>s format. You can add corresponding columns that display the
time in seconds as a numeric value. This is useful, for example, if you want
to export data to an Excel spreadsheet.
Avg. # of Touches
Average number of how often the work item has been touched
Avg. # of Referrals
Average number of how often the work item has been referred to an agent
Tip: The selected line in the ALV Grid must contain data. Otherwise, the Work
Items with Exception List cannot be displayed.
The Productivity Report reports about the productivity of users/roles and the
activities of users/roles. The Productivity Report comprises the following features:
• Provides an overview of the processing times (total and average) and wait times
(average) per user/role.
• Enables the analysis of the average number of touches (per invoice) of users/
roles.
• Enables the analysis of the average number of referrals (per invoice) of users/
roles.
• Allows displaying a detailed list of:
Note: The time stamps that are used for the Productivity Report are based on
the time information in the SAP work item tables and are not directly related to
the time stamps in the OpenText VIM for SAP process history.
Agent Info
Agent ID
Enter the IDs of the agents (users) you want to run the report for.
Role ID
Enter the IDs of the roles you want to run the report for.
Org Object
Enter the Org object you want to run the report for. The Org object
refers to the organizational objects maintained in the standard SAP
Organizational Management. Using the icon, you can restrict the
value range to Organizational unit, Position, or Organizational units
and Positions (All).
Doc Characteristics
Click PO Invoices, Non-PO Invoices, or All Invoices (All Invoices includes
PO, Non PO and unclassified invoices).
Note: Unclassified invoices are not yet classified as PO or NPO
invoices.
Time Characteristics
Date Range
Enter the date range you want to run the report for. The date refers to
the Created at date of work items related to the OpenText VIM for SAP
document, not the execution/completion date.
Comparison Period
Click Previous Week, Previous Month, Previous Quarter or Previous
Year. The date refers to the Created at date of work items related to the
OpenText VIM for SAP document.
Grouping
Select the parameter to group the report by. Click Agent or Role.
For a description of the elements that are common for all reports, see “Using the
report screen” on page 99.
Group By
Click this button to change the grouping of the report. This has the same effect
as the Grouping settings in the selection screen. Click Agent or Role.
Note: The Validator role (ID 13) is not covered by the Productivity Report
although it is configured in the baseline. Data for this role is not shown in the
report results.
Report period Next to the right, the following columns are displayed for the report period:
results
Note: You can change the layout of the report results; for example, you can
shift, remove or add columns. So, your actual table might differ from the
following description.
Total # Processed
Number of OpenText VIM for SAP documents that have been worked on in the
report period. Work is not necessarily completed; that means, the invoice may
be already posted or not.
Reserved
Number of OpenText VIM for SAP documents that are reserved at the moment;
that means, at least one work item belonging to the OpenText VIM for SAP
document is reserved. The moment of time is determined by the last update of
the data.
The value in the Reserved column is a subset of the value in the In Process
column.
In Process
Number of OpenText VIM for SAP documents that have at least one work item
in the following states at the moment:
Comparison To the right of the report period columns, the following columns are displayed for
period results the comparison period (indicated by Prev. in the column title):
Tip: The selected cell in the ALV Grid must contain data. Otherwise, the
Document List cannot be displayed.
The Document List displays data for an Agent in a Logical System or a Role,
depending on the grouping of the report. Displaying the Document List for a cell is
possible in all columns, except the columns containing time data. The layout of the
Document List depends on the selected column.
The Aging Report reports about the aging of documents and work items in the
current system. The Aging Report comprises the following features:
• Provides an overview of the processing times of documents that have not been
posted without error.
• Provides a snapshot of documents that have not been posted and are still work in
process.
• Provides a snapshot of work items that are still work in process.
• Allows displaying a detailed list of:
Org Related
Channel
Enter the channel. The channel indicates the input mode of invoices into
OpenText VIM for SAP, for example OCR.
Doc Characteristics
Click PO Invoices, Non-PO Invoices, or All Invoices (All Invoices includes
PO, Non PO and unclassified invoices).
Vendor
Enter the vendor number, depending on the logical system.
Role ID
Enter the IDs of the roles you want to run the report for.
Grouping
Select the parameter to group the report by: Click Document Type or Role.
Report Options
Buckets (in Days)
The report results are displayed in 4 so-called buckets, each of them
representing a time range of how long documents or work items have
stayed in the system. Each bucket corresponds with a table column in
the report screen. By default, the following buckets are defined:
• 0 to 30 Days
• 31 to 60 days
• 61 to 90 days
• > 90 days
Using the Buckets (in Days) fields, you can change the limits for the
buckets. Replace the default values 30 / 60 / 90, according to your needs.
For example, the screenshot in “Using the report screen” on page 135
shows buckets that are defined with 50 / 75 / 100
For a description of the elements that are common for all reports, see “Using the
report screen” on page 99.
Group By
Click this button to change the grouping of the report. This has the same effect
as the Grouping settings in the selection screen. Click Doc Type or Role.
With Doc Type grouping, the data cells contain information about OpenText VIM
for SAP documents.
With Role grouping, the data cells contain information about work items.
Report results Next to the right, the following columns are displayed:
Note: You can change the layout of the report results; for example, you can
shift, remove or add columns. So, your actual table might differ from the
following description.
Description
Description of the document type if you have grouped by Doc Type.
Description of the role if you have grouped by Role.
0 to 30 Days
This is the default setting. You can change the setting, using the Buckets (in
Days) parameter in the selection field panel. See Buckets (in Days) on page 135.
Number of documents that are work in process and have been in the system for
0 to 30 days.
31 to 60 Days
This is the default setting. You can change the setting, using the Buckets (in
Days) parameter in the selection field panel. See Buckets (in Days) on page 135.
Number of documents that are work in process and have been in the system for
31 to 60 days.
61 to 90 Days
This is the default setting. You can change the setting, using the Buckets (in
Days) parameter in the selection field panel. See Buckets (in Days) on page 135.
Number of documents that are work in process and have been in the system for
61 to 90 days.
>90 Days
This is the default setting. You can change the setting, using the Buckets (in
Days) parameter in the selection field panel. See Buckets (in Days) on page 135.
Number of documents that are work in process and have been in the system for
more than 90 days.
With Doc Type grouping, the Document List opens, showing detailed information
on the OpenText VIM for SAP documents referred to in the selected cell. The
Document List shows documents with a specific Logical System and Document
Type.
With Role grouping, the Work Items with Exception List opens, showing detailed
information on the work items referred to in the selected cell. The Work Items with
Exception List shows work items with a specific Role.
Tips
• The selected cell in the ALV Grid must contain data. Otherwise, the
Document List or Work Items with Exception List cannot be displayed.
• Displaying the Document List or Work Items with Exception List for a cell
is possible in all columns with numeric values, except the cells containing
the Total.
• The layout of the Document List or Work Items with Exception List
depends on the selected column.
The Intermediate Data Report provides the option to view the intermediate
processing data for Central reports, before aggregation of data. Intermediate data
can be displayed for the following reports:
• Aging Report
• Summary Report
• Central Audit Report
• Exception Analysis Report
• Key Process Analytics Report
• Productivity Report
Central Report
Select the report for which you want to view intermediate data.
Common Data
This options in this section apply to all available reports. For a description of the
elements that are common for all reports, see “Using the selection screen”
on page 97.
Report-specific data
The section at the bottom of the screen contains options specific to the central
report you selected.
The reports show only intermediate data with fields particular to each individual
report from the selection.
Capture Analytics reports the key figures of the extraction process in Inbound phase
based on the feedback results.
• Provides the inbound information like channel, handle ID, classification ID,
document layout ID.
• Provides the process information like Document ID, document type, start date,
and so on.
• Provides the business data of the invoice document like Company Code, Vendor,
SAP document number.
• Provides Capture generic key figures, for example how many header/item fields
are extracted, how many are correct, the rate of correct extraction of all header/
item fields.
• Provides Capture invoice-specific key figures, for example how many times a
certain field is extracted, how many times it is correctly extracted and the rate in
% of correct extraction of the field.
• Provides the Details Pane where some additional information of a process is
provided: the image, the line items, the history and comments.
• A selection screen is provided for Capture Analytics. Selection fields like Doc ID,
Channel ID, Start Date, and business data fields allows you to select a subset of
documents for your needs. The selection field Start Date allows to restrict the
volume of documents, which can improve the performance of the report.
In order to add, remove, or change some fields in Capture Analytics, see Section 8
“Workplace Configuration” in OpenText Vendor Invoice Management for SAP Solutions
- Configuration Guide for Foundation (VIMZ-CGF).
In order to be able to work with the work center Supplier Invoices, users must be
authorized for the project ID of this work center. Additionally, only documents of
authorized company code will be displayed for them.
Authorization
Description Fields
Object
J_6NPF_PRJ
The authorized Project ID
J_6NPF_PRJ Open Text Business Center - Project ID
ACTVT '03'
Display
BUKRS
The authorized Company
OpenText VIM for SAP: Basic processing
J_6NIM_BC1 Code
authority by company code
ACTVT '03'
Display
Note: The authorization check for company codes is performed when Invoice
Solution authorization checks are globally activated with the Z constant 009 /
AUTH_CHECK_ACTIVE. For more details, see Section 6 “Authorization checks” in
OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD).
Using standard ALV functions, you can change the layout, do summarize, sorting,
and so on. You can also export the list to an external file.
Using the Show list, you can restrict the number of entries to be displayed.
The selection fields comprise process fields like Doc ID, Document Type, Channel
ID, Start date, Document Layout ID, and business data like Company Code, Vendor,
PO, document date, and so on.
Apply
Click this button after you enter some selection fields.
Edit
Click this button to edit the applied selection fields.
Reset
Click this button to erase all selection fields.
In the details pane, the following tabs are available, which display the Image, the
Line items, the History, the Comments, and the Comparison for each entry in the
ALV grid.
On the Comparison tab, you see the comparison either between extracted values
and validated values (Validation - Extraction), or between extraction values and
values in finished document (Process Finished - Extraction).
Capture Dashboard, along with Capture Analytics allows to evaluate the extraction
results, accuracy, and the effectiveness of the learning process of OpenText™
Capture for SAP® Solutions and OpenText™ Core Capture for SAP Solutions.
In the Comparison Mode some KPIs are colored based on the comparison results.
The coloring of compared KPIs is defined as following:
Group 1
KPIs indicating the extraction counts and rate of header fields or line item fields
or both per capture profile. These KPI are calculated based on data from solution
tables.
For each category the following numbers are provided with postfix:
Group 2
KPIs providing configuration aspects per capture profile. They provide numbers
of fields configured as required to be extracted, as optional to be extracted, or
sum of 2 numbers per capture profile. Those numbers can be changed with the
time depending on the configuration of the given capture profile. In the Capture
Dashboard the maximal value of them per capture profile in each selected
period is shown.
Available profile configuration numbers are listed in the following table:
Profile configuration
Name Description
numbers
Profile Configured Number of all header fields
Header Fields configured as required or optional
PRFL_H_ALL_CNT
to be extracted for the applied
Inbound Profile.
PRFL_H_REQ_CNT Profile Required Number of all header fields
Header Fields configured as required to be
extracted for the applied Inbound
Profile.
Profile Optional Number of all header fields
Header Fields configured as optional to be
PRFL_H_OPT_CNT
extracted for the applied Inbound
Profile.
Invoice Header Number of all header fields
Fields (including string lists like POs or
PRFL_IH_ALL_CNT DNs) configured as required or
optional to be extracted for the
applied Inbound Profile.
PRFL_IH_REQ_CNT Required Invoice Number of all header fields
Header Fields (including string lists like POs or
DNs) configured as required to be
extracted for the applied Inbound
Profile.
Profile configuration
Name Description
numbers
Optional Invoice Number of all header fields
Header Fields (including string lists like POs or
PRFL_IH_OPT_CNT DNs) configured as optional to be
extracted for the applied Inbound
Profile.
Profile Configured Number of all table item fields
Item Table Fields configured as required or optional
PRFL_TI_ALL_CNT
to be extracted for the applied
Inbound Profile.
Profile Required Number of all table item fields
Item Table Fields configured as required to be
PRFL_TI_REQ_CNT
extracted for the applied Inbound
Profile.
PRFL_TI_OPT_CNT Profile Optional Number of all table item fields
Item Table Fields configured as optional to be
extracted for the applied Inbound
Profile.
Profile Configured Number of all tax table item fields
Table 1 Fields configured as required or optional
PRFL_T1_ALL_CNT
to be extracted for the applied
Inbound Profile.
Profile Required Number of all tax table item fields
Table 1 Fields configured as required to be
PRFL_T1_REQ_CNT
extracted for the applied Inbound
Profile.
PRFL_T1_OPT_CNT Profile Optional Number of all tax table item fields
Table 1 Fields configured as optional to be
extracted for the applied Inbound
Profile.
Group 3
KPIs indicating the statistics of inbound processes per capture profiles. All
inbound statistics are calculated in each selected period. They are listed in the
following table:
Using standard ALV functions, you can change the layout, do summarize,
sorting, and so on. You can also export the list to an external file. In Comparison
Mode the sorting function is disabled.
To add, remove, or change some fields in the main screen, see Section [Link]
“Configuring Capture Dashboard” in OpenText Vendor Invoice Management for
SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
Using the Show list, you can restrict the number of entries to be displayed.
Notes
• If there are 2 evaluation points (VA and PF) available for one inbound
document, the evaluation point VA will be considered in the calculation.
This happens when an inbound process goes through the validation
step, and the corresponding solution process is posted.
• The Capture Dashboard is a calculation-intensive report, it is highly
recommended that the Capture Dashboard is visible only for the key
user. This can be achieved by assigning the Node ID only to the key user.
Refer to Section 8 “Workplace Configuration” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Foundation (VIMZ-
CGF).
• KPIs of Group 3 (Inbound Statistics) is calculated for the current
Inbound system. As a prerequisite, there is only one Inbound system. A
mixture of several Inbound systems is not supported.
• Some unexpected results could be observed in the Capture Dashboard
due to the following facts:
– The data set used for calculating the KPIs of group 1 and 2 is the
subset of the data set for KPIs of group 3. Even when the Inbound
processed are completed (counted as NO_DOC_COMPLETED), they
will be counted for calculating KPIs of group 1, only when they either
went through validation in Inbound, or the corresponding solution
processes are completed (or posted). This may lead to some
discrepancies in the numbers.
– Therefore, if Max Number of Docs is small and contains only
Processed Inbound Documents which are completed in inbound, but
either not going through validation, or the solution processes not
completed, then the Capture Dashboard will be empty.
To hide or to show the selection screen, click Hide Selection Pane or Show
Selection Pane provided in the menu bar.
The left part of the selection screen comprises business data fields like Company
Code, Vendor, and inbound fields like Capture Profile, Registration ID. They allow
the drill down evaluation of a certain subset of data.
The parameter Max Number of Docs indicates the number of inbound documents
that have been processed. Therefore, it helps to avoid too long processing time for a
big volume of data. All KPIs provided in the main screen and in the plugins are
calculated for this set of data. The most current inbound documents (the highest
Registration IDs) will be included in this set.
The right part of the selection screen comprises inputs relating to the selected period:
• Click Interval and select the time period available in the menu. All KPIs will be
calculated for inbound documents registered (started) in this time period. Time
period, for example, for Today or Yesterday is the time from 00-hour 00 minute
00 second to 23-hour 59 minute 59 second of that day.
• Select the Compare with the same period before check box if you want to
compare KPIs of the current selected period with the KPIs of the previous period.
Previous period is defined as the day/week/month/quarter/year before last day
(Today or Yesterday)/week/month/quarter/year.
• Click Date and enter the date range for which you want to see the KPIs. All KPIs
will be calculated for inbound documents registered (started) in this time period.
Date range from Date_1 to Date_2 is the time from 00-hour 00 minute 00 second
of Date_1 to 23-hour 59 minute 59 second of Date_2.
• Select the Compare with check box and enter the time range for which you want
to compare the KPIs.
Apply
Click after you enter some selection fields.
Edit
Click to edit the applied selection fields.
Reset
Click to erase all selection fields.
Some user-specific values like Max number of Docs, or Show hits in the Capture
Dashboard and sub-dashboards in plugins will be saved and be used for the next
call.
Note: The default value of Max number of Docs is 10000. For performance
reasons, if you apply a number higher than this default value, the default value
will be used in the next call.
To hide or to show the details pane, click the button Hide Details Pane or Show
Details Pane provided in the menu bar.
KPIs provided in the plugins are calculated based on the capture profile currently
selected in the Capture Dashboard and other input like time-period or comparison
options in the selection screen.
• Document Layouts: This sub-dashboard provides all KPIs listed in Group 1 and
Group 3. They are calculated per Layout ID (see “Using the Capture Dashboard”
on page 146).
• Vendors: this sub-dashboard provides all KPIs listed in Group 1 (see “Using the
Capture Dashboard” on page 146). They are calculated per Vendor.
Using standard ALV functions, you can change the layout, do summarize, sorting,
and so on. You can also export the list to an external file.
To add, remove, or change some fields in the main screen, see Section [Link]
“Configuring Capture Dashboard” in OpenText Vendor Invoice Management for SAP
Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
Using the Show list, you can restrict the number of entries to be displayed.
Legend
x
Available
-
Not available
(x)
Functionality in the Fiori app is not as comprehensive as in the Approval Portal.
Table 17-1: Approval Portal features compared to the Approve Invoices app
Note:
Parked
documents
x x
are
supported
in the
context of
DP process
only.
Held documents
(PO and Non PO)
Note: Held
documents
are x x
supported
in the
context of
DP process
only.
Posted documents
x x
(PO and Non PO)
Include credit
x x
memos
Include invoices
with mixed credit x x
and debit lines
Table 18-1: Approval Portal features compared to the Enter Cost Assignment
Advanced app
Fiori app -
Area Feature Portal Fiori app
comment
Not Not
designed for designed for
Description
Positioning and a specific a specific
target role role/person role/person
OpenText VIM for coder/ coder/
SAP role requester requester
Non PO based DP
x x
documents
(x -
PO based DP limitations,
-
documents requires
extension)
Parked documents
x -
(PO and Non PO)
Document types
Held documents
- -
(PO and Non PO)
Posted documents
- x
(PO and Non PO)
Credit memos x x
Mix of credit and
x x
debit lines
Basic data x x
Supports simple
Cost assignment x x and complex cost
assignment
Invoice Details
Attachments x x
Comments x -
Invoice history x x
Header based
Coding type x x
coding
Fiori app -
Area Feature Portal Fiori app
comment
Item based coding x x
Mix of cost object
x x
types
Cost object: Cost
x x
center
Cost object: Profit
x x
center
Cost object: WBS
x x
element
Fiori app -
Area Feature Portal Fiori app
comment
Semantic navigation
Fiori Launchpad (for example for
- x
features vendor ID or PO
number)
Requires
NetWeaver/SAP x -
Portal
This part covers details about the following objects that are part of the OpenText
VIM for SAP BW content for SAP NetWeaver Business Warehouse (SAP NetWeaver
BW):
• InfoObjects
• DataSources
• DataStore Objects (DSOs)
• MultiProviders
For more information, see Section 27 “SAP NetWeaver Business Warehouse content”
in OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD).
InfoObjects
• Key Figures
• Characteristics (including time characteristics and technical characteristics)
• Units
Technical data
Available as of 7.0
Release
Data element /B7999/OIKDURDAY
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
The key figure shows the amount of the SAP FI document (financial accounting
document) that was created from the OpenText VIM for SAP invoice in local
currency (0LOC_CURRCY), which means the currency of the company code.
Technical data
Available as of 7.0
Release
Data element /OPT/KIVGAFC
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Currency /OPT/UF_CURR
Technical data
Available as of 7.0
Release
Data element /B7999/OIKIVCT
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Technical data
Available as of 7.0
Release
Data element /B7999/OIKIVECT
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Technical data
Available as of 7.0
Release
Data element /B7999/OIKIVEXCT
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Technical data
Available as of 7.0
Release
Data element /B7999/OIKAPDURD
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Technical data
Available as of 7.0
Release
Data element /B7999/OIKAPDURS
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
Technical data
Available as of 7.0
Release
Data element /B7999/OIKTODURD
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
until the end of the DP process; this means the time from the start until the end of
the DP workflow.
Technical data
Available as of 7.0
Release
Data element /B7999/OIKTODURS
Aggregation Summation
Exception Summation
Aggregation
Calculation Cumulative value
Restriction No
19.2 Characteristics
Accounting Characteristic: 0AC_DOC_NO
document
number This characteristic shows the document number of the SAP invoice that was created
from the OpenText VIM for SAP invoice.
This characteristic classifies OpenText VIM for SAP invoices into different categories
according to their invoice amount. An example for an amount class from the
baseline is “Small amounts” for invoices below 10,000 EUR. The amount classes and
their ranges are maintained in the KPI Dashboard customizing in the leading SAP S/
4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICAMTCL
This characteristic shows the input channel of the OpenText VIM for SAP invoice.
The channels are maintained in the OpenText VIM for SAP customizing of the
leading SAP S/4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICCHANNL
This characteristic shows the company code of the OpenText VIM for SAP invoice.
IMG activity: Run the /n/OPT/SPRO transaction and navigate to OpenText Vendor
Invoice Management Invoice Solution > Cross Component Configuration >
Central Reporting > KPI Dashboard > Company Code Groups > Company Code
Groups Mapping (BW).
Technical data
Available as of 7.0
Release
Data element /B7999/OICCOCOGR
Technical data
Available as of 7.0
Release
Data element /B7999/OICCREACM
Reference 0CALMONTH
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICCREADT
Reference 0DATE
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICCREATM
Reference 0TIME
characteristic
Created at Characteristic:/OPT/CCREATE
(UTC Time
Stamp in Short
This characteristic shows the time stamp in UTC time (Coordinated Universal Time)
Form
(YYYYMMDDh when the OpenText VIM for SAP invoice was created.
hmmss))
Technical data
Available as of 7.0
Release
Data element /B7999/OICCREATE
Technical data
Available as of 7.0
Release
Data element /B7999/OICCMIND
Date for This characteristic shows the date that was used for the conversion of the gross
Conversion into invoice amount of an OpenText VIM for SAP invoice from the invoice currency into
Favorite
Currency the favorite currency. The favorite currency and the conversion date are determined
from the KPI Dashboard customizing in the SAP S/4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICCCDTFC
Reference 0DATE
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICDOCID
Technical data
Available as of 7.0
Release
Data element /B7999/OICDOCSTA
This characteristic shows the OpenText VIM for SAP document type of the
OpenText VIM for SAP invoice. The OpenText VIM for SAP document types are
maintained in the OpenText VIM for SAP customizing of the SAP S/4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICDOCTY
This characteristic shows the due date of the OpenText VIM for SAP invoice.
Technical data
Available as of 7.0
Release
Data element /B7999/OICDUEDT
Invoice exceptions that occur during the OpenText VIM for SAP process are
grouped in exception classes. This characteristic shows the exception class of an
exception. Examples for exception classes from the baseline are “Compliance issue”
and “Authorization mismatch”. The exception class is determined from the
exception class mapping in the KPI Dashboard customizing of the leading SAP S/
4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICEXCCL
This characteristic shows the exception ID of an exception that occurred during the
OpenText VIM for SAP process. The exception IDs are maintained in the Central
Reporting customizing in the leading SAP S/4HANA system. Technically, the
exception IDs represent DP process types, header blocks, line blocks or PO/NPO
parking reasons that are to be seen as exceptions.
Technical data
Available as of 7.0
Release
Data element /B7999/OICEXCEPT
Technical data
Available as of 7.0
Release
Data element /B7999/OICFINIDT
Reference 0DATE
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICFINITM
Reference 0TIME
characteristic
Technical data
Available as of 7.0
Release
This characteristic shows the fiscal year of the SAP invoice that was created from the
OpenText VIM for SAP invoice.
Technical data
Available as of 7.0
Release
Data element /B7999/OICPOBAS
Technical data
Available as of 7.0
Release
Data element /B7999/OICAPPIND
Technical data
Available as of 7.0
Release
Data element /B7999/OICBLKIND
Technical data
Available as of 7.0
Release
Data element /B7999/OICREFIND
Technical data
Available as of 7.0
Release
Data element /B7999/OICREJIND
Technical data
Available as of 7.0
Release
Data element /B7999/OICPARKCM
Reference 0CALMONTH
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPARKDT
Reference 0DATE
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPARKTM
Reference 0TIME
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPARKED
Technical data
Available as of 7.0
Release
Data element /B7999/OICPOSTCM
Reference 0CALMONTH
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPOSTDT
Reference 0DATE
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPOSTTM
Reference 0TIME
characteristic
Technical data
Available as of 7.0
Release
Data element /B7999/OICPOSTED
This characteristic shows the name of the logical system of the OLTP source system
(SAP S/4HANA system).
This characteristic determines whether key figures with duration stand for the
process time or the approval time. The time group definitions are maintained in the
KPI Dashboard customizing in the leading SAP S/4HANA system.
Technical data
Available as of 7.0
Release
Data element /B7999/OICTIMEGR
This characteristic shows the time type of a duration value. The time type classifies
durations within the OpenText VIM for SAP process. An example for a time type
from the baseline is “On time” for OpenText VIM for SAP invoices that have been
processed in 0 to 5 days. The time types are maintained in the KPI Dashboard
customizing in the leading SAP S/4HANA system. The compounded characteristic
Time Group determines whether the time type refers to the processing time or the
approval time.
Technical data
Available as of 7.0
Release
Data element /B7999/OICTIMETY
Compounding /OPT/CTIMEGR
Technical data
Available as of 7.0
Release
Data element /B7999/OICAPTITY
Technical data
Available as of 7.0
Release
Data element /B7999/OICTOTITY
Technical data
Available as of 7.0
Release
Data element /B7999/OICUPDTS
This characteristic shows the vendor the OpenText VIM for SAP invoice was sent
from.
This characteristic shows the vendor group, the OpenText VIM for SAP invoice is
assigned to. The vendor group classifies vendors into different groups regarding
their total invoice volume. An example for a vendor group from the baseline is
“Vendor Group A (high volumes)”. You maintain the vendor groups in the KPI
Dashboard customizing of the leading SAP S/4HANA system. You maintain the
mapping of vendors to vendor groups in the local SAP S/4HANA system of the
OpenText VIM for SAP invoice. If the vendor of the OpenText VIM for SAP invoice
is not assigned to a vendor group, the ABC indicator from the purchasing
organization data of the vendor master data is taken.
Technical data
Available as of 7.0
Release
Data element /B7999/OICVENDGR
19.3 Units
Currency of Unit: 0INV_CURR
Invoice
This unit shows the document currency of the OpenText VIM for SAP invoice.
Technical data
Available as of 7.0
Release
Data element /B7999/OIUF_CURR
Reference unit 0CURRENCY
This unit shows the local currency (this means the currency of the company code) of
the SAP FI document (financial accounting document) that was created from the
OpenText VIM for SAP invoice.
DataSources
A DataSource is a set of fields that provide the data for a business unit for data
transfer into an SAP NetWeaver BW system. DataSources can be divided into:
Technical data
This structure serves to consistently extract exception data to OpenText VIM for SAP
invoices from OpenText VIM for SAP to a SAP NetWeaver BW system. Only
exceptions of finished invoices (= DP workflow is finished) that are not obsolete or
canceled are extracted.
Technical data
Technical data
classes and their texts are maintained in the KPI Dashboard customizing of
OpenText VIM for SAP in the leading SAP S/4HANA system.
Technical data
Technical data
This structure serves to consistently extract the texts of input channels from
OpenText VIM for SAP to a SAP NetWeaver BW system. The channels and their
texts are maintained in the OpenText VIM for SAP customizing of the leading SAP
S/4HANA system.
Technical data
Technical data
Technical data
Extraction from No
Archives
Extraction by DB view/table /OPT/BT_CCGP
Extraction /OPT/ESVIM_COCO_ATTR0001
Structure
Technical data
Technical data
Extraction /OPT/ESVIM_DOCSTA_TEX0001
Structure
Technical data
Application OpenText VIM for SAP > Master Data
Component
Available as of 7.0 (SAP ERP 6.0)
Release
Delta-Capable No
Extraction from No
Archives
Extraction by DB view/table /OPT/VIM_T100T
Extraction /OPT/ESVIM_DOCTY_TEXT0001
Structure
Technical data
Application OpenText VIM for SAP > Master Data
Component
Available as of 7.0 (SAP ERP 6.0)
Release
Delta-Capable No
Extraction from No
Archives
Extraction by DB view/table /OPT/KAGR_C_EXCP
Extraction /OPT/ESVIM_EXCEPT_ATT0001
Structure
maintained in the Central Reporting customizing of OpenText VIM for SAP in the
leading SAP S/4HANA system.
Technical data
Technical data
Technical data
Technical data
Technical data
Technical data
Technical data
A DataStore object (DSO) serves as a storage location for consolidated and cleansed
transaction data or master data on a document (atomic) level. When being used as a
storage location for history reasons, the DSO may also store raw data.
The OpenText VIM for SAP BW content has been designed following the OpenText
VIM for SAP Layered Scalable Architecture (LSA), which groups the SAP
NetWeaver BW objects into different logical layers. The OpenText VIM for SAP LSA
is based on the SAP LSA. For details, see Section 27.1 “OpenText VIM for SAP
Layered Scalable Architecture (LSA)” in OpenText Vendor Invoice Management for SAP
Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD). The OpenText VIM
for SAP BW content uses DSOs in the Data Propagation Layer and in the Corporate
Memory Layer.
This DSO contains OpenText VIM for SAP invoice headers from the SAP S/4HANA
system on a granular level. The DSO is directly supplied from the DataSource /OPT/
VIM_DPDOC_H_TRAN.
Most relevant fields are updated in a 1:1 mapping into the DSO. Some fields
(amount class, company code group) are derived from the active tables of the Amount
Class DSO (/OPT/DPAMC) and the Company Group Mapping for Company Code DSO (/
OPT/DPCCG). Several time fields are derived from time stamps.
As a further source of the DSO, the DP Documents DSO (/OPT/DCDOC) from the
Corporate Memory Layer can be used for recovery purposes.
Data Sources/Data Targets – As a source of the DSO, the DP Documents DSO (/OPT/
DPDOC) and the Exceptions DSO (/OPT/DPEXC) are used.
Most relevant fields from the DP Documents DSO are updated in a 1:1 mapping into
the DSO. The exception class is derived from the active table of the Exception Class
Mapping for Exception DSO (/OPT/DPEID). If the DP document does not have any
exceptions, 0 is set as an initial value in the field Exception Class (/OPT/CEXCCL).
The exception specific fields from the Exceptions DSO are updated in a 1:1 mapping
into the DSO. The end routine adds DP document data from the active table of the DP
documents DSO (/OPT/DPDOC). The field Number of Invoices per Exception Class (/
OPT/KIVEXCT) is set to 1, which indicates that there is one invoice to this exception
class. Even if a DP document has several exceptions to an exception class, the invoice
is counted only once.
This DataStore object contains exceptions to OpenText VIM for SAP invoices from
the SAP S/4HANA system. The exception IDs are maintained in the Central
Reporting customizing in the leading SAP S/4HANA system. Technically, the
exception IDs represent DP process types, header blocks, line blocks or PO/NPO
parking reasons that are to be seen as exceptions.
Most relevant fields are updated in a 1:1 mapping into the DSO. The exception class
is derived from the active table of the Exception Class Mapping for Exception DSO
(/OPT/DPEID). As a further source of the DSO, the Exceptions DSO (/OPT/DPEXC)
from the Corporate Memory Layer can be used for recovery purposes.
Data Sources/Data Targets – As a source of the DSO, the DP Documents DSO (/OPT/
DPDOC) and the Exceptions DSO (/OPT/DPEXC) are used.
Most relevant fields from the DP Documents DSO are updated in a 1:1 mapping into
the DSO. The exception class is derived from the active table of the Exception Class
Mapping for Exception DSO (/OPT/DPEID). If the DP document does not have any
exceptions, the Exception ID field (/OPT/CEXCEPT) is kept empty and the field
Exception Class (/OPT/CEXCCL) is set to 0 as an initial value.
The exception specific fields from the Exceptions DSO are updated in a 1:1 mapping
into the DSO. The end routine adds DP document data from the active table of the DP
documents DSO (/OPT/DPDOC). The field Number of Invoices per Exception (/OPT/
KIVEXT) is set to 1, which indicates that there is one invoice to this exception.
This DataStore object contains the amount classes together with their amount ranges
from the leading SAP S/4HANA system. The amount classes and their ranges are
maintained in the KPI Dashboard customizing of the leading SAP S/4HANA system.
Data Sources/Data Targets – As a source of the DSO, the Amount Class DataSource
(/OPT/VIM_AMTCL_ATTR) is used. As a further source of the DSO, the Amount Classes
DSO (/OPT/DCAMC) from the Corporate Memory Layer can be used for recovery
purposes. For both sources, all fields are updated in a 1:1 mapping into the DSO.
This DataStore object contains the input channels together with their channel type
from the leading SAP S/4HANA system. The channels are maintained in the
OpenText VIM for SAP customizing of the leading SAP S/4HANA system.
Data Sources/Data Targets – As a source of the DSO, the Channel DataSource (/OPT/
VIM_CHANNEL_ATTR) is used. As a further source of the DSO, the Channel DSO (/OPT/
DCCHA) from the Corporate Memory Layer can be used for recovery purposes. For
both sources, all fields are updated in a 1:1 mapping into the DSO.
Data Sources/Data Targets – As a source of the DSO, the Company Code DataSource
(/OPT/VIM_COCO_ATTR) is used. As a further source of the DSO, the Company Code
Group Mapping for Company Code DSO (/OPT/DCCCG) from the Corporate Memory
Layer can be used for recovery purposes. For both sources, all fields are updated in a
1:1 mapping into the DSO.
There is no target of the DSO. The active table of the DSO is used within
transformations to determine the company code group to a company code.
This DataStore object contains the time types to all time groups together with their
ranges. The time types and their ranges are maintained in the KPI Dashboard
customizing of the leading SAP S/4HANA system.
Data Sources/Data Targets – As a source of the DSO, the Time Type DataSource (/
OPT/VIM_TIMETY_ATTR) is used. As a further source of the DSO, the Time Types
DSO (/OPT/DCTTY) from the Corporate Memory Layer can be used for recovery
purposes. For both sources, all fields are updated in a 1:1 mapping into the DSO.
Data Sources/Data Targets – As a source of the DSO, the Vendor DataSource (/OPT/
VIM_VENDOR_ATTR) is used. As a further source of the DSO, the Vendor Group Mapping
for Vendor DSO (/OPT/DCVEN) from the Corporate Memory Layer can be used for
recovery purposes. For both sources, all fields are updated in a 1:1 mapping into the
DSO.
There is no target of the DSO. The DSO can be used to determine the vendor group
to vendors within transformations.
This DataStore object contains the OpenText VIM for SAP invoice headers as raw
data as extracted by the corresponding DataSource.
This DataStore object contains exceptions to OpenText VIM for SAP invoices as raw
data as extracted by the corresponding DataSource.
As a target of the DSO, the DSO Exceptions (/OPT/DPEXC) of the Data Propagation
Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Amount Class DataSource
(/OPT/VIM_AMTCL_ATTR) is used. All fields are updated in a 1:1 mapping into the
DSO.
As a target of the DSO, the DSO Amount Class (/OPT/DPAMC) of the Data Propagation
Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Amount Class Text
DataSource (/OPT/VIM_AMTCL_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
This DataStore object contains the possible input channels of OpenText VIM for SAP
invoices as raw data as extracted by the corresponding DataSource.
Data Sources/Data Targets – As a source of the DSO, the Channel DataSource (/OPT/
VIM_CHANNEL_ATTR) is used. All fields are updated in a 1:1 mapping into the DSO.
As a target of the DSO, the DSO Channel (/OPT/DPCHA) of the Data Propagation
Layer is supplied.
This DataStore object contains the texts of the possible input channels of OpenText
VIM for SAP invoices as raw data as extracted by the corresponding DataSource.
Data Sources/Data Targets – As a source of the DSO, the Channel Text DataSource
(/OPT/VIM_CHANNEL_TEXT) is used. All fields are updated in a 1:1 mapping into the
DSO.
This DataStore object contains the texts of the possible types of input channels of
OpenText VIM for SAP invoices as raw data as extracted by the corresponding
DataSource.
Data Sources/Data Targets – As a source of the DSO, the Channel Type Text
DataSource (/OPT/VIM_CHATY_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
Data Sources/Data Targets – As a source of the DSO, the Company Code DataSource
(/OPT/VIM_COCO_ATTR) is used. All fields are updated in a 1:1 mapping into the DSO.
As a target of the DSO, the DSO Company Code Group Mapping for Company Code (/
OPT/DPCCG) of the Data Propagation Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Company Code Group Text
DataSource (/OPT/VIM_CCGROUP_TEXT) is used. All fields are updated in a 1:1
mapping into the DSO.
Data Sources/Data Targets – As a source of the DSO, the Document Status Text
DataSource (/OPT/VIM_DOCSTA_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
Data Sources/Data Targets – As a source of the DSO, the Document Type Text
DataSource (/OPT/VIM_DOCTY_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
As a target of the DSO, the DSO Exception Class Mapping for Exception (/OPT/
DPEID) of the Data Propagation Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Exception Class Text
DataSource (/OPT/VIM_EXCCL_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
This DataStore object contains the texts of exceptions as raw data as extracted by the
corresponding DataSource.
Data Sources/Data Targets – As a source of the DSO, the Time Group Text
DataSource (/OPT/VIM_TIMEGR_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
This DataStore object contains the possible time types as raw data as extracted by the
corresponding DataSource.
Data Sources/Data Targets – As a source of the DSO, the Time Type DataSource (/
OPT/VIM_TIMETY_ATTR) is used. All fields are updated in a 1:1 mapping into the DSO.
As a target of the DSO, the DSO Time Type (/OPT/DPTTY) of the Data Propagation
Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Time Type Text DataSource
(/OPT/VIM_TIMETY_TEXT) is used. All fields are updated in a 1:1 mapping into the
DSO.
Data Sources/Data Targets – As a source of the DSO, the Vendor DataSource (/OPT/
VIM_VENDOR_ATTR) is used. All fields are updated in a 1:1 mapping into the DSO.
As a target of the DSO, the DSO Vendor Group Mapping for Vendor (/OPT/DPVEN) of
the Data Propagation Layer is supplied.
Data Sources/Data Targets – As a source of the DSO, the Vendor Group Text
DataSource (/OPT/VIM_VENDGR_TEXT) is used. All fields are updated in a 1:1 mapping
into the DSO.
This chapter focuses on the final data targets in the Virtualization Layer: the
MultiProviders.
SAP recommends to create reports, for example BEx Queries, on MultiProviders and
not on InfoCubes directly. Therefore the version 7.0 BW content delivers
MultiProviders for all its InfoCubes. Technically, the MultiProviders are assigned to
the Virtualization Layer and can be found below the InfoArea with the same name
(OpenText VIM for SAP > Reporting Layer > Virtualization Layer).
Note: A finished invoice in this context is an invoice that has finished the
OpenText VIM for SAP process. Cancelled and obsolete invoices are excluded
(they are not loaded into the SAP NetWeaver BW system).
• How many finished invoices have been processed with delay/on time?
• How many finished invoices have been approved with delay/on time?
• How many finished invoices ran into the different exception classes?
• What is the total amount of finished invoices in the different exception
classes?
• What is the percentage of finished invoices with a certain exception class to
all finished invoices?
• What is the exception free rate, which is the rate of “no real exceptions”, to
all finished invoices?
Important
For performance reasons, the following MultiProviders are not meant to be
used for extensive reporting. These MultiProviders are based on DataStore
Objects and therefore should be used for a drill down with a very restrictive set
of characteristics only.
Example: List of all DP documents with document type NPO_S4 and channel SCAN to
vendor 1000.
Example: List of all DP documents with document type NPO_S4 and channel SCAN to
vendor 1000 that had at least one exception to exception class Auth. mismatch.
Example: List of all DP documents with document type NPO_S4 and channel SCAN to
vendor 1000 that had the exception Missing Item Quantity (PO).
This part provides information about the transaction codes that various roles have
access to.
The following table shows domains, transactions, and the roles that have access to
the transactions.
Table headings
1 Indexer
2 AP Processor
3 AP Supervisor
4 Buyer
5 Receiver
6 Requester
7 Coder
8 Approver
9 WF Admin
Transaction Description 1 2 3 4 5 6 7 8 9
VIM
Notifications
VIM /OPT/REMINDER program X X
VIM Analytics
/OPT/ Current
VIM VAN_LIABILITY Liability Report X X
VIM Invoice
VIM /OPT/VIM_WP Workplace X X X X X
SAP Business
SAP SBWP Workplace X X X X X
VIM /OPT/VIM_AGING Aging Report X X
Summary
VIM /OPT/VIM_SUMM Report X X
Central Audit
VIM /OPT/VIM_AUDIT Report X X
Exception
VIM /OPT/VIM_EXCP1 Analysis Report X X
Key Process
Analytics
VIM /OPT/VIM_KPA1 Report X X
Transaction Description 1 2 3 4 5 6 7 8 9
Productivity
VIM /OPT/VIM_PROD1 Report X X
Automation
VIM /OPT/VIM_ATM Report X
VIM /OPT/VIM_7AX8 Admin Tool X X X
Change
VIM /OPT/VIM_1AX1 document type X X X
Display
IDocument
VIM /OPT/VIM_1AX13 (indexed) X X X X X X X X
Change process
VIM /OPT/VIM_1AX2 type X X X
VIM /OPT/VIM_1AX3 Send for rescan X X X
Display BDC
VIM /OPT/VIM_1AX4 log X X X
Approval
baseline COA
VIM /OPT/AR_COA maintenance X X
Maintain
notification
VIM /OPT/VIM_8AX50 settings for me
VIM /OPT/VIM_VA2 VIM Analytics X X X X X X X X
VIM Analytics -
VIM /OPT/VIM_VA21 AP Basic X
VIM Analytics –
VIM /OPT/VIM_VA22 AP Advanced X
VIM Analytics -
VIM /OPT/VIM_VA23 Procurement X
VIM Analytics -
VIM /OPT/VIM_VA24 Monitor X
Display special
handling
VIM /ORS/DISP_SH instructions X X X X X
Resubmit Non-
/ORS/ PO invoice for
VIM RESUB_NPO_INV approval X X X
Resubmit PO
invoice for
VIM /ORS/RESUB_PO_INV approval X X X
Transaction Description 1 2 3 4 5 6 7 8 9
Goods receipt
for purchase
VIM /PTGWFI/M_CR_GR order X
Display
VIM /PTGWFI/M_DIS_REQ requisition X X X
Purchasing
documents for
VIM /PTGWFI/M_LIST_PO material X X X X
Release LIV
VIM /PTGWFI/M_LIX_REL blocked invoice X X
/PTGWFI/ Short pay LIX
VIM M_LIX_SHORTP invoice X X
Reverse goods
VIM /PTGWFI/M_REV_GR receipt for PO X
/PTGWFI/ Short pay:
VIM M_SPAY_2_CM credit memo X X
Short pay:
/PTGWFI/ subsequent
VIM M_SPAY_4_SC credit X X
Short pay:
/PTGWFI/ delete invoice/
VIM M_SPAY_INV create invoice X X
/PTGWFI/ Change parking
VIM PIR_CHG_PKRS reason X X X
All OpenText
VIM for SAP
VIM /OPT* transactions X
All OpenText
VIM for SAP
VIM /ORS* transactions X
All OpenText
VIM for SAP
VIM /PTGWFI* transactions X
Workflow
SAP SW* transactions X
Development
SAP SE* transactions X
System
SAP SM13, SM50, SM12 monitoring X
SAP ST22, ST05, Dump analysis X
SAP SQ* SAP query X
Authorization objects
This part provides an overview of all business rules applied in OpenText VIM for
SAP. This part also provides some technical insight to ease the using of the business
rules. If needed the related configuration aspect is mentioned.
At the beginning of each business rule, a check is performed whether the business
rule is relevant for this specific document based on the customizing stored in table /
OPT/VIM_T005A (Characteristic Specific Process Types Configuration). The following
check is done:
• Invoice Characteristics
• Invoice type: A for All, N for NPO and P for PO. For example: If the coming
invoice is of type NPO but the rule is applicable for PO, the rule is not executed.
• Simplified Invoice (ignored or not): If this indicator is set, a FM is called to check
whether the invoice is a simplified one.
The check is executed based on the customizing in table /OPT/VIM_T005
(Characteristic Specific Process Types Configuration). If the fixed amount limit is
maintained, the amount of the invoice will be compared with this limit.
Otherwise if the Simplified Invoice Check FM is maintained, the FM is called.
When the invoice is determined as simplified, the rule is not applied for
simplified invoices.
• Invoice category: The invoice category maintained for the business rule (all
categories, intra-community, domestic, import, ...) is compared with the invoice
category of the indexing data. If it does not match, the rule is not executed.
Configuration Run the /OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > Document
Type Configuration > Characteristic Specific Document Type Configuration.
Double click the document type. The Characteristic Specific Attributes view opens.
This chapter describes the various business rules for PO invoices. The business rules
are delivered out of the box with the product including the high level business logic
of each of these rules.
Matching
The PO number mentioned on the supplier’s invoice matches with the PO
number in SAP S/4HANA, and the PO number is not marked as Deleted. In this
case, no action is taken and the document proceeds to the next logical step.
Mismatch
The PO number mentioned on the supplier’s invoice does not match with the
PO number in SAP S/4HANA, or the PO number is marked as deleted in the
LOEKZ flag. The exception Invalid PO Number (PO) is raised, and the invoice is
automatically routed to the preconfigured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_101
information
All PO numbers if given in one of the following locations are checked against table
EKKO.
If only one of them is not found in table EKKO, or found with deletion flag set, the
exception Invalid PO Number (PO) is raised.
The business rule writes detailed information about the invalid PO numbers into the
message table.
Exists
The invoice supplier exists in the SAP S/4HANA system as a vendor. In this
case, no action is taken and the document proceeds to the next logical step.
Does not exist
The invoice supplier does not exist in the SAP S/4HANA system as a vendor.
The exception Invalid Vendor (PO) is raised. The invoice is automatically
routed to the pre-configured agent depending on the role for further action.
Technical The value from table /OPT/VIM_1HEAD corresponding to the field entered in the
information customizing table of this rule is checked against the LFA1 table.
Exists
The UOM on the supplier invoice exists in SAP S/4HANA. In this case, no action
is taken and the document proceeds to the next logical step.
Does not exist
The UOM on the supplier invoice does not exist in SAP S/4HANA. The
exception Invalid UOM (PO) is raised and the work item is automatically routed
to the pre-configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_103
information
The UOM is compared with the values in table field T006-MSEHI.
Exists
The currency on the supplier invoice exists in SAP S/4HANA. In this case, no
action is taken and the document proceeds to the next logical step.
Does not exist
The currency on the supplier invoice does not exist in SAP S/4HANA. The
exception Invalid Currency (PO) is raised, and the work item is automatically
routed to the pre-configured agent depending on the role for further action.
Technical The value from table /OPT/_VIM_1HEAD corresponding to the field entered in the
information customizing table of this rule is checked against the table TCURC.
Not a duplicate
If the invoice is not a duplicate, no action is taken and the document proceeds to
the next logical step.
Duplicate
If the invoice is a duplicate, the exception Suspected Duplicate (PO) is raised
and the work item is automatically routed to the pre-configured agent
depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_DUP
information
Based on the Duplicate Check Group ID maintained for the Document Type, a
different algorithm is applied to check the duplicate.
The duplicate check can be running on the local system or on the central system
depending on the system landscape (table /OPT/VIM_SYS_LD).
In baseline configuration, there are 2 Duplicate Groups, ID1 for NPO and ID 02 for
PO. FMs (if required) are different for 2 groups.
Duplicate Check Type can be either Function Module (A) or Index Data Fields (B).
In case of A, the function module maintained for this Duplicate Group is called.
In case of B, the fields maintained in table /OPT/VIM_T113 for the Duplicate Group ID
are used to compare the index data of the current document with all existing
documents in table /OPT/VIM_1HEAD. Only documents with relevant status (table /
OPT/VIM_T101) are considered in the checking process. Documents with status 06
(Rescan complete), 10 (Obsolete), and 72 - 90 (OCR specific) are not considered.
Configuration Run the /OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > General
Configuration > Maintain Duplicate Check Procedures
Released or complete
If the PO is released or complete, no action is taken and the invoice document
proceeds to the next logical step.
Not released or incomplete
If the PO is not released or incomplete, the exception PO Not Released or
Incomplete is raised, and the work item is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_106
information
The following check is carried out for all POs given in the indexing data, either in
field PO number or in field PO list or in the line items:
• Release group of a PO (field FRGGR) if filled will be read from table EKKO for the
given PO. If the release group is not released (indicator KZFRE in table T16FB) ->
Exception.
• If there is no Release group available, and the field Memory (the indicator that PO
is not yet complete) is set -> Exception.
Matches
The number of PO lines on the invoice matches with the number of SAP PO
lines. In this case, no action is taken and the document proceeds to the next
logical step.
Mismatches
The number of PO lines on the invoice exceeds the number of SAP PO lines. The
exception Unable to Match PO Lines (PO) is raised, and the work item is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_107
information
For every PO given in the line items, the number of line item with the same PO
number is counted. If for a certain PO there are more lines in the document than in
the PO, the exception is raised.
If the PO item is a service PO item, the number of service entries in table ESLL is
considered as a reference.
Note: This business rule can be replaced by business rule Manual Check Needed
for Indexing Lines (PO).
When this business rule is applied, the PO invoice is checked if all data - header and
item lines - is fully provided.
In contrast to the pre-7.5 business rule, this new version additionally checks if the
invoiced quantity on each line does not exceed the GR quantity (that has not been
invoiced yet). This can be switched off if needed, to achieve that the 7.5 business rule
performs only completeness checks. The corresponding configuration is described in
this section.
Note: The check of line item quantity against the GR is performed for each line
item independently. It will not attempt to sum up the quantities of line items
related to the same GR. If you want to perform a check with such grouping of
line items, consider using the business rules “Tolerance Exceeded (PO)”
on page 264 or “Wait for GR - Enhanced Check (PO)” on page 260.
If line item data is complete, that means all mandatory fields are fully supplied, the
business rule is completed without any exception and the document proceeds to the
next logical step.
A line is considered incomplete if one or more mandatory fields are not fully
supplied.
Technical FM /OPT/VIM_DETERMINE_PROC_108
information
In this FM, all mandatory fields of item indexing data are checked.
• PO number
• PO item
• Quantity
• Amount
• UOM
• PO number
• PO item
• GR reference document
• Delivery note number (if available)
• Quantity
• Amount
• UOM
The exception is raised if at least one line is incomplete or missing (empty). The
missing fields are then determined by the settings of the document type
configuration, PO line determination maintenance.
As mentioned above, this business rule additionally checks whether the invoice
quantity on each line item does not exceed the corresponding GR quantity that is not
invoiced yet. For service POs, SES is checked similarly. This check is made by
default in version 7.5, but can be switched off if needed, to make this business rule
behave similarly to the 7.0 business rule and make only completeness checks. To
switch the additional checks off, create a new entry in the table /PTGWFI/Z_CONST,
using the SM30 transaction:
Determined
The corresponding PO line number is determined based on the supplier’s
invoice information. In this case, no action is taken and the document proceeds
to the next logical step.
Unable to Determine
The corresponding PO line number is not determined based on the supplier’s
invoice information. The exception Unable to Determine PO Line Number (PO) is
raised, and the work item is automatically routed to the pre-configured agent
depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_POL
information
Item data of the PO is read from table /OPT/VIM_1ITEM.
The item number is determined based on the PO Line Determination logic group ID
(POL_GROUPID). This POL Group ID is maintained for each document type in the
Document Type configuration.
If check FM is maintained for the POL Group ID, this FM is called. Otherwise the
Baseline FM /OPT/VIM_DETERMINE_PO_LINES is called. In this FM, fields maintained
for the POL Group ID (which are store in table /OPT/VIM_TPOL3) will be subjects to
be checked. That means the values of such fields in the invoice are used to find the
best match.
If field ALL_MATCH is set, all fields must be matched. Otherwise the number of
matched fields is given in field NOF_FIELDSMATCH.
If field INVOICED_LINES is checked, only item lines marked as Final Invoice (field
EREKZ is marked – meaning that the item is already invoiced and no further invoice
is expected) will be considered.
After the matching, each pair PO number and determined Item Number are checked
against table EKPO. If there is no match -> Exception.
Configuration Run the /n/OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > General
Configuration > Automated Line Processing > PO Line Determination > Maintain
PO Line Determination Procedures.
Notes
• The field entered in the POL configuration shall be a valid field. A field that
exists in /OPT/VIM_1ITEM can be entered in the configuration, but it will be
ignored in the POL logic if it does not exist in SAP table EKPO. Except the
following fields which are internally re-mapped from OpenText VIM for
SAP fields to SAP fields:
• There is a special option for single line POs in single line invoices. The line
item matching is skipped and the line number in the DP document is set to
the number of the single PO line item unless Z constant 005 SINGLE_LINE_
PO_MATCH is set to X.
When this business rule is applied, the PO invoice is checked if all data – header and
item lines – is fully provided. The difference between this business rule and the
business rule Unable to Determine PO Line Number is listed in the following:
• This business rule not only checks the PO line number, it checks also other
mandatory fields of the PO.
• Not only the PO line number, but also other mandatory fields, which are not
supplied in the document, will be derived in background.
Complete
If line items data is complete, that means all mandatory fields are fully supplied,
the business rule is completed without any exception and the document
proceeds to the next logical step.
Incomplete or not supplied
If line items are incomplete or not supplied, their mandatory fields will be
derived in background based on the PO number or Delivery numbers provided
in the header. The exception Manuel Check Needed for Indexing Lines (PO) is
raised, and the invoice is automatically routed to the pre-configured agent
depending on the role for further action. A line is considered incomplete if one
or more mandatory fields are not fully supplied.
Technical FM /OPT/VIM_LINES_DERIVE_PO
information
In this FM, all mandatory fields of item indexing data coming from OCR are
checked. Mandatory fields of a Non GR-IV based PO invoice:
• PO number
• PO item
• Quantity
• Amount
• UOM
• PO number
• PO item
• Delivery Note/GR Reference Document
• Quantity
• Amount
• UOM
The completeness of mandatory fields are checked against data of the PO/DN in
tables EKBE and EKPO.
The exception is raised if at least one line is incomplete or missing (empty). The
missing fields are then determined by the settings of the document type
configuration, PO line determination maintenance.
Matching
The PO item number mentioned on the supplier’s invoice exists within the PO in
SAP S/4HANA, and the PO item number is not marked as Deleted. In this case,
no action is taken and the document proceeds to the next logical step.
Mismatch
The PO item number mentioned on the supplier’s invoice does not exist within
the PO in SAP S/4HANA, or the PO item is marked as deleted with the LOEKZ
flag. The exception Invalid PO Item Number (PO) is raised, and the invoice is
automatically routed to the preconfigured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_ITEMS
information
All item lines with PO number and PO item number are checked in table EKPO.
If at least one of them is not found in table EKPO, or found with deletion flag set, the
exception Invalid PO Item Number (PO) is raised.
The business rule writes detailed information about the invalid PO item numbers
into the message table.
Match
The supplier VAT/Tax number provided on the invoice matches with the VAT/
Tax number mentioned in the vendor master. In this case, no action is taken and
the document proceeds to the next logical step.
Mismatch
The supplier VAT/Tax number provided on the invoice does not match with the
VAT/Tax number mentioned in the vendor master in SAP S/4HANA. The
exception Invalid Vendor VAT Number (PO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_120
information
The Vendor VAT/Tax number is read from the Vendor Master Data (table LFA1) and
compared with the VAT/Tax number given in the invoice. If no match, the Vendor
VAT/Tax number is read from the Vendor Master Data extension table LFAS. If no
match -> Exception
The following fields in the Vendor master data (table LFA1) for VAT ID are
considered in this business rule:
STCEG
VAT Registration Number
STCD1
Tax Number 1
STCD2
Tax Number 2
STCD3
Tax Number 3
STCD4
Tax Number 4
In the indexing screen, the field vendor_vat_no is strictly mapped to field STCEG. The
field vendor_tax_no is mapped to STCD1, STCD2, STCD3, or STCD4. Therefore, if the
vendor applies only STCDx (where x is 1, 2, 3, or 4) in the master data, the field
vendor_tax_no must be used instead of vendor_vat_no in the indexing screen.
If the value in field vendor_vat_no does not match the value in STCEG in vendor
master data, it will be checked against the foreign VAT ID of the vendor, which is
Otherwise, the field vendor_tax_no will be checked according to the following logic:
If the field vendor_tax_no is not filled in the indexing screen, but one of the fields
STCDx (where x is 1, 2, 3, or 4) in vendor master data is filled with a value, the
exception is raised. If the field vendor_tax_no is filled in the indexing screen, its
value must match the value of one of the fields STCDx (where x is 1, 2, 3, or 4).
When this business rule is applied, the credit memo should have the original
suppliers invoice number and the original invoice date. Also, the original invoice
number mentioned on the credit memo must be present in the SAP S/4HANA
system. The following scenarios are possible:
If CM Ref No is required for CM but the field CM REF NUMBER in the indexing is
left blank -> Exception
If Ref Date is required for CM but the field CM REF DATE in the indexing is left
blank -> Exception
If CM Ref Data Validate is required, the rule will search for a document with the
Posting date = CM Ref date (if CM_Ref_Date is required) and the Reference number
= CM Ref No (if CM_Ref_No is required). The searching will be carried out in the
following logic:
CM Ref No Req.
CM reference number is required.
CM Ref Date Req.
CM Reference Date is required.
CM Ref Data Validate
The correctness of the CM Ref No and Ref Date is validated against data in the
DP documents (OpenText VIM for SAP tables) or in the SAP documents (SAP
tables).
Match
The Remit-To-Address provided on the Invoice matches with the address on the
vendor master. In this case, no action is taken and the document proceeds to the
next logical step.
Mismatch
The Remit-To-Address does not match with the address on the vendor master.
The exception Vendor Address Mismatch (PO) is raised and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
• House #
• Street
• Postal Code
• City
• Region
• Country
Technical FM /OPT/VIM_DETERMINE_PROC_122
information
When this business rule is applied, the quantity on the DP index document line item
should have been filled. There can be two scenarios, as described in the following:
Entered
No action is taken and the document proceeds to the next logical step.
Not entered
The exception Missing Item Quantity (PO) is raised and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_123
information
Field quantity of each line item in the indexing data is checked. If not filled ->
Exception
Normally, if the business rule Manual Check Needed for Indexing Lines (PO) is
applied in some step before, the information like Unit Price is already derived from
PO and no exception is raised.
Entered
No action is taken and the document proceeds to the next logical step.
Not entered
The exception Missing Invoice Date (PO) is raised and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical If field BLDAT of the indexing data is not filled -> Exception
information
When this business rule is applied, the tax information provided on the vendor
invoice is analyzed and mapped to standard SAP tax values (tax codes) and passed
onto the DP document. Depending on the OpenText VIM for SAP specific tax
configuration settings (with auto calculate tax or without auto calculate tax), the tax
information is validated and, in case of any deviations, the exception Invalid Tax
Info (PO) is raised and the invoice is routed to the pre-configured agent depending
on the role for further action. There are many scenarios that can arise depending on
the configuration. In the following, some of the possible scenarios are described:
Example: The VAT % mentioned on the invoice has a corresponding VAT tax code.
Example: The VAT % mentioned on the invoice does not have a corresponding VAT tax
code in SAP S/4HANA.
Example: The payable VAT % or VAT amount is not present on the vendor’s invoice.
• Firstly, the country key (for example US, DE, JP) is determined. If PO numbers
are given in the header data, the country key is derived from the PO. If there is
no PO number in the header, the country key is derived from the very first PO in
the lines. If there are no PO numbers available in the header and in the lines, the
country will be determined based on the company code.
• FM /OPT/VIM_TAX_CODE_DETERMINE is called. This FM will determine the tax code
based on the tax rate if there is any. The logic used for the tax code determination
can be configured in /OPT/SPRO. The tax jurisdiction code is also determined here
if required.
• Specific for Canada:
After the step of tax code determination is executed, the tax rate and tax code are
checked as described in the following (for all countries).
– If tax rate is given and not 0.00, tax code is blank -> Exception. That means the
tax rate is not valid and no corresponding tax code can be determined.
– The combination tax rate = 0.00, tax code is blank is only allowed if the option
Allow zero tax is not checked. That means if the option Allow zero tax is
checked, there must be a valid tax code for the tax rate 0.00.
• The tax code, if given or determined by the logic mentioned above, either in the
header or in the line items, will be checked by the following logic.
– Look in table t005 for the procedure for calculating tax maintained for the
country key, for example TAXD. If the tax code is given in the invoice and the
Procedure key is found (not initial), they will be checked against table T007A.
If tax code is not given -> exception
• Tax amount if given in the invoice is checked in the following steps. If not, the
value in the total tax amount is used. The logic:
If auto_calc (Auto calculate Tax) is not checked:
– If tax_amount # 0 but tax_code in header or in all line items is not given ->
Exception
– If tax_amount = 0, the check is successful only if the tax_rate = 0 and
allow_free_tax = X, OR both tax_rate and tax_code are initial, in header as
well as in the line items.
If auto_calc is checked:
Customization You can customize the logic for tax code determination in /OPT/SPRO > Document
point Processing Configuration > Document Type Configuration > Maintain Document
Types. Double-click the DP Document Type.
You can also customize the options like Auto Calculate Tax, Allow Zero Tax, Allow
without Tax here.
For all Canada-specific customizing, run the /n/OPT/SPRO transaction and navigate
to OpenText Vendor Invoice Management Invoice Solution > Document
When this business rule is applied, the ISR number on the DP index document
header should be present and matching with the vendor master. There are the
following scenarios:
Technical FM /OPT/VIM_DETERMINE_PROC_129
information
• If the Z constant ESR_CHECK_REQUIRED for product 005 is set to X, both ISR
numbers in the header data and in the vendor master must be given. Otherwise,
the exception is raised.
• If both ISR numbers on invoice and in the vendor master data are given, they are
checked irrespectively whether the Z constant is set or not. The check logic is the
following:
– The ISR number in the header data must contain the ISR number given in the
vendor master data (table lfa1). Otherwise, the exception will be thrown.
– The ISR number in the vendor master data is allowed to contain the dash
symbol, for example 01-162-8 where 01 represents the ESR code, 162 the
participant number, and 8 the check digit.
• If the Z constant ESR_CHECK_REQUIRED for product 005 is not set, the check will be
successful even if the ISR number in the invoice or the ISR number in the vendor
master data or both are not available.
When this business rule is applied, the recipient VAT number provided on the
invoice must match with the company’s VAT Number provided in the company
code in SAP S/4HANA. The following scenarios are possible:
Match
The recipient’s VAT number provided on the invoice matches with the VAT
number mentioned in the company code information. In this case, no action is
taken, and the document proceeds to the next logical step.
Mismatch
The recipient’s VAT number provided on the invoice does not match with the
VAT number mentioned in the company code in SAP S/4HANA. The exception
Invalid Recipient VAT Number (PO) is raised, and the invoice is automatically
routed to the pre-configured agent depending on the role for further action.
Not present
If the recipient’s VAT number is not present on the invoice, the exception
Invalid Recipient VAT Number (PO) is raised, and the invoice is automatically
routed to the pre-configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_128
information
For all countries except Austria, the check is carried out in the following logic:
Note: The Company Code is either given in the invoice header or can be
derived from PO information (for PO invoice).
For Austria the check will be carried out only when the gross amount exceeds some
specific amount (for example 10,000 in the local currency).
Match
The payment terms provided on the vendor’s invoice matches with the payment
terms mentioned in the purchase order or vendor master in SAP S/4HANA. In
this case, no action is taken and the document proceeds to the next logical step.
Mismatch
The payment terms provided on the vendor’s invoice does not match with the
payment terms maintained in the purchase order or vendor master in SAP S/
4HANA. The exception Payment Terms Mismatch (PO) is raised and the invoice
is automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_130
information
If payment terms are not given in the invoice, no check will be executed.
If payment terms are given in the invoice, they must match with the payment terms
determined for the invoice.
The payment terms of a PO invoice are determined from the PO data (table EKKO) if
given, or from the purchasing data of the vendor (table LFM1). If not found, it is
determined from the vendor company code data.
Match
The SIRET number provided on the invoice matches with the SIRET number in
the vendor master. In this case, no action is taken and the document proceeds to
the next logical step.
Mismatch
The SIRET number provided in the invoice does not match with the SIRET
number in the vendor master. The exception Invalid SIRET Number (PO) is
Technical FM /OPT/VIM_DETERMINE_PROC_229
information
The SIRET number (field siret_no) given in the invoice is compared with the tax
number stored in the master data of the vendor.
• If the tax number is maintained for the vendor and it does not match the number
given in the invoice, the exception is raised.
• If the tax number is not maintained for the vendor, no exception is raised.
Customizing There are 4 tax numbers available in the master data of the vendor (table lfa1). In
order to determine which number is applied for the SIRET, the Z constant VENDOR_
SIRET_NO_FLD for product code 005 (table /PTGWFI/Z_CONST) must be maintained
with a correct value. Possible values are STCD1, STCD3, and STCD4.
Match
The recipient address provided on the invoice matches with the company code
address. In this case, no action is taken and the document proceeds to the next
logical step.
Mismatch
The recipient address does not match with the address of the company code.
The exception Invalid Company Address (PO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_132
information
The company code address is read from table T001 (Company Code Master Data)
and is compared with the address given in the section Ship-To-Address in the
indexing. If the address of the company code is not maintained (blank) or does not
match with the Ship-To-Address in the invoice -> Exception
Customization The address of the company code can be maintained and displayed in the SAP
Reference IMG (transaction SPRO): Financial Accounting > Company Code > Enter
Global Parameters. Click the Address button to maintain or display the company
code address.
Technical If field XBLNR of the indexing data is not filled with the reference number ->
information Exception
Match
The payment method provided on the vendor’s invoice matches with the
payment method mentioned in the vendor master in SAP S/4HANA. In this
case, no action is taken and the document proceeds to the next logical step.
Mismatch
The payment method provided on the vendor’s invoice does not match with the
payment method maintained in the vendor master in SAP S/4HANA. The
exception Payment Method Mismatch (PO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical FM /OPT/VIM_DETERMINE_PROC_134
information
If the payment method is not given in the invoice, no check is executed.
If the payment method is given in the invoice, it must match with the payment
method maintained in the vendor master data in the current company code (table
LBF1).
• If the tax rate = 0 and the field Tax Exempt Text is blank, and there are no
different tax codes in the line items.
• If the tax rate > 0 and the field Tax Exempt Text is filled with text.
Technical FM /OPT/VIM_DETERMINE_PROC_136
information
The function will check the tax rate given on the invoice. If the tax rate is zero and
there is no text entered in the field Import Text, the exception is raised.
If the tax rate is not zero but there is some text given in the field Import Text, the
exception is raised as well.
Technical FM /OPT/VIM_DETERMINE_PROC_137
information
All line items of the invoice are checked.
If both fields SGTXT (Item Text) and MAKTX (Material Description) (in table /OPT/VIM_
1ITEM) of one of the line items are empty, the exception is raised.
Technical FM /OPT/VIM_DETERMINE_PROC_138
information
Fields with status Required are read from table /opt/vim_nw_scrn. If there is one
required field that is not filled in the indexing data of the invoice, the exception is
raised.
Configuration Fields on the DP document can be maintained in /OPT/SPRO on the following levels:
point
On header level
OpenText Vendor Invoice Management Invoice Solution > Document
Processing Configuration > Document Type Configuration > Maintain
Document Types.
Select the DP Document Type. In Dialog Structure, double-click Index Header
Configuration.
On item level
OpenText Vendor Invoice Management Invoice Solution > Document
Processing Configuration > Document Type Configuration > Maintain
Document Types.
Select the DP Document Type. In Dialog Structure, double-click Index Item
Configuration.
Technical FM /OPT/VIM_DETERMINE_PROC_139
information
Information matching
The ship-to region and tax types entered on the DP document matches with the
configured SAP S/4HANA tax type for that region. The document proceeds to
the next logical step.
Example: For the region Ontario, the tax type GST is supplied, and the tax type GST is
configured in SAP S/4HANA for that region.
Example: For the region Ontario, the tax type GST is supplied, and the tax type
configured in SAP S/4HANA is PST for that region.
Default Region
Company code address/PO address are used as ship-to region. The business
rule proceeds with the above scenarios. You can configure this derivation of
the ship-to region on OpenText VIM for SAP side.
Blank
Keep the not present information as blank and raise exception Invalid Sales
Tax for the Region (NPO). The document is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM /OPT/VIM_CHECK_TAX_RATE
information
First step
If tax rates (1 to 4) on line items are not given at all, they are copied from the tax
rates in the header data. The missing tax rates are determined (as much as
possible) based on the ship-to region and the configuration maintained in table /
OPT/VIM_TAX_PRO (Country Specific Tax - Province Relationship) for the region.
Company Code
The ship-to region is determined based on the company code and read from
table T001.
Fixed Value
The region maintained in table /OPT/VIM_STR_DET is used as ship-to region.
Function Module
The FM maintained in table /OPT/VIM_STR_DET is used to determine the
ship-to region.
Second step
After all tax rates (in header as well as on line items) are determined, they will
be checked against table /OPT/VIM_TAX_PRO. If some tax rates are required
according to the customizing table, but not given in the invoice or cannot be
determined in the first step, the exception is raised.
Customization Run the /n/OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > Document
Type Configuration > Specific Country Settings > Canada.
No audit required
The vendor is not subjected to audit. In this case, no action is taken and the
document proceeds to the next logical step.
Audit required
The vendor is subjected to audit. An exception Vendor Audit Required (PO) is
raised, and the invoice is automatically routed to the pre-configured agent
depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_151
information
If the vendor number is maintained in table /OPT/VIM_BL_VAUD with flag Audit
Required set, the exception Vendor Audit Required (PO) is raised for all invoices of
this vendor. The wildcard * in column Vendor Number means “All Vendors”.
Customization point
Match
The vendor number provided matches with the vendor number of the purchase
order in SAP S/4HANA. In this case, no action is taken and the document
proceeds to the next logical step.
Mismatch
The vendor number provided does not match with the vendor number of the
purchase order in SAP S/4HANA. The exception Vendor Mismatch (PO) is raised
Technical FM /OPT/VIM_DETERMINE_PROC_153
information
The check is executed for every PO given in the invoice: in the header, in the PO list,
or in the line items. The vendor for each PO is read from table EKKO and is checked
against the vendor given in the invoice header.
Exists
The service entry sheet exists. In this case, no action is taken and the document
proceeds to the next logical step.
Does not exist
The service entry sheet does not exist. In this case, the exception Service Entry
Required (PO) is raised, and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_154
information
The PO number given in the invoice is checked in the following logic:
• Check whether any PO positions of the related POs have the GR flag enabled
(indicator WEPOS). If, for any of those positions, no service entry sheet can be
found in the current MIRO line item proposal , the exception is raised.
• With version 7.0 SP3 and later, the two Z constants SERVICE_ENTRY_BSTYP and
SERVICE_ENTRY_BSART (product code 005) are not used any more.
Match
The currency provided on the vendor’s invoice matches with the purchase order
currency in SAP S/4HANA. In this case, no action is taken, and the document
proceeds to the next logical step.
Mismatch
The currency provided on the vendor’s invoice does not match with the
purchase order currency in SAP S/4HANA. The exception Currency Mismatch
(PO) is raised, and the invoice is automatically routed to the pre-configured
agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_155
information
The currency given in the header data of the invoice is compared with the currency
of all POs given in the invoice. All POs that are entered in the header and in the line
items are considered.
The POs given in the new field PO List is not considered yet.
Match
The UOM provided on the vendor’s invoice matches with the purchase order
UOM in SAP S/4HANA. In this case, no action is taken, and the document
proceeds to the next logical step.
Mismatch
The UOM provided on the vendor’s invoice does not match with the purchase
order UOM in SAP S/4HANA. The exception Unit of Measure Mismatch (PO) is
raised, and the invoice is automatically routed to the pre-configured agent
depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_156
information
For service POs, the MIRO proposal is calculated and the UOM is compared to the
MIRO proposal.
For normal POs, if all UOMs in the tables (EKPO, EKBE, MSEG) are the same, the UOM
is compared directly to the UOM in the line item. If the UOMs in the tables are
different, the MIRO proposal is calculated and the UOM is compared to the MIRO
proposal.
Additional change in version 7.0 and higher: Line items with qualifiers (additional
costs) are not considered for UOM matching because they are line items that
transport costs only.
Technical FM /OPT/VIM_DETERMINE_PROC_150
information
Customization Run the /n/OPT/VIM transaction and navigate to OpenText VIM - Invoice Solution >
point SAP menu > Customization > PO Invoice Approval Configuration.
Note: If the exception is triggered, a work item is created and forwarded to the
requisitioner of the PO if this requisitioner is maintained in COA (Chart of
Authority). If not, no agent can be found for the current work item.
Exceeds
The unplanned freight amount on the vendor’s invoice exceeds the freight
amount maintained in the global configuration. The exception Freight on
Invoice (PO) is raised, and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_157
information
The freight amount given on the invoice header is compared with the maximal
freight amount maintained in the Z constant 005 / FREIGHT_AMOUNT. If the freight
amount on the invoice exceeds the amount maintained in the Z constant, the
exception is raised. If no value is maintained for this Z constant, no check is
executed.
Technical FM /OPT/VIM_DETERMINE_PROC_158
information
The configuration maintained in table /OPT/VIM_BL_TAX is checked. If company
code, material group, and vendor number on the invoice are maintained with the
flag set in table /OPT/VIM_BL_TAX, the exception Tax Audit Required (PO) is raised.
Customization point
• Transaction /OPT/VIM_BL_PTX, or
• run the /n/OPT/VIM transaction and navigate to OpenText VIM - Invoice
Solution > SAP menu > Customization > Tax Audit Configuration for PO
Invoices.
Match
The supplier invoice requisitioner matches with the SAP purchase order
requisitioner. In this case, no action is taken and the document proceeds to the
next logical step.
Mismatch
The supplier invoice requisitioner does not match with the SAP purchase order
requisitioner. The exception Invalid Requisitioner (PO) is raised and the
invoice is automatically routed to the pre-configured agent depending on the
role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_303
information
1. The system checks the requester on the original invoice, if present. It must be
validated against PO requester (@ 1st item) or PO creator. If both are not the
same, the exception is raised.
2. The system checks whether the invoice is going through the approval process or
not. The check logic is the same as in the /OPT/VIM_DETERMINE_PROC_
150 function module. For more information, see “Approval Required (PO)”
on page 249. Only if the invoice is going through the approval process, the
system will perform the following checks.
3. The system checks if the Requester is available in the indexing screen or not. If
the requester is available, the system checks whether the requester exists in the
user map table /ORS/USERMAP (COA) or not. If not, the exception is raised.
4. If the requester is not available, the system checks if the Requisitioner/
Requester is available (field AFNAM in table EKPO). If the AFNAM field is available,
the system checks the user map table. If the user is not available there, the
exception is raised.
5. If the field AFNAM is not available, the system checks for the creator of the PO
(field ERNAM in table EKPO). If the ERNAM field is available, the system checks the
user map table. If the creator is not available, the exception is raised.
Match
The company code of all POs entered in the header and in the line items matches
the company code of the invoice. In this case, no action will be taken and the
document proceeds to the next logical step. If the company code is not given in
the header, no matching is executed.
Mismatch
The company code of at least one PO that is entered in the header and in the line
items does not match the company code of the invoice. The exception Company
Code Mismatch (PO) is raised and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_161
information
If the Company Code field in the header is not filled, no matching is executed. No
exception is raised.
The company codes of all POs entered in the header and in the line items of the
invoice is read from table EKKO. The company codes of each PO are compared with
the company code of the invoice. If there is at least one mismatch, the exception is
raised.
When the exception occurs, the first “mismatching” PO number is returned in the
header structure if the constant FAIL_PO_HEADER_SET for product code 005 is set.
The business rule writes detailed information about the mismatches found into the
message table.
If this business rule is maintained as active for the given Document Type, all POs on
the invoice are checked whether there is a SRM-related PO. If there are some SRM-
related POs, some items of these POs are flagged as GRIV but there is no GR posted
for those items. The exception is raised, and the invoice is automatically routed to
the pre-configured agent depending on the role for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_162
information
• All POs on the invoice are checked whether they are SRM-related or not. If there
is a FM maintained in the constant LIX / SRM_PO_CHECK, this FM is called for the
checking. If there is no FM maintained, the status of the PO is compared with all
If the check fails, the exception Invalid Payment Reference (PO) is raised, and the
invoice is automatically routed to the pre-configured agent depending on the role
for further action.
Technical FM /OPT/VIM_DETERMINE_PROC_176
information
Technical To use this business rule, the INVOICE_CODE field must be configured as required
information field.
If the invoice code length is equal to 10, then the 7th digit should be either 6 - or
greater than 0 and less than 5. Otherwise, the exception Invalid Invoice Code
Format (PO) is raised and the invoice is automatically routed to the pre-configured
agent depending on the role for further action.
The business rule writes detailed information about the error reason into the
message table.
Technical To use this business rule, the VEND_NAME field must be configured as required field.
information
Technical To use this business rule, the RECIPIENT_NAME field must be configured as required
information field.
If these conditions apply, the exception Mismatch Vendor ECC Number (PO) is raised,
and the invoice is automatically routed to the pre-configured agent depending on
the role for further action.
• For any PO number within indexing data (header/item), the PO lines are checked
if any line has the GR-IV based flag set.
• For these lines, it is checked that at least one open invoicing line exists.
• For any PO item within indexing data (header/item), the delivered PO lines are
checked if any line has the GR-IV based flag set.
• For each of these lines, it is checked that there is an open proposal item (GR) with
the same quantity as the invoice line.
For this, a new business rule 166 Service Entry Required (PO) - Enhanced Check
has been introduced in version 7.5 SP5. If the DP line item amount is higher than the
open amount to be invoiced, the system raises the exception.
Technical The rule needs to be activated for relevant countries in the Country/Characteristic-
Information specific settings for foreign vendors. There is no function module used, the check is
achieved using configuration only.
• For any PO number within indexing data (header/item), the PO lines are checked
if any line has the GR-IV based flag set.
• For these lines, it is checked that at least one open invoicing line exists.
• For any PO item within indexing data (header/item), the delivered PO lines are
checked if any line has the GR-IV based flag set.
• For these lines, it is checked that all lines are open for invoicing with the correct
amount.
• For any PO number within indexing data (header/item), the PO lines are checked
if any line has the GR-IV based flag set.
• For these lines, it is checked that at least one open invoicing line exists.
• For any PO item within indexing data (header/item), the delivered PO lines are
checked if any line has the GR-IV based flag set.
• For these lines, it is checked that all lines are open for invoicing with the correct
amount.
Scenario 1 If the withholding tax type is not valid for the invoice vendor, the exception is
raised.
OR
Scenario 2 If the withholding tax type is not valid for the invoicing party, and the invoicing
party is maintained at PO level with the IGNORE_IP field cleared in the indexing
screen, the exception is raised.
Vendor Specific You can define tolerance groups for each company code using the OMRX transaction.
Tolerance You can assign tolerance groups to each supplier (vendor) in the vendor master
record, using the XK03 transaction.
If the difference is within the tolerance range, the system automatically generates a
difference line on a neutral income/expense account for small differences. This
applies to invoices with debit/credit differences when posting the invoice.
The baseline configuration of this business rule contains predefined process options.
You can adjust the process options list to suit your scenarios.
Down payment The down payment clearing function is used to clear the down payments that are
clearing in SAP posted with reference to a PO directly in logistics invoice verification (MIRO
transaction). During posting through MIRO, the system checks if the down payment
was made earlier for the respective PO. MIRO provides a way to enter the down
payment data through the Down Payment Clearing button.
If the vendor on the invoice belongs to India and if the GST Partner (GST_PART)
field value is empty or not maintained in vendor master, then this exception is
raised. The invoice is automatically routed to the pre-configured agent depending
on the role for further action.
Then this exception is raised and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
The field value of the Receiving Entity GST Registration Number (REC_GST_REG_NUM)
might be empty. It also might not match against the GST Registration Number
(GSTIN) of the combination of the receiving company code / business place.
In these cases, this exception is raised. The invoice is automatically routed to the pre-
configured agent depending on the role for further action.
It is also activated after the finish of the Fiori app step to let the AP role verify the
information passed from the Fiori app and decide on the next steps.
Reduction invoice
If the value of the correction ID field (KZMEK) is Vendor Error. Reduce Invoice,
the system raises this exception.
No reduction invoice
If the correction ID (KZMEK) has a value different from Vendor Error. Reduce
Invoice, the system does not raise this exception and considers this invoice as a
normal invoice.
Exists
The lean service entry sheet exists. In this case, no action is taken and the
document proceeds to the next logical step.
Check whether any PO positions of the related POs have the GR flag enabled
(indicator WEPOS) and the product type group is 2 (Service). If, for any of those
positions, no service entry sheet can be found in the current MIRO line item proposal,
the exception is raised.
For this scenario, a new business rule Check lean services - invoice amount vs GR
amount (PO) is introduced. If the DP line item amount is higher than the open
amount to be invoiced, the system raises the exception.
BDC ID supported
2200
Technical Field INV_REF_NUM is marked as a required field in the Sequence Steps under the
information Document Type Definition configuration.
This chapter describes the various business rules for NPO invoices. The business
rules are delivered out of the box with the product including the high level business
logic of each of these rules.
Exists
The invoice supplier exists in the SAP S/4HANA system as a vendor. In this
case, no action is taken, and the document proceeds to the next logical step.
Does not exist
The invoice supplier does not exist in the SAP S/4HANA system as a vendor.
The exception Invalid Vendor (NPO) is raised, and the invoice is automatically
routed to the pre-configured agent depending on the role for further action.
Exists
The currency on the supplier invoice exists in SAP S/4HANA. In this case, no
action is taken, and the document proceeds to the next logical step.
Does not exist
The currency on the supplier invoice does not exist in SAP S/4HANA. The
exception Invalid Currency (NPO) is raised and the work item is automatically
routed to the pre-configured agent depending on the role for further action.
Exists
The requestor mentioned on the supplier invoice exists in the recipient’s SAP S/
4HANA system. In this case, no action is taken, and the document proceeds to
the next logical step.
Does not exist
The requestor mentioned on the supplier invoice does not exist in the recipient’s
SAP S/4HANA system. The exception Invalid Requestor ID (NPO) is raised,
and the invoice is automatically routed to the pre-configured agent depending
on the role for further action.
Not a duplicate
If the invoice is not a duplicate, no action is taken, and the document proceeds to
the next logical step.
Duplicate
If the invoice is a duplicate, the exception Suspected Duplicate (NPO) is raised,
and the work item is automatically routed to the pre-configured agent
depending on the role for further action.
Technical Field CREDIT_MEMO will be checked. If this field of a NPO invoice is checked, the
information invoice is considered as a Credit Memo.
All invoices of other vendors shall have the Expense Type ST - Standard.
Match
The supplier VAT/Tax number provided on the invoice matches with the VAT/
Tax number mentioned in the vendor master. In this case, no action is taken, and
the document proceeds to the next logical step.
Mismatch
The supplier VAT/Tax number provided on the invoice does not match with the
VAT/Tax number mentioned in the vendor master in SAP S/4HANA. The
exception Invalid Vendor VAT Number (NPO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Match
The Remit-To-Address provided on the invoice matches with the address on the
vendor master. In this case, no action is taken, and the document proceeds to the
next logical step.
Mismatch
The Remit-To-Address does not match with the address on the vendor master.
The exception Vendor Address Mismatch (NPO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
• House #
• Street
• Postal Code
• City
• Region
• Country
Entered
The invoice date is entered on the DP index document header. In this case, no
action is taken, and the document proceeds to the next logical step.
Not entered
The invoice date is not entered on the DP index document header. The exception
Missing Invoice Date (NPO) is raised, and the invoice is automatically routed to
the pre-configured agent depending on the role for further action.
Technical If field BLDAT of the indexing data is not filled -> Exception
information
When this business rule is applied, the tax information provided on the vendor
invoice is analyzed and mapped to standard SAP tax values (tax codes) and passed
onto the DP document. Depending on the OpenText VIM for SAP specific tax
configuration settings (with auto calculate tax or without auto calculate tax), the tax
information is validated. In case of any deviations, the exception Invalid Tax Info
(NPO) is raised, and the invoice is routed to the pre-configured agent depending on
the role for further action. There are many scenarios that can arise depending on the
configuration. In the following, some of the possible scenarios are described:
Example: The VAT % mentioned on the invoice does not have a corresponding VAT tax
code in SAP S/4HANA.
Example: The payable VAT % or VAT amount is not present on the vendor’s invoice.
When this business rule is applied, the recipient VAT number provided on the
invoice must match with the company’s VAT number provided in the company
code in SAP S/4HANA. The following scenarios can apply:
Match
The recipient’s VAT number provided on the invoice matches with the VAT
number mentioned in the company code information. In this case, no action is
taken, and the document proceeds to the next logical step.
Mismatch
The recipient’s VAT number provided on the invoice does not match with the
VAT number mentioned in the company code in SAP S/4HANA. The exception
Invalid Recipient VAT Number is raised, and the invoice is automatically routed
to the pre-configured agent depending on the role for further action.
Not present
If the recipient’s VAT number is not present on the invoice, the exception
Invalid Recipient VAT Number is raised, and the invoice is automatically routed
to the pre-configured agent depending on the role for further action.
When this business rule is applied, the ISR number on the DP index document
header should be present and matching with the vendor master. The following
scenarios are possible:
Match
The payment terms provided on the vendor’s invoice matches with the payment
terms mentioned in the vendor master in SAP S/4HANA. In this case, no action
is taken, and the document proceeds to the next logical step.
Mismatch
The payment terms provided on the vendor’s invoice does not match with the
payment terms maintained in the vendor master in SAP S/4HANA. The
exception Payment Terms Mismatch (NPO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical The field SUPPLY_DATE must be filled. If it is not, the exception is raised.
information
Match
The SIRET number provided on the invoice matches with the SIRET number in
the vendor master. In this case, no action is taken, and the document proceeds to
the next logical step.
Mismatch
The SIRET number provided in the invoice does not match with the SIRET
number in the vendor master. The exception Invalid SIRET Number (NPO) is
raised, and the invoice is automatically routed to the pre-configured agent
depending on the role for further action.
Match
The recipient address provided on the invoice matches with the company code
address. In this case, no action is taken, and the document proceeds to the next
logical step.
Mismatch
The recipient address does not match with the address of the company code.
The exception Invalid Company Address (NPO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
Technical In the baseline, field XBLNR is set as Required field. That means the value of this field
information in the indexing data is checked. If it is empty -> exception
Match
The payment method provided on the vendor’s invoice matches with the
payment method mentioned in the vendor master in SAP S/4HANA. In this
case, no action is taken, and the document proceeds to the next logical step.
Mismatch
The payment method provided on the vendor’s invoice does not match with the
payment method maintained in the vendor master in SAP S/4HANA. The
exception Payment Method Mismatch (NPO) is raised, and the invoice is
automatically routed to the pre-configured agent depending on the role for
further action.
PA
Pre-approved. This Expense Type is delivered from OCR.
UT
Utility invoices from vendors that match the predefined Utility Vendors.
ST
Standard for other invoices.
The FM checks the vendor in the invoice against the vendors maintained in table /
OPT/VIM_BL_UTLV. If the vendor is maintained as Utility Vendor, the Expense Type is
set to UT. Otherwise the Expense Type is set to ST.
• If the tax rate = 0 and the Tax Exempt Text field is blank, and there are no
different tax codes in the line items.
• If the tax rate > 0 and the Tax Exempt Text field is filled with text.
Information matching
The ship-to region, tax types entered on the DP document matches with the
configured SAP S/4HANA tax type for that region. The document proceeds to
the next logical step.
Example: For region Ontario, the tax type GST is supplied, and the tax type GST is
configured in SAP S/4HANA for that region.
Example: For region Ontario, the tax type GST is supplied, and the tax type configured
in SAP S/4HANA is PST for that region.
Blank
Keep the not present information as blank and raise exception Invalid Sales
Tax for the Region (NPO). The document is automatically routed to the pre-
configured agent depending on the role for further action.
Customization Run the /n/OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > Document
Type Configuration > Specific Country Settings > Canada.
In the Expense Type Definition Maintenance (View), you can maintain whether
Approval is required for a specific Expense Type.
No audit required
The vendor is not subjected to audit. In this case, no action is taken and the
document proceeds to the next logical step.
Audit required
The vendor is subjected to audit. An exception Vendor Audit Required (NPO) is
raised, and the invoice is automatically routed to the pre-configured agent
depending on the role for further action.
For more information, see “Vendor Audit Required (PO)” on page 246.
To use this business rule, you must maintain and activate the new process type 271
in the document type configuration, navigating to /OPT/SPRO > OpenText Vendor
Invoice Management Invoice Solution > Document Processing Configuration >
Document Type Configuration > Maintain Document Types. For background
information, see Section 8.1.2 “Defining process types” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
In the Baseline configuration, the process type is not characteristic specific (the
Characteristic Check check box is not set). Therefore, you do not have to maintain
the process type for characteristic.
In the document type configuration, Sequence Steps, use the function module /OPT/
VIM_DETERMINE_PROC_450 as Check Function for DP Document Type NPO_S4, Step
ID 418. For background information, see Section [Link] “Defining sequence steps” in
OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD).
In the Baseline configuration, the business rule is added to the document type
NPO_S4 but it is not activated.
If the check fails, the exception Invalid Payment Reference (NPO) is raised, and the
invoice is automatically routed to the pre-configured agent depending on the role
for further action.
Technical To use this business rule, the INVOICE_CODE field must be configured as required
information field.
If the invoice code length is equal to 10, then the 7th digit should be one of the
following digits: 1, 2, 3, 4, or 6. If this is not the case, the exception Invalid Invoice
Code Format (NPO) is raised and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
• Digits from 0 to 9
• Characters like +, /, <, >, -, and *
Otherwise, the exception Invalid Characters in Secret Code (NPO) is raised, and
the invoice is automatically routed to the pre-configured agent depending on the
role for further action.
Technical To use this business rule, the VEND_NAME field must be configured as required field.
information
Technical To use this business rule, the RECIPIENT_NAME field must be configured as required
information field.
Technical The rule needs to be activated for relevant countries in the Country/Characteristic-
Information specific settings for foreign vendors. There is no function module used, the check is
achieved using configuration only.
The baseline configuration of this business rule contains predefined process options.
You can adjust the process options list to suit your scenarios.
If the vendor on the invoice belongs to India and if the GST Partner (GST_PART)
field value is empty or not maintained in vendor master, then this exception is
raised. The invoice is automatically routed to the pre-configured agent depending
on the role for further action.
• HSN/SAC code on NPO invoice lines does not match with value of “control
code” (STEUC) on “Foreign trade export” view of material master (MARC), of given
Material on NPO invoice lines.
Then this exception is raised and the invoice is automatically routed to the pre-
configured agent depending on the role for further action.
The field value of the Receiving Entity GST Registration Number (REC_GST_REG_NUM)
might be empty. It also might not match against the GST Registration Number
(GSTIN) of the combination of the receiving company code / business place.
In these cases, this exception is raised. The invoice is automatically routed to the pre-
configured agent depending on the role for further action.
Technical FM : /OPT/VIM_DETERMINE_PROC_IN_429
information
Technical Field INV_REF_NUM is marked as a required field in the Sequence Steps under the
information Document Type Definition configuration.
Additional process types are implemented with a range from 580 to 600.
Technical FM /OPT/VIM_DETERMINE_PROC_437
Information
When the business rule is triggered, the Transportation Management PO can be
posted using Online PO posting process option 2009 Post PO Invoice. In the current
version, only a single TM PO can be processed.
This section describes general business rules that are independent from NPO or PO.
Note: As of version 7.0 SP3, only the Ariba inbound interface triggers this.
This business rule copies the supply date value into the VAT date. This is not a
dialog process type: it does not trigger an exception. The same process type has to be
used for both PO and NPO invoices. You can enable it for individual document
types or using characteristics.
Use the same process type for both PO and Non PO invoices. You can enable the
process type for individual document types or using characteristics. In standard
configuration, the process type is enabled in the characteristic specific process types
for Switzerland only.
Summary tables
Besides the business rules delivered along with baseline, you can create custom
business rules as well as implement custom function modules for your business
rules to meet your needs. OpenText delivers some function module templates that
you can configure or implement. The functions are example functions.
Vendor Specific You can define tolerance groups for each company code using the OMRX transaction.
Tolerance You can assign tolerance groups to each supplier (vendor) in the vendor master
record, using the XK03 transaction.
If the difference is within the tolerance range, the system automatically generates a
difference line on a neutral income/expense account for small differences. This
applies to invoices with debit/credit differences when posting the invoice.
• They must confirm header fields, which is normally done by the ENTER key,
before they click the simulation button.
• They must save item fields, which is done by clicking SAVE or SUBMIT, before
they click the simulation button.
The task of logic modules is to check whether data is missing for a document and to
add the data where possible. This data enrichment is mostly scheduled before the
business rules run. It can be useful to also trigger some logic modules at a later point
of time, for example if the user has entered data on the indexing screen and presses
Rerun Business Rules.
Business rule Check BPF Added Data (process types 404 and 405) has been added. It
“informs” the user that a logic module has added data to the document. Business
rules are intended to check document data whereas logic modules are intended to
also change document data.
You can group logic modules into process IDs and schedule them to run at the
following points in time:
• at process start
• at rerun business rules
• at both (process start and rerun business rules)
The mapping modules are intended to run before the DP workflow is started. They
replace enhanced mapping functions.
Changing and deleting modules check data and modify if certain conditions are
fulfilled. Some of them are intended to run at process start, others during rerun
business rules.
• Global processing
• PO processing
• NPO processing
• Country specific
The baseline customizing contains preconfigured process IDs that you must map to
PO and NPO document types. Some global processing is active for all document
types.
Configuration Run the /OPT/SPRO transaction and navigate to OpenText Vendor Invoice
point Management Invoice Solution > Document Processing Configuration > Document
Type Configuration > Logic Module Processing.
For details, see Section 8.4 “Processing logic modules” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
Precondition
Vendor number and company code are filled.
Data affected
Vendor group
Class interface
/OPT/CL_D_LM_CHG_V_GRP
The logic module determines the partner bank type along with all corresponding
fields (for example bank name), based on the data provided in the invoice. If there is
only one entry in the vendor record that matches with the data on the invoice, this
entry is set as the result. In ambiguous cases, no data is changed.
In the most typical case, when the Capture process extracts the IBAN value from an
invoice, and that IBAN is found in the vendor record, the remaining fields like
partner bank type, bank name, SWIFT/BIC code, and so on, are determined.
Category
Mapping
Precondition
Partner bank type is empty.
Data affected
All bank data is filled if available in vendor master.
Class interface
/OPT/CL_D_LM_DETERM_BANKDATA
Category
Simple mapping
Precondition
SAP document type is empty.
Data affected
SAP document type is filled.
Class interface
/OPT/CL_D_LM_DETERM_BLART
Category
Simple mapping
Precondition
Invoice category is filled in the inbound process.
Data affected
Invoice category contains an OpenText VIM for SAP specific value.
Class interface
/OPT/CL_D_LM_DETERM_INV_CAT
Category
Mapping
Precondition
Document type, vendor number and company code are filled.
Data affected
Payment terms are filled.
Class interface
/OPT/CL_D_LM_DETERM_PAY_TERM
Category
Mapping
Precondition
Payment baseline date is empty.
Data affected
Payment baseline date is filled.
Class interface
/OPT/CL_D_LM_DETERM_PBL_DATE
Category
Simple mapping
Precondition
Posting date or posting date determination is empty.
Data affected
Posting date is filled.
Class interface
/OPT/CL_D_LM_DETERM_POST_DATE
Category
Simple mapping
Precondition
Tax code is empty.
Data affected
Tax code is filled.
Class interface
/OPT/CL_D_LM_DETERM_TAX_CODE
Category
Simple mapping
Precondition
Document “transaction” field is initial and old credit memo flag is filled.
Data affected
New credit memo flag is filled.
Class interface
/OPT/CL_D_LM_DETERM_VORGANG
Category
Simple mapping
Precondition
Vendor number is filled.
Data affected
Vendor address is filled.
Class interface
/OPT/CL_D_LM_DETERM_V_ADR
Category
Simple mapping
Precondition
Vendor number and company code are filled.
Data affected
Vendor group is filled.
Class interface
/OPT/CL_D_LM_DETERM_V_GRP
Category
Simple mapping
Precondition
Vendor name is empty and vendor number is filled.
Data affected
Vendor name is filled.
Class interface
/OPT/CL_D_LM_DETERM_V_NAME
Category
Mapping
Precondition
Vendor number and company code are filled and subject to withholding tax.
The following data is required to retrieve withholding tax.
For PO documents
• Company code
• Vendor
• Total gross amount
• PO number
• Tax code for net or tax based withholding tax type
• Company code
• Vendor
• Total gross amount
• Currency
• Posting date
• At least one line item
Data affected
Withholding tax data is filled.
Class interface
/OPT/CL_D_LM_FILL_WHT
Category
Simple mapping
Precondition
Not applicable
Data affected
Item text fields SGTXT and MAKTX contain the same text.
Class interface
/OPT/CL_D_LM_SYNC_ITEM_TXT
Category
Simple mapping
Precondition
Relevant for PO based documents only
Data affected
The logic module determines the purchasing document category from PO
master data.
Class interface
/OPT/CL_D_LM_DETERM_BSTYP
Precondition
Vendor number and vendor tax/VAT number are filled.
Data affected
Vendor tax/VAT number
Class interface
/OPT/CL_D_LM_FCOPY_VEND_TAX_ID
Precondition
Vendor number and vendor tax/VAT number are filled, company code and
recipient tax number are filled. Tax ID normalization is enabled for the
respective country.
Data affected
Vendor tax/VAT number, recipient tax number
Class interface
/OPT/CL_D_LM_NORMALIZE_TAX_IDS
Category
Simple mapping
Precondition
Relevant if tax description has been recognized
Data affected
The logic module maps the tax description to the tax invoice flag.
Class interface
/OPT/CL_D_LM_DETERM_TAX_INV
Category
Document creation
Precondition
This needs to be activated in the process type assignment in the OpenText VIM
for SAP document type. For more information, see Section 8.3.2 “Configuring
automatic parking after the start of the DP process” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Data affected
The logic module automatically tries to create a completely parked document. If
this fails, it tries to create a parked document. If this fails as well, the logic tries
to create a held document.
Class interface
/OPT/CL_D_LM_CREATE_PARKED
Category
Document creation
Precondition
This needs to be activated in the process type assignment in the OpenText VIM
for SAP document type. For more information, see Section 8.3.2 “Configuring
automatic parking after the start of the DP process” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Data affected
The logic module automatically tries to create a held document.
Class interface
/OPT/CL_D_LM_CREATE_HOLD
Category
Document creation
Precondition
This needs to be activated in the process type assignment in the OpenText VIM
for SAP document type. For more information, see Section 8.3.2 “Configuring
automatic parking after the start of the DP process” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Data affected
The logic module automatically tries to create a completely parked document.
Class interface
/OPT/CL_D_LM_CREATE_PARK_COMP
Category
Document creation
Precondition
This needs to be activated in the process type assignment in the OpenText VIM
for SAP document type. For more information, see Section 8.3.2 “Configuring
automatic parking after the start of the DP process” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Data affected
The logic module automatically tries to create a parked document.
Class interface
/OPT/CL_D_LM_CREATE_PARK
Category
Inbound Processing
Precondition
The document data was provided by OCR extraction process done in OpenText
Capture for SAP Solutions or OpenText Core Capture for SAP Solutions.
Data affected
Statistics about extracted and validated fields are collected and stored.
Class interface
/OTX/PS03_CL_D_LM_EXTANALYTICS
Category
Mapping
Precondition
Invoice receipt date is empty when coming from inbound.
Data affected
Invoice Receipt Date field is filled with Archived Date.
Class interface
/OPT/CL_D_LM_DETERM_INVREC_DAT
Category
Mapping
Precondition
Payment Method Supplement is empty when coming from inbound.
Data affected
Payment Method Supplement is filled based on the value maintained in the
Vendor details.
Class interface
/OPT/CL_D_LM_PYMNT_SUPP_MTHD
Category
Simple mapping
Precondition
Currency is empty and PO number is filled.
Data affected
Currency is filled.
Class interface
/OPT/CL_D_LM_DETERM_CURR
Note: This logical module may run when you do not have line item data yet,
because, in the baseline configuration, the logical module is placed before the
PO line item proposal module. If you will later use different, not the oldest,
GRs in the line items of the document, the assigned value might not be set as
expected. In such cases, you can rearrange the sequence in which the logical
modules run, as a project specific configuration.
Category
Simple mapping
Precondition
Delivery date is empty and PO number is filled.
Data affected
Delivery date is filled.
Class interface
/OPT/CL_D_LM_DETERM_DEL_DATE
Category
Mapping at process start
Precondition
PO number is filled.
Data affected
PO item data is retrieved.
Class interface
/OOPT/CL_D_LM_DETERM_PO_MAP2
Category
Mapping at process start
Precondition
Single line item invoice; PO number is empty and vendor is filled. The
document must be an invoice (not a down payment or a credit memo), and the
document must have skipped validation.
Data affected
PO data is retrieved. The document type is redetermined and might be changed
from an NPO document type to an appropriate PO document type.
Class interface
/OPT/CL_D_LM_DETERM_PO_SGL1
Note: This logic module is not active by baseline. Use it only if it is very
unlikely that NPO invoices come in with amounts that would match an
open PO from the same vendor.
Category
Simple mapping
Precondition
Vendor number is empty and PO number is filled.
Data affected
Vendor number is filled
Class interface
/OPT/CL_D_LM_DETERM_LIFNR
Category
Simple mapping
Precondition
Address data of CPD vendor is empty in OpenText VIM for SAP tables.
Data affected
Address data of CPD vendor is filled from purchase order.
Class interface
/OPT/CL_D_LM_DETERM_CPD
Category
Mapping
Precondition
PO number(s) provided, and the inbound process delivers valid additional cost
lines.
Data affected
Depending on the OpenText VIM for SAP additional cost customizing
Class interface
/OPT/CL_D_LM_MAP_ADD_COSTS
Category
Mapping
Precondition
PO number and invoice header amount are filled. The PO amount is identical to
the GR amount and the invoice amount.
Data affected
Line items are overwritten.
Class interface
/OPT/CL_D_LM_MAP_HEADER_PO
Category
Changing data
Precondition
Company code, PO number and vendor number are filled.
Data affected
PO number, PO line item data, document type
Class interface
/OPT/CL_D_LM_VERIFY_DATA
Category
Mapping at process start
Precondition
Channel VIM_IES. If another channel should be processed, you can configure
this in the customizing.
Data affected
Line items from OCR are deleted or not depending on the setting Ignore Items
from Ext System in the document type definition. For more information, see
Section 8.1.1 “Creating a new DP document type” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Class interface
/OPT/CL_D_LM_DETERM_PO_OCR
Category
Simple mapping
Precondition
CM Reference number is filled.
Data affected
Invoice reference is filled with the reference of the original invoice.
Class interface
/OPT/CL_D_LM_DETERM_CM_INV_REF
Category
Mapping
Precondition
Invoice has at least two line items. Line items do not contain different values in
fields like tax code, tax rate, and others that hinder the consolidation into one.
Data affected
Invoice line items are consolidated into one.
Class interface
/OPT/CL_D_LM_DETERM_FRM_PO
This logic module fills the /OPT/VIM_1PO_DN table where the data from the Inbound
channel is received.
Category
Simple Mapping
Precondition
Freight Order, Freight Settlement Document, House Bill of Lading, Air Waybill.
Data affected
Updates the /OPT/VIM_1PO_DN table.
Class interface
/OPT/CL_D_LM_FILL_TM_LISTS
Category
Simple mapping
Precondition
Expense type is empty and vendor is filled.
Data affected
Expense type is filled.
Class interface
/OPT/CL_D_LM_DETERM_EXP
Category
Mapping at process start
Precondition
NPO document type and no line item.
Data affected
One line item is created from header data.
Class interface
/OPT/CL_D_LM_DETERM_NPO_LINE
Category
Mapping at process start
Precondition
No purchase order numbers or delivery notes are used on the invoice.
Data affected
Line item coding data is filled.
Class interface
/OPT/CL_D_LM_DETERM_NPO_COD
Category
Mapping at process start
Precondition
Channel VIM_IES. If another channel should be processed, you can configure
this in the customizing.
Data affected
Line items from OCR are deleted or not depending on the setting Ignore Items
from Ext System in the document type definition. For more information, see
Section 8.1.1 “Creating a new DP document type” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Class interface
/OPT/CL_D_LM_DETERM_NPO_OCR
Category
Simple mapping
Precondition
Line items present
Data affected
Existing NPO line items are enriched with posting relevant information:
• Company code, plant, business place (BUPLA), and business area (GSBER) are
copied from header data if empty.
• Fields not relevant for posting are emptied: quantity and related units.
Class interface
/OPT/CL_D_LM_DETERM_NPO_ENR
Category
Mapping at process start
Precondition
No purchase order numbers or delivery notes are used on the invoice
Training data for company code and vendor with cost line item confidence
above the confidence limit in Z constant SMART_CODE_MODEL
Data affected
Smart line item coding data is filled.
Class interface
/OTX/PS39_CL_D_LM_DET_NPO_SCOD
Category
Simple mapping
Precondition
CM Reference number is filled.
Data affected
Invoice reference is filled with the reference of the original invoice.
Class interface
/OPT/CL_D_LM_DETERM_CM_INV_REF
Category
Simple mapping
Precondition
Country is Canada and ship-to region is empty.
Data affected
Ship-to region is filled.
Class interface
/OPT/CL_D_LM_DETERM_SHP_REGN
Category
Mapping
Precondition
Country is Russia and invoice category contains either a V or a W.
Data affected
Four corrective line items are condensed to one line.
Class interface
/OPT/CL_D_LM_MAP_R_CORR_ITEMS
Category
Mapping
Precondition
Country is Russia, the PO number is empty and the invoice category contains M.
A PO with corresponding net price and quantity exists for the vendor.
Data affected
Service PO is filled.
Class interface
/OPT/CL_D_LM_MAP_R_SERV_PO
Category
Mapping
Precondition
Country is Denmark. Company code is filled and payment reference is
provided.
Data affected
KIDNO is filled.
Class interface
/OPT/CL_D_LM_VERIFY_KIDNO
Category
Simple mapping
Precondition
The country of the company code is China (CN).
Data affected
The invoice category is mapped based on the invoice code.
Class interface
/OPT/CL_D_LM_DETERM_COUNTRY_CN
Category
Simple mapping
Precondition
The country of the company code is France (FR).
Data affected
The Siret Number field is mapped from the vendor tax number.
Class interface
OPT/CL_D_LM_DETERM_COUNTRY_FR
Category
Simple mapping
Precondition
The country of the company code is India (IN).
Data affected
The logic module maps the PAN and STC number into the vendor tax number
and determines the invoice category.
Class interface
/OPT/CL_D_LM_DETERM_COUNTRY_IN
Category
Simple mapping
Precondition
Country is Spain. Long reference number is filled, and Z constant SET_REF_
MAPPING_SP has lengths in the format X16,B20 where 16 and 20 are the desired
lengths of XBLNR and BKTXT.
Data affected
Long reference number is split into text and invoice reference.
Class interface
/OPT/CL_D_LM_DETERM_BKTXT_XBLN
OpenText VIM for SAP provides a feature that allows you to add mapping activities
after the field mapping is done. In this Automated Field Enhancement (also called
enhanced mapping), you can refer to the values of different fields.
In the field mapping, the relation between source field and target field is a 1:1
relation. This is visible in the mapping table. With Automated Field Enhancement,
this is not the case. “Baseline of Automated Field Enhancement“ on page 349 shows
the relation between source fields and target fields.
This part provides a list of the Z constants that are used in OpenText VIM for SAP.
There are individual chapters for each product code.
002, 009
Cross component product codes
005
Document Processing (DP) based product codes
IAP
Invoice Approval product codes
IEA
Product codes for Unified Dashboard and archiving supports
IEM
Invoice Exception Monitor product codes
LIX
LIV based product codes (both for PO parking and PO blocking workflows)
VAN
VIM Analytics product codes
Note: Setting this constant overrides the previously used setting in the
ARIBA channel.
BDC Id to be called
by Function /OPT/
VIM_PREPOPULA
005 BDC_PARKING_ONLINE TE_MIR7 16
This constant is used in the FM /OPT/VIM_PREPOPULATE_MIR7. The FM is used
in BDC 201 to support PO invoice parking online in a special case with multiple
POs existing in the invoice. The BDC maintained in this constant is used for the
online parking option maintained with BDC 201.
Usually the PO line data of the DP document is used. For Brazilian invoices, the
reference number is used to retrieve delivery note data and to fill the line items
accordingly. If this Z constant is set to X, the enhancement ignores the Brazilian
specialty and uses the PO line data.
005 BR_TAX_ON_COND
To solve the problem of incorrect tax and balance calculation in specific situations
for Brazil and Indian invoices, OpenText VIM for SAP provides a user exit that
you can use, depending on project needs. A standard implementation is provided
as the function module /OPT/VIM_GET_TAX_AMOUNT.
005 BULK_APP_IMAGE Set the value 12
This Z constant is created to decrease the calls from SAP to Windows Viewer
while accessing images in bulk mode from VIM Invoice Workplace. Maintain the
Z constant value as 12-comments or 11-history (other than 10-image). This is
considered as the default tab in the plug-in area. User settings must be
maintained as 10-image.
Note: By maintaining this Z-constant, the user default tab setting in the
plug-in area is only affected for bulk mode.
Start OpenText
VIM for SAP
process in Central
System always
(X=via RFC,
C=direct call,
005 CENTRAL_VIM_PROCESS empty=no)
Checks if Update
Tasks are running
005 CHK_UPD_TSK_IS_ALIVE (when set to 'X') X
Description – When running a process option based on a call transaction (posting
or parking), the system checks if the update tasks are running. If not, a message
Update delayed. Please wait. is shown to the user.
--> Result in case 1 and 2: The workflow stays in the current state and can be
continued later.
Logging – If you activate the check, an application log entry (SLG1) is written:
Object: VIM, Subobject: DP, LogPoint 94 (Update Delayed), if any update delay
that is longer than 10 seconds was discovered.
Scope – Activate this function if the system often experiences issues with update
tasks or inconsistencies between posted documents and OpenText VIM for SAP
data. The additional check improves the stability when posting invoices in dialog
in these environments. However, the check can slightly slow down processing.
MIME file type for
main invoice image
for Ariba
005 CIG_MAIN_ATTACH Integration
This constant is used in the Ariba CIG integration component. When suppliers
are sending attachments along with the Ariba invoice, typically as PDF files, you
might want to use those attachments as the main invoice image. You must set the
value to the MIME type to select the file types to be used. Example value:
application/pdf
Flag (x = manual
change of BRF-
Bypass allowed in
COMPL_ALLOW_M_BYPA Simulation/Bypass
005 SS Popup) X
Note: Only the 10 first characters of the constant are considered as prefix.
Set to X to prevent
from simulating all
rules at DP WF
005 DP_START_NO_ALLRULES start
Note: The setting does not mean that no rules are run at all.
DP indexing screen
005 DP_VALIDATE_EXIT - validation exit <empty>
This constant allows you to implement custom validation in the DP indexing
screen. Maintain the name of the user exit function module as the constant value.
For more information see Section 8.18.2 “Implementing custom field validation in
the DP indexing screen” in OpenText Vendor Invoice Management for SAP Solutions -
Configuration Guide for Invoice Solution (VIMZ-CGD).
Enter lock message
005 DR_BR_LOCK_MSG for dr br wait <empty>
This constant is part of the program /OPT/DR_BR_WAIT. The default value is
empty. While running the /OPT/DR_BR_WAIT program, if any conflicting lock
occurs, find message ID and message number from the /opt/vim_1bdclog table,
and enter “<message ID>-<message number>” as value for this constant. If more
than one message exists, separate them with :
Example: M8-007:MK-534
005 EDI_CHANNEL_ID EDI Channel ID IDOC
Maintain the channel ID that is used during processing of an incoming IDOC.
Note: This is used only for the direct IDOC processing with the handler
function /OPT/START_DP_WF_FROM_IDOC and not with VIM
Foundation IDOC handler.
EDI visualization/
image archiving
exit (Template: /
OPT/
EDI_IMAGES_EXI
005 EDI_IMAGES_FM T_TEMP)
For more information, see Section 7.6.2 “Rendering IDocs to PDF” in OpenText
Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD). This is used only for the direct IDOC processing with the
handler function /OPT/START_DP_WF_FROM_IDOC and not with VIM
Foundation IDOC handler.
Default XML
005 EINV_XML_DOC_TYPE document type
Note: ISR processing is not relevant for Swiss invoice process anymore,
therefore OpenText recommends that you disable that process type.
FM Exit to
populate container
in custom rule for
Org Unit based /PTGWFI/
005 EXIT_RULE_RESOLUTION template COA_W_CONT_ELEMENT
You might want to use a custom rule, created in transaction PFAC, and integrate
this rule into OpenText VIM for SAP. A custom rule is always associated with the
custom rule container. To support the integration of the custom rule, you must
implement a custom function module that populates the value of the custom rule
container to OpenText VIM for SAP parameters. You must maintain this function
module in the Z constant 005 / EXIT_RULE_RESOLUTION. You can use the
function module template /PTGWFI/COA_W_CONT_ELEMENT for this purpose.
Partner Roles for
PO Vendor. Use
the values from
table view
V_TPAUM which
are not language
005 EXIT_VEND_PARTN_FUNC specific RS,WL
For more information, see “Vendor Mismatch (PO)” on page 246.
Mapping of line
items for custom FM interface: /OPT/
005 EXT_MAP_LINE_ITEM fields VIM_EXT_LINE_MAPPING
You can use this constant to map custom invoice fields or change line item data
before passing it to the tax calculation functions. The constant value must contain
a function module name. The function module interface must be the same as that
of /OPT/VIM_EXT_LINE_MAPPING.
Important
Only activate this constant if you have implemented the latest SAP Notes
for external tax systems, including 1434921 and 1241247.
Activate this constant with value X to ensure that the function module is called.
This updates the data properly.
Move PO number
from list / item to
header in case of
005 FAIL_PO_HEADER_SET exception for PO
This constant is called in function module /OPT/VIM_DETERMINE_PROC_161,
which is used in the business rule Company code mismatch (PO). When this
constant is set to X and when the exception occurs, the first PO with the
mismatching company code will be returned in the PO number field in the
header structure.
Enter X or exit-fm
name. Template: /
OPT/ /OPT/
VIM_COMPL_HID VIM_COMPL_HIDE_TEMP
005 FIORI_COMPLETED_FLAG E_TEMPLATE LATE
This constant is used in the indexing screen data to show or hide the Coding
Completed flag. You can maintain the following values:
• X = Flag is available.
• <space> = Flag is hidden.
• A custom exit function is used to fill the constant.
The template delivered in baseline is /OPT/VIM_COMPL_HIDE_TEMPLATE.
For more information, see Section 5.1.4 “Data pane” in OpenText Vendor Invoice
Management for SAP Solutions - User Guide for Invoice Solution (VIMZ-UGD),
heading G/L Account tab.
Semantic
Navigation: enter V
for vendor number,
005 FIORI_APPR_SEMA P for PO VP
This constant is used in the VIM Approve Invoices Fiori app to show a semantic
navigation link for vendor and/or purchase order.
If the Z constant is set to <blank>, the system is passing the PO data to the BAPI.
Note: Initially, the system allows the BAPI to post the TM document using
the PO information. Later, SAP makes it mandatory to fill the TM table in
the BAPI for processing TM data.
Maximum DPs
allowed to process
005 MAX_ALLOWED_DPS in workplace 3000
If set to ‘X’, Posting
Period Warning
Message Appears
Only Once in
005 MESS_ONE_TIME_ONLY Indexing Screen <blank>
When this Z constant is set to X, the Posting period xxxx is not open
warning message appears only once when navigating to the Process tab of the
indexing screen. When set to <blank>, the warning message appears every time
the user switches to the Process tab of the indexing screen.
Error to warning in
005 MESSAGE_VALIDATE_TM indexing screen X
This Z constant is used in Transportation Management (TM) data validation in
the indexing screen at screen level. It influences the navigation between the tabs
in the indexing screen.
If set to X, the system throws a warning message during validation, so the user is
able to navigate.
If set to <blank>, the system throws an error message.
This constant is helpful if SAP S/4HANA is integrated with a standalone TM
system.
The Process Type
number for which
the save should
check for the
005 MISSING_MANDATORY mandatory fields 138;238
<SPACE> (default) or ON
Web Viewer is launched, based on the ArchiveLink standard viewer
configuration, if the ArchiveLink exit for viewers (TOAEX) is active.
Read TOAEX with EXIT_ID = OA_OBJECTDISPLAY_01 AND ACTIVE = X and
use the function module found there (default: /IXOS/OA_X_OA_
OBJECTDISPLAY_01).
OFF
HTML/Native viewer is launched, whether or not the ArchiveLink exit for
viewers (TOAEX) is active.
<Customer function module name>
You can have a custom implementation for the viewer to be launched for the
detail pane. The constant value is considered as the name of a function
module. It is called dynamically. In this case, only check if the function
module exists and do not check TOAEX. The template FM is /OPT/TMP_WEB_
DISP_IMG or /IXOS/OA_X_OA_OBJECTDISPLAY_01.
Wait constant to
handle responses
from simulate FM
in case of PO with
huge number of
005 PO_INV_SIMULATE_WAIT lines. 30 (seconds)
Class name for /OPT/
non-standard PO CL_D_LM_DETERM_PO_M
005 PO_ITEM_MATCH_CLASS item matching class AP2
/OPT/
PO item matching VIM_DBPF_FIND_PO_USE
005 PO_ITEM_MATCH_Exit PO Exit 22.4 SP6 D
Post tax entries for
an Accounting
Document, when 0
005 POST_ZERO_TAXLINES tax code is used <empty>
Set this z constant to X to post tax entries for an Accounting Document, when 0
tax code is used in a GST system. If set to <empty>, 0 tax code entries are not
posted for an Accounting Document in a GST system. By default, the constant
value is <empty>. For more information, see Section 9.3.2 “Tax components in
GST” in OpenText Vendor Invoice Management for SAP Solutions - Scenario Guide for
Invoice Solution (VIMZ-CCS).
If you maintain the email template with HTML tags present, set the constant
value to HTM1 to avoid double conversion of the HTML syntax.
Reminder mail
formatting exit
005 REM_MAIL_FORMAT_FM function
For more information, see Section 37.4 “Maintaining a notification email
formatting function module” in OpenText Vendor Invoice Management for SAP
Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
The Process Type
number for which
the required fields
are shown on the
005 REQUIRED_PROC_TYPE screen 138;238
Maintain process types for which mandatory index data header and item fields
should be handled as required input fields during the index screen processing.
Note: This is a table parameter. You can define several lines by specifying
different version numbers ZVER, if one line is not long enough to store all
the values you need. Regardless of the record version number, all entries
maintained for this Z constant are considered.
Option ID to Start
005 RESTART_DP DP Workflow 2014
Maintain the process option that triggers a restart of the OpenText VIM for SAP
document processing workflow.
Split RouteID-
>RouteID1/2:
PlaceOfSplit1/
NoOfDigits1/
PlaceofSplit2/
005 ROUTE_ID_SPLIT NoOfDigits2 9/6/15/4
When using the Return to Vendor (RTV) option, DP documents are made
obsolete. The RTV reason and comments are stored in the DP document but the
obsolete reason is not set. With this constant, you can specify which obsolete
reason, a two-character value, will be assigned to such documents. For more
information, see Section 22 “Return to Vendor” in OpenText Vendor Invoice
Management for SAP Solutions - Configuration Guide for Invoice Solution (VIMZ-
CGD).
Return to Vendor:
Standard Text
(SO10) for the mail /OPT/
005 RTV_SIGNATURE_NAME signature VIM_SIGNATURE_RTV
For more information, see Section 22.7 “Maintaining the email signature” in
OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD).
Prefix for standard
texts used for
005 RTV_TEMPLATE_PREFIX Return to Vendor /OPT/VIM_RTV
For more information, see Section 22.5 “Maintaining email templates” in
OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD)
Note: Large invoices with their corresponding data sets cause long run
time and potentially short dumps due to timeouts.
Option Id for
Sending Back to
005 SENDBACK_OPTION Central System 2013
Long Invoice
Reference Number
005 SET_REF_MAPPING_CN for China XBLNR+4(16),BKTXT
If the extracted reference number length is more than 16 characters, the last 16
characters are copied to reference number XBLNR, and the whole number is
copied to BKTXT.
For more information, see Section 7.1.2 “China - XML mapping” in OpenText
Vendor Invoice Management for SAP Solutions - Scenario Guide for Invoice Solution
(VIMZ-CCS)
This constant can be used for other header fields as well (any fields from /OPT/
VIM_1HEAD and /OPT/VIM_2HEAD).
Long Invoice
005 SET_REF_MAPPING_SP Reference Number X10,B25
For more information, see Section 9.9 “Spain” in OpenText Vendor Invoice
Management for SAP Solutions - Scenario Guide for Invoice Solution (VIMZ-CCS).
not set (Z constant entry is
not delivered in baseline
005 SET_TAX_CALC_FLAG configuration.)
Note: Setting this flag may affect the value calculated for the field Discount
base amount in the posted document. It also may have other side effects.
Set to X to allow
posting if
VATDATE is used
but cannot be
passed into
005 SKIP_VATDATE_CHECK document
This constant allows to bypass checks relevant for VAT Date in posting functions.
For more information, see Section 8.16.3 “Maintaining Z constant 005 /
SKIP_VATDATE_CHECK” in OpenText Vendor Invoice Management for SAP
Solutions - Configuration Guide for Invoice Solution (VIMZ-CGD).
SMART_CODE_LM_PROCI Smart coding logic
005 D module Process id N_SPEC_005
This constant is introduced for the smart coding logic module for validating field
input in the AFS ID configuration transaction. For more information, see Section
20.2 “Skipping the coder level in smart coding line automation” in OpenText
Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD).
Smart coding line
item proposal
005 SMART_CODE_MODEL confidence level 80
Note: This Z constant is not valid for BDC 2200 because for NPO
documents, after background posting is completed using BDC 2200, MM
Document GL Reference line items are written back into the original DP
document.
If set to 'N', invoice
items will not be
synced with RSEG
005 SYNC_ITEM_POSTED_PO after posting (PO)
In standard configuration, posted SAP document line item data is written back
into the original DP document. If you want to avoid this data synchronization, set
this constant value to N. In case of any other value, or if the constant is missing in
the constants table, the synchronization will be performed.
Process Type to
read the initial role
when sending back
005 SYSTEM_HANDLE_PTYPE to central system 171
When a document is being sent from a satellite back into central system, the
initial role of the workflow is set to the value that is read from the process type
settings that are maintained in the satellite. Set that process type in this constant.
Tax on vendor line
005 TAX_ON_VENDOR_LINE item in FB60 <blank>
Set the value to X if non-PO invoices posted with the BDC ID 34 must have their
tax amounts added into the vendor line item instead of accounting line items.
Set to X to enable
the logic to support
special processing
of goods invoices
between EU and
Northern Ireland.
Can be set to a
function module
name to extend the
005 UK_NI_CHARACT logic. not set
For more information, see Section 9.5 “Northern Ireland” in OpenText Vendor
Invoice Management for SAP Solutions - Scenario Guide for Invoice Solution (VIMZ-
CCS).
Important
• The automation report depends on change document data. If this
constant is set, the automation report will cancel with an error message.
• The Ariba integration depends on change document data. If the Ariba
package is installed in the system, this constant will have no effect.
Set to ‘X’ to
transfer indexing
screen wht amount
value to posting. If
empty the wht
amount is
calculated from
005 WHTAX_AMT_TR wht base amount.
For more information, see Section 21 “Extended withholding tax” in OpenText
Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD).
You can decide whether you want a balance problem to be a warning or an error.
This affects both the internal OpenText VIM for SAP check and also the optional
SAP BAPI validation check.
If you configure it to be a warning, even errors returned by SAP BAPI are
considered as warning. In this case, it does not stop the user from sending the
invoice further.
BDC Function to /ORS/
Be Called to Write 000007_NPO_SAVE_CODIN
IAP BDC_FUNCTION to Database G
For more information, see Section 20.6.4 “Changing BDC IDs” in OpenText Vendor
Invoice Management for SAP Solutions - Scenario Guide for Invoice Solution (VIMZ-
CCS).
BDC function to be
called to write to /ORS/
IAP BDC_FUNCTION_PO database 000007_PO_SAVE_CODING
This constant sets the function module that will be used to save parked PO
invoice accounting information.
Bulk approval/
reject invoice
validation (Ex
FM: /ORS/
AINV_BULK_VAL
IAP BULK_VALIDATE_EXIT IDATE_INV)
For more information, see Section 10.12.5 “Configuring the bulk approval
validation exit” in OpenText Vendor Invoice Management for SAP Solutions -
Configuration Guide for Invoice Solution (VIMZ-CGD).
Calculate tax on
net amount option
for DP approval
IAP CALC_TAX_ON_NET ('X' or ' ' or 'D')
For more information, see Section [Link] “Configuring tax calculation on net
amount” in OpenText Vendor Invoice Management for SAP Solutions - Configuration
Guide for Invoice Solution (VIMZ-CGD).
Cancel DP, Appr
wfs If Inv.
cancelled in SAP
(A= Only Post
Appr workflow,
IAP CANCEL_WF_FB08 B=Both) B
Standard Text
Object to appear as
Approval Certify
Message on Web
IAP CERTIFY_MESSAGE screen ZCERTIFY
For more information, see Section 10.4.11 “Configuring the Certify message” in
OpenText Vendor Invoice Management for SAP Solutions - Configuration Guide for
Invoice Solution (VIMZ-CGD).
Check SAP user
validity in COA
IAP CHECK_SAP_USER maintenance
If this constant is not set to X in table /PTGWFI/Z_CONST (or if it does not exist in
the table), the SAP user validity in COA is not checked. To enable the checks, set
the constant value to X.
Check if the
^TXJDC is to be
validated against
IAP CHECK_TXJCD the Cost Object X
Set this constant to X if you are using the BDC 34 to post invoices and you want
OpenText VIM for SAP to compare the tax jurisdiction code entered manually in
the line item with the code retrieved from the account assignment object. If they
are not the same, the standard message F5 532 will be displayed as a warning.
Enable individual
lock logic for COA
IAP COA_INDIVIDUAL_LOCK maintenance
This constant controls the lock logic for the alternative COA maintenance
transaction /OPT/AR_COA_MAINT.
Set the value to X to enable individual locking (grouped by company code, level,
and user).
Clear the value to enable global locking if you are processing large amounts of
data that might lead to reaching the global lock limit.
For more information, see Section [Link] “Maintaining COA - alternative
transaction” in OpenText Vendor Invoice Management for SAP Solutions -
Configuration Guide for Invoice Solution (VIMZ-CGD).
Extended COA line
check for next
approver
determination ('' =
IAP COA_LINE_CHECK_EXT off, 'X' = on)
Set to X to enable
multiple account
assignment
IAP MULTI_ACCT_ASSIGN elements in COA
Setting this constant to X enables the use of multiple cost elements for a COA line
and makes the authority checks logic similar to versions 5.2 and 6.0. For more
information, see Section 4.1.4 “Maintaining Chart of Authority” in OpenText
Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD).
Data validation
required during
coding for parked
PARK_CODE_VALIDATIO doc(X-yes,space -
IAP N No) X
When this Z constant is set, the data validation is executed before the data of a
parked invoice is saved or approved. This constant is checked in the function
modules /ORS/000007_NPO_SAVE_CODING and /ORS/000007_NPO_SAVE_
CODING2.
PO park approval -
Accounting data
editable or not (X-
Editable, Space -
IAP POPARK_APPR_ACCTEDIT no) X
When this Z constant is set, the accounting data of PO parked invoices is editable
in the approval screen. Otherwise it is not editable.
Indicator, if set ->
Maintaining
PORTAL_NOTMAINT_SUB Substitute in Portal
IAP S is not allowed
Enable PO Lines
IAP PO_ACC_SCR_EXIT for coding
This constant allows to enable coding for PO lines in the Invoice Approval in SAP
GUI. Implement a custom function module. Enter the name of your custom
function module in the constant value.
Notes
• Setting the constant value to I may result in longer load times of the
invoice list.
• The setting I is used only on version 7.0 Approval Portal, “old” UI.
Everywhere else, it has the same effect as the setting D.
If set to 'X',
accounting data
will not be
validated in
Coding / Approval
by simulating the
IAP SKIP_BAPICHECK posting with BAPI. X
For more information, see Section [Link] “Activating and deactivating approval
validation” in OpenText Vendor Invoice Management for SAP Solutions -
Configuration Guide for Invoice Solution (VIMZ-CGD).
If set to 'X' skips
Message KI 339
“Profit center was
IAP SKIP_PROFIT_CTR_MSG set to xxx” X
During the approval process, on the SAP GUI approval screen, message KI 339
“Profit center was set to xxx” cannot be disabled. When GL lines have different
cost centers, users are forced to click this message several times. To avoid this
behavior, set this Z constant to X.
Subscreen Number
for Usermap
Maintenance
IAP UMUTIL_SUBDYNP Utility 100
The subscreen maintained in this Z constant is used as the initial screen when
calling the Reassignment Utility (transaction /ORS/UMREASSIGNED). See Z
constant UMUTIL_SUBPROG.
Subscreen Program
for Usermap
Maintenance /ORS/
IAP UMUTIL_SUBPROG Utility 0000007_UMUTIL_DYNP
The program maintained in this Z constant in conjunction with Z constant
UMUTIL_SUBDYNP determines which initial screen is triggered when calling
the Reassignment Utility (transaction /ORS/UMREASSIGNED).
Popup window to
display company
code selection for /ORS/
cross company 000007_POPUP_COMPANY
IAP POPUP_COMPANY_CODE invoice approve _CODE
For more information, see Section 10.4.9 “Cross company coding” in OpenText
Vendor Invoice Management for SAP Solutions - Configuration Guide for Invoice
Solution (VIMZ-CGD).
Extended PO
Invoice Class
(Called in
Approval =>
GET_PO_INV_CL
IAP PO_INV_CLASS ASS) /ORS/PO_INVOICE_NEW
You may want to apply the same “Authorize”-type action to all line level
workflows of a blocked invoice. You also may want the action to apply only to
the other workflows with the same payment block as that of the current work
item. (Previously, up to and including version 5.2 SP10, all other workflows
would be cancelled and the header workflow started if you confirmed the
corresponding dialog question.)
If you need the workflows with other payment blocks to remain active, set the
constant value to X. The default configuration delivered with OpenText VIM for
SAP will have the old logic of cancelling all line level workflows of the invoice
(the constant value is blank).
Display invoice
image on display
of dash board
DASHBOARD_IMAGE_AU screen (X- Yes,
LIX TO space -No)
Set to X if invoice image must be displayed automatically when blocked invoice
dashboard is opened.
LIX DASHBOARD_NO_LOGO Display no Logo
If this constant is set to X, the logo is hidden in the parking and blocking
dashboard for PO invoices.
Exit FM to
influence the
LIX DB_OPTION_SEQ dashboard buttons
You can set a custom function to change the sequence of process options in the
dashboard. For the interface of the function, check the Release Notes of version
7.0 SP3 or 6.0 SP8.
Use old Delete and
Re-enter sequence
(duplicate error): 1.
LIX DELETE_ENTER_OLD Delete, 2. Re-enter
Constant for
determining due
date FM (for
notifications
VAN CALCULATE_DUEDATE report)
FM for currency
VAN CURRENCY_CONVERSION conversion
Detailed workitem
logging active ( X =
Active; Space =
VAN DETAILED_LOG_ACTIVE inactive) X
VAN DISPLAY_LOGO logo image name /OPT/VIM_OTLOGO
Use document date
when convert
VAN DOC_DATE_IN_CONVERT currency X
DOCUMENT
TYPE FOR CREDIT
VAN DOC_TYPE_CREDITMEMO MEMO KG;RA
Tran code used to
display all LIV
invoices during
drilldown
VAN INVOICE_DISPLAY_LIV reporting MIR4
In some OpenText VIM for SAP reports (for example VIM Analytics), it is
possible to use a link to go from the SAP invoice number (BELNR) to the display of
the corresponding SAP invoice. This is the transaction code that is used for
displaying PO invoices.
Tran code used to
display parked CIV
invoice during
drilldown
VAN INVOICE_DISPLAY_PIR reporting FBV3
In some OpenText VIM for SAP reports (for example VIM Analytics), it is
possible to use a link to go from the SAP invoice number (BELNR) to the display of
the corresponding SAP invoice. This is the transaction code that is used for
displaying Non-PO invoices.
INVOICE
DOCUMENT
TYPE FOR NON-
VAN INV_DOC_TYPES_NPO PO INVOICE KR;KG
INVOICE
DOCUMENT
TYPE FOR PO
VAN INV_DOC_TYPES_PO INVOICE RE;RG
After Image
Technical option to realize an delta upload from the source systems into the SAP
NetWeaver BW system. A data record loaded as After Image provides the status
of the record after it has been changed, or after data has been added.
Aging Report
Part of the Central Reporting infrastructure. The Aging Report reports about the
aging of documents and work items in the current system.
Approval Portal
Web interface for approving invoices.
Archive system
Computer system that enables storage, management and retrieval of archived
data and documents
ArchiveLink
Service integrated in the SAP NetWeaver Application Server ABAP for linking
archived documents and the application documents entered in the SAP ERP
system.
Authorization profiles
The SAP administrator assigns authorizations to the users that determine which
actions a user can perform in the SAP system. These authorizations are stored in
Authorization profiles.
Automation Report
Tool that provides data about automated and manual processing steps of
documents
BAdI
BAPI®
SAP programming interface: Business Application Programming Interface
Baseline
Set of functionality with predefined configuration and the starting point to
implement OpenText VIM for SAP.
BasisCube
See: InfoCube
BDC ID
Business Data Communication ID. The BDC ID is used by the system to process
an SAP transaction to create an SAP Document in user context.
Block
Situation where an invoice has a price or quantity variance that prevents invoice
from posting
BSP
BTE
Business rules
Rules that describe the operations, definitions and constraints that apply to an
organization
Capture
Common technical term for both of the following products: OpenText Core
Capture for SAP Solutions and OpenText Capture for SAP Solutions.
Central Reporting
Reporting infrastructure that provides several reports that enable you to measure
certain properties of documents and their work items, in order to optimize
working with OpenText VIM for SAP. Central Reporting comprises the following
individual reports: Aging Report, Central Audit Report, Exception Analysis Report,
Key Process Analytics Report, Productivity Report, and Summary Report.
Characteristic
Type of InfoObject in SAP NetWeaver BW that represents descriptions of fields,
such as Vendor ID, Invoice Number, Unit of Measure, and Posting Date.
COA
Coding
Coding allocates an invoice to G/L account and cost object if required.
Dashboard
User interface that organizes and presents information in a way that is easy to
read. Users can also perform actions from the dashboard.
DataSource
Set of fields in SAP NetWeaver BW that provide the data for a business unit for
data transfer to the SAP NetWeaver BW system; technically, it contains an extract
structure and an extraction function module.
DocuLink
OpenText™ DocuLink for SAP Solutions enables the archiving, management and
retrieval of SAP CRM or SAP S/4HANA documents from within the SAP
infrastructure.
Document type
Type of document such as PO, Non PO, OCR, Non OCR
DP
DSO
DTP
EDI
Exception
Action that is not part of normal operations or standards
FI
IAP
IDoc
IE
Inbound Configuration
Connection to various inbound channels, for example scanned paper documents,
fax, email, or IDoc, and the corresponding configuration.
Indexing
Process of entering or storing data into the system
InfoArea
Folder in SAP NetWeaver BW to organize InfoCubes, DataStore Objects, InfoObjects,
and InfoObject Catalogs
InfoCube
Self-contained dataset in SAP NetWeaver BW, for example, of a business-oriented
area; an InfoCube is a quantity of relational tables arranged according to the
enhanced star schema: A large fact table in the middle surrounded by several
dimension tables
InfoObject Catalog
Folder structure in SAP NetWeaver BW to organize InfoObjects
InfoObject
Smallest information unit in SAP NetWeaver BW. Key figures and Characteristics
are collectively called InfoObjects.
InfoPackages
Object in SAP NetWeaver BW that specifies when and how to load data from a
given source system to the SAP NetWeaver BW system
InfoProvider
Object in SAP NetWeaver BW for which queries can be created or executed.
InfoProviders are the objects or views that are relevant for reporting.
Invoice characteristic
A value specific to each invoice (for example country) that allows flexible
processing. An invoice characteristic is determined during runtime and depends
on the corresponding index data of the document.
Invoice coder
Person who enters the accounting info on invoices to allocate the cost
Invoice requester
Person who requested goods and services for Non PO invoices
Key Figure
Type of InfoObject in SAP NetWeaver BW that represents numeric values or
quantities, such as Number of Invoices and Gross Invoice Amount.
LIV
MM
MultiProvider
Object in SAP NetWeaver BW that is based on InfoCube(s), DataStore Object(s),
and/or InfoObject(s). A MultiProvider is used as a layer for the creation of end user
queries; the MultiProvider itself does not contain any data; rather, data resides in
the BasisCubes.
Namespace
Name range reserved by SAP for customer objects and SAP objects to make sure
that objects are not overwritten by SAP objects during the import of corrections or
an upgrade
Number range
Array of numbers that can be used for an object in the SAP S/4HANA system
OCR
Park
Situation where an invoice is not posted and is waiting for further processing
Perspective
Web Services element that defines which item related data is displayed in the
Fiori Task App and where. A perspective defines the content and visual
appearance of items for a specific area of the screen in the Fiori Task App. The
Fiori Task App displays only one perspective at the same time.
PO
Price variance
Situation where the price on the invoice is different from the price in the purchase
order
Process Chain
Sequence of processes in SAP NetWeaver BW that are scheduled to wait in the
background for an event; used to automate, visualize and monitor the processes.
Process Configuration
Easy and technically simplified configuration of complex business scenario
aspects. Process Configuration covers profile configuration, profile assignment,
and authorizations.
Process Foundation
Flexible framework to configure and run processes. It utilizes generic workflow
definitions, which are processed by the SAP Business Workflow engine.
Process options
Processing options for the user in the dashboard, such as Referral, Authorization,
and Actions
Process type
Process type for a document. The process type determines the initial actor and
various collaboration options available to the various actors during the process
flow.
Productivity Report
Part of the Central Reporting infrastructure. The Productivity Report reports
about the productivity of users/roles and the activities of users/roles.
PSA
Quantity variance
Situation where the quantity on the invoice is different from the quantity in the
purchase order
Roles
Set of predefined roles for the SAP user
Scan operator
Person who scans the invoices into images (may not have a SAP ID)
Summary Report
Part of the Central Reporting infrastructure. The Summary Report provides a
summary of all documents processed through OpenText VIM for SAP.
Technical catalog
SAP term: Repository for creating role-specific business catalogs
Transformation (TRF)
Object in SAP NetWeaver BW to connect source objects to data targets; it allows
to consolidate, cleanse and integrate data
TRF
VAN
Web Services
Underlying technical concept of the Fiori Task App interface. You configure the
complete content of the Fiori Task App either by customizing or by implementing
an interface for the Web Services.
Workflow
SAP Business Workflows can be used to define business processes that are not yet
mapped in the SAP S/4HANA system.