Int4 Suite Documentation

DB comparison rules generic templates

This section describes sample templates of IFTT Automation Objects along with appropriate settings and parameters (like variables, database comparison rules, and selection criteria) for the most common standard SAP objects and documents, such as:


Generic automation objects for database validation rules can be downloaded below. Here you can find a step-by-step guide on how to import them into your system.

Int4 IFTT Generic Automation Objects - DB Validation Templates.zip


Note that only basic properties of Automation Objects are defined in these templates. Therefore, depending on the type of interface in which the given object is used, other required parameters should also be defined appropriately (e.g., variable processing or additional parameters). To read more on how to create and configure it, refer to the Automation objects configuration section.


Sales Order

Int4 IFTT Automation Object:
GENERIC_SO

Description:
Generic Sales Order

Variables

image-20210408-155007.png


DB Comparison rule

image-20210408-155039.png


Selection Criteria for VBAK Table

image-20210408-155123.png


Selection Criteria for VBAP Table

image-20210408-155159.png


Selection Criteria for VBPA Table

image-20210408-155220.png


Section Criteria for VBKD Table

image-20210408-155318.png


VBAK & VBAP & VBPA & VBKD Tables Relationships

image-20210408-155753.png


Purchase Order

Int4 IFTT Automation Object:
GENERIC_PO

Description:
Generic Purchase Order

Variables

image-20200729-145237.png


DB Comparison rule

image-20200729-145255.png

Selection Criteria for EKKO Table

image-20200729-145346.png

Selection Criteria for EKPO Table

image-20200729-145426.png

Selection Criteria for EKET Table

image-20200729-145519.png

Section Criteria for EKKN Table

image-20200729-145601.png

EKKO & EKPO & EKET & EKKN Tables Relationships

image-20200729-150051.png


Inbound Delivery

Int4 IFTT Automation Object:

GENERIC_DELIVERY

Description:
Generic Delivery

Variables

image-20210409-101707.png

DB Comparison rule

image-20210409-101830.png


Selection Criteria for VBAK Table

image-20210409-102003.png


Selection Criteria for VBFA Table

image-20210409-102112.png


Selection Criteria for LIKP Table

image-20210409-102157.png


Section Criteria for LIPS Table

image-20210409-102203.png


VBAK & VBFA & LIKP & LIPS Tables Relationships

image-20210409-102700.png



Inbound Invoice

Int4 IFTT Automation Object:

GENERIC_INVOICE

Description:
Generic Invoice

Variables

image-20210408-162145.png

DB Comparison rule

image-20210408-162318.png

Selection Criteria for VBFA Table

image-20210408-162708.png


Selection Criteria for VBRK Table

image-20210408-162739.png


Selection Criteria for VBRP Table

image-20210408-162810.png


VBFA & VBRK & VBRP b Tables Relationships

image-20210408-162959.png



Inbound Purchase Invoice

Int4 IFTT Automation Object: GENERIC_PURCHASE_INVOICE

Description:
Generic Purchase Invoice (Inbound)

Variables

image-20200729-104611.png

DB Comparison rule

image-20200729-110505.png

Selection Criteria for RBKP Table

image-20200729-105243.png

Selection Criteria for RSEG Table

image-20200729-142415.png

RBKP & RSEG Tables Relationships

image-20200729-105819.png


Inbound MM Invoice

Int4 IFTT Automation Object: GENERIC_INVOICE_MM

Description:
Generic MM Invoice

Variables

image-20210408-160422.png


DB Comparison rule

image-20210408-160509.png


Selection Criteria for RBKP Table

image-20210408-160619.png


Selection Criteria for RSEG Table

image-20210408-160704.png


Selection Criteria for RBCO Table

image-20210408-160717.png


RBKP & RSEG & RBCO Tables Relationships

image-20210408-160840.png

Inbound Invoice (Multiple Invoice Scenario)

Int4 IFTT Automation Object:

GENERIC_MULTI_INVOICE

Description:
Generic Invoice- multi invoice scen.

Variables

image-20210408-162145.png

DB Comparison rule

image-20210409-103815.png


Selection Criteria for VBFA Table

image-20210408-162708.png


Selection Criteria for VBRK Table

image-20210408-162739.png


Selection Criteria for VBRP Table

image-20210408-162810.png


VBFA & VBRK & VBRP Tables Relationships

image-20210408-162959.png



Material Movement

Int4 IFTT Automation Object: GENERIC_MATERIAL_MOVEMENT

Description:
Generic Material Movement

Variables

image-20200729-150429.png

DB Comparison rule

image-20200729-150505.png

Selection Criteria for MKPF Table

image-20200729-150532.png

Selection Criteria for MSEG Table

image-20200729-150607.png

MKPF & MSEG Tables Relationships

image-20200729-150903.png


Accounting Document - Cross-system (for both SAP S/4HANA and older SAP systems)

Int4 IFTT Automation Object: GENERIC_ACC_DOC_CROSS

Description:
Generic accounting document cross-system (for new and old systems)

Variables

image-20200730-080058.png

DB Comparison rule

image-20200730-080120.png

Selection Criteria for BKPF Table

image-20200730-080156.png

Selection Criteria for BSEG Table

image-20200730-080233.png

Selection Criteria for BSET Table

image-20200730-081204.png

BKPF & BSEG & BSET Tables Relationships

image-20200730-080622.png


Accounting Document - without new ledger

Int4 IFTT Automation Object: GENERIC_ACC_DOC_OLD

Description:
Generic accounting document without new GL ledger

Variables

image-20200730-095641.png

DB Comparison rule

image-20200730-095707.png

Selection Criteria for BKPF Table

image-20200730-080156.png

Selection Criteria for BSEG Table

image-20200730-080233.png

Selection Criteria for FAGLFLEXA Table

image-20200730-095954.png

BKPF & BSEG & FAGLFELXA Tables Relationships

image-20200730-100328.png


Accounting Document - with a new ledger

Int4 IFTT Automation Object: GENERIC_ACC_DOC_NEW

Description:
Generic accounting document with new GL ledger

Variables

image-20200730-100741.png

DB Comparison rule

image-20200730-100830.png

Selection Criteria for BKPF Table

image-20200730-080156.png

Selection Criteria for BSEG Table

image-20200730-080233.png

Selection Criteria for ACDOCA Table

image-20200730-100950.png

BKPF & BSEG & ACDOCA Tables Relationships

image-20200731-072408.png


CRM Sales Order

Int4 IFTT Automation Object:

GENERIC_CRM_SO

Description:
Generic CRM sales order

Variables

image-20200730-101455.png

DB Comparison rule

image-20200730-101515.png

Selection Criteria for CRMD_ORDERADM_H Table

image-20200730-101818.png

Selection Criteria for CRMD_ORDERADM_I Table

image-20200730-101912.png

CRMD_ORDERADM_H & CRMD_ORDERADM_I Tables Relationships

image-20200730-101716.png