Needs to change the infoset.

[Former Member]

Hi Gurus,

I have created a infoset using the below fields, but i need VBRK-VBELN (Billing document) should include all billing types( FKART) but exclude FKART = G2 ( Credit Memo)

Tables Used: VBRK and VBRP

VBRK-VBELN

VBRK-TAXK1

VBRK-ERDAT

VBRK-KUNAG

VBRP-NETWR

VBRP-MATNR

VBRP-ARKTX

VBRP-TAXM1

VBRP-MWSBP

And i have created an extra field (Custom Field) by name Credit Note Number and this credit note number field where i used the following logic

tables : VBFA.

clear : CR_NOTE.

Select single VBELN into CR_NOTE from VBFA where

VBELV = VBRP-VBELN and

POSNV = VBRP-POSNR and

VBTYP_N = 'O'.

here the output is only for credit notes which has corresponding billing document, but i need to include all VBRK-FKART = 'G2' (Credit Memo) documents.

-

---

My Request is

1. Needs to exclude all credit notes from billing documents ( VBRK-VBELN)

2. Needs to include all credit notes into Credit note number field

Credit note information is in VBRK-FKART = 'G2'

I will assign good points.

Thanks for your help

Prashanth

[Former Member]

answered