Ansicht
Dokumentation

CNV_MBT_GENWHERE_CLAUSE_46 - Where Clause for the Conversion Object

General Material Data   General Data in Customer Master  
This documentation is copyright by SAP AG.

Title

Program to generate the where clause for a package and migration object specified by the user.

Purpose

Migration objects are reduced using condition maintained in the form of Selection Group. The selection group information is maintained in a set of tables CNVMBTSELGRP, CNVMBTSELGRPDEF, CNVMBTSELCLAUSE, CNVMBTSELVAR, CNVMBTSELGRPVAL and CNVMBTSELREF. All this information is used to construct the where clause which is used to reduce the migration object.

The user might like to know before the actual run whether the information stored in these tables which he has maintained is consistent. The best way to check this is to have a look at the where clause which would be used.

This program constructs the where clause and displays the same to the user.

Integration

This program can be run independently giving the package and migration object information. This program is also intergrated with the selection group definition program.

Prerequisites

The package and the migration object information have to be maintained. The where clause is generated using the information maintained in the Selection Group tables which are specified above. However, if this information is not consistent - appropriate message is displayed to the user.

Features

Selection

Package and Migration Object

Standard Variants

N/A

Output

Where Clause used for reduction

Activities

N/A

Example

INPUT,,:

,,Package ,,,,: TDTIM

,,Migration ,,,,: X_AUAK

OUTPUT,,:

SELECT * FROM AUAK INTO TABLE S_AUAK

WHERE BLDAT GE ' LV_DUM '.

TXBHW - Original Tax Base Amount in Local Currency   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1942 Date: 20240531 Time: 020039     sap01-206 ( 26 ms )