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:

1 Sales Order
2 Purchase Order
3 Inbound Delivery
4 Inbound Invoice
5 Inbound Purchase Invoice
6 Inbound MM Invoice
7 Inbound Invoice (Multiple Invoice Scenario)
8 Material Movement
9 Accounting Document - Cross-system (for both SAP S/4HANA and older SAP systems)
10 Accounting Document - without new ledger
11 Accounting Document - with a new ledger
12 CRM Sales Order

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.

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	DB Comparison rule
Selection Criteria for VBAK Table	Selection Criteria for VBAP Table
Selection Criteria for VBPA Table	Section Criteria for VBKD Table
VBAK & VBAP & VBPA & VBKD Tables Relationships

Purchase Order

Int4 IFTT Automation Object: GENERIC_PO	Description: Generic Purchase Order
Variables	DB Comparison rule
Selection Criteria for EKKO Table	Selection Criteria for EKPO Table
Selection Criteria for EKET Table	Section Criteria for EKKN Table
EKKO & EKPO & EKET & EKKN Tables Relationships

Inbound Delivery

Int4 IFTT Automation Object: GENERIC_DELIVERY	Description: Generic Delivery
Variables	DB Comparison rule
Selection Criteria for VBAK Table	Selection Criteria for VBFA Table
Selection Criteria for LIKP Table	Section Criteria for LIPS Table
VBAK & VBFA & LIKP & LIPS Tables Relationships

Inbound Invoice

Int4 IFTT Automation Object: GENERIC_INVOICE		Description: Generic Invoice
Variables		DB Comparison rule
Selection Criteria for VBFA Table	Selection Criteria for VBRK Table		Selection Criteria for VBRP Table
VBFA & VBRK & VBRP b Tables Relationships

Inbound Purchase Invoice

Int4 IFTT Automation Object: GENERIC_PURCHASE_INVOICE	Description: Generic Purchase Invoice (Inbound)
Variables	DB Comparison rule
Selection Criteria for RBKP Table	Selection Criteria for RSEG Table
RBKP & RSEG Tables Relationships

Inbound MM Invoice

Int4 IFTT Automation Object: GENERIC_INVOICE_MM		Description: Generic MM Invoice
Variables		DB Comparison rule
Selection Criteria for RBKP Table	Selection Criteria for RSEG Table		Selection Criteria for RBCO Table
RBKP & RSEG & RBCO Tables Relationships

Inbound Invoice (Multiple Invoice Scenario)

Int4 IFTT Automation Object: GENERIC_MULTI_INVOICE		Description: Generic Invoice- multi invoice scen.
Variables		DB Comparison rule
Selection Criteria for VBFA Table	Selection Criteria for VBRK Table		Selection Criteria for VBRP Table
VBFA & VBRK & VBRP Tables Relationships

Material Movement

Int4 IFTT Automation Object: GENERIC_MATERIAL_MOVEMENT	Description: Generic Material Movement
Variables	DB Comparison rule
Selection Criteria for MKPF Table	Selection Criteria for MSEG Table
MKPF & MSEG Tables Relationships

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		DB Comparison rule
Selection Criteria for BKPF Table	Selection Criteria for BSEG Table		Selection Criteria for BSET Table
BKPF & BSEG & BSET Tables Relationships

Accounting Document - without new ledger

Int4 IFTT Automation Object: GENERIC_ACC_DOC_OLD		Description: Generic accounting document without new GL ledger
Variables		DB Comparison rule
Selection Criteria for BKPF Table	Selection Criteria for BSEG Table		Selection Criteria for FAGLFLEXA Table
BKPF & BSEG & FAGLFELXA Tables Relationships

Accounting Document - with a new ledger

Int4 IFTT Automation Object: GENERIC_ACC_DOC_NEW		Description: Generic accounting document with new GL ledger
Variables		DB Comparison rule
Selection Criteria for BKPF Table	Selection Criteria for BSEG Table		Selection Criteria for ACDOCA Table
BKPF & BSEG & ACDOCA Tables Relationships

CRM Sales Order

Int4 IFTT Automation Object: GENERIC_CRM_SO	Description: Generic CRM sales order
Variables	DB Comparison rule
Selection Criteria for CRMD_ORDERADM_H Table	Selection Criteria for CRMD_ORDERADM_I Table
CRMD_ORDERADM_H & CRMD_ORDERADM_I Tables Relationships