How to identify an invoice/credit memo/ subs credit / subs debit in tables

[Former Member]

Dear Experts ,

From what tables/fields can i know if a particular invoice document is an invoice or credit memo or subs credit or subs debit ?

Regards

Anis

[Former Member]

If Invoice

RBKP-XRECH - X

RSEG u2013TBTKZ - blank

If Credit Memo

RBKP-XRECH - blank

RSEG u2013TBTKZ - blank

If Subsequent Debit

RBKP-XRECH - X

RSEG u2013TBTKZ - X

If Subsequent Credit

RBKP-XRECH - Blank

RSEG u2013TBTKZ u2013 X.

Hope it will help them, who have similar doubt.

[Former Member]

Hi

Run MIR6 report . In this check colum Invoice ,

Indicator: post invoice

Specifies whether the document is an invoice or a credit memo.

Use

Invoice: This field is selected

Credit memo: This field is not selected

[Former Member]

Hello ,

In BKPF - BLART - all the documents are RE .

[rafael_zaragatzky]

Hi Anis,

PO history is stored in the table EKBE (EKBZ for planned delivery costs). In this table you have the field BEWTP which actualy defines the letters you have in the leftmost column in the PO history. Here are some codes you might be interested in:

Q IR-L Invoice receipt

N SD-L Subs. deb. log. IV

To distinuish between debit and credit you will have to check the field SHKZG in the same table (S = debit, H = credit).

BR

Raf

[Former Member]

MIR 6 report

[kunal_ingale]

hi

.

Edited by: SAP Learner on Feb 9, 2010 11:27 AM

[Former Member]

Hi,

Table BKPF,Field BLART

Regards

R.S.Nambi