Ansicht
Dokumentation

ABENMESH_DELETE_TABLE_ABEXA - MESH DELETE TABLE ABEXA

ROGBILLS - Synchronize billing plans   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

- Deleting Single Lines in Mesh Paths

This example demonstrates how single lines are deleted in mesh paths.

Source Code

Execute

Description

Starting from the prefilled mesh nodes mesh-node1 and mesh-node2, single lines from mesh-node2 are deleted:

• Statement DELETE TABLE for deleting a line using the ON condition.

DELETE TABLE mesh-node1\_node2[ mesh-node1[ 1 ] ].

The line of node mesh-node2, identified starting with the first line of node mesh-node1 using the initial mesh association \_node2, is deleted. The ON condition covers the primary key used here, which means that no additional key fields need to be specified.

• Statement DELETE TABLE for deleting a line using the ON condition and with an explicitly specified key field.

DELETE TABLE mesh-node1\_node2[ mesh-node1[ 2 ] ]
  WITH TABLE KEY mkey COMPONENTS col3 = 23.

The line of node mesh-node2, identified starting with the second line of node mesh-node1 using the initial mesh association \_node2, is deleted. The ON condition does not cover the secondary key mkey, which means that the missing key field must be specified using the addition WITH TABLE KEY.

• Statement DELETE TABLE for deleting a line using the ON condition and with a key field from the work area.

DELETE TABLE mesh-node1\_node2[ mesh-node1[ 3 ] ]
  FROM VALUE line2( col3 = 33  ) USING KEY mkey.

The line of node mesh-node2, identified starting with the third line of node mesh-node1 using the initial mesh association \_node2, is deleted. The ON condition does not cover the secondary key mkey, which means that the missing key field must be specified using the addition FROM wa.

RFUMSV00 - Advance Return for Tax on Sales/Purchases   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2250 Date: 20240426 Time: 104957     sap01-206 ( 35 ms )