How to find Invoice Posted

[Former Member]

Hi experts,

I have limited knowledge in FI model.

I want to find the AP/AR posted invoice according to the Company code and posting date.

How should I use the referred table BSEG BKPF and VBRK ?

Is this data just coming from table BESG and BKPF, and no relationship with VBRK?

and AP from BSEG, AR from BKPF?

Thanks a lot.

Sincerely Julie

Edited by: julie 2192 on Apr 2, 2010 9:55 PM

[Former Member]

You can extract the rows from BKPF where "bukrs = <company_code> and budat = <given date> and blart in ('RV','KR').

Fetch the detail records from BSEG based on the records selected from BKPF.

Regards

Vinod

[nirajgadre]

Hi,

All the documents related to the AR/AP , will be available in the BKPF and BSEG table.

BKPF table contains the header details for the posted documents and line item details will will find the in the BSEG table.

put the company code , document type and posting date in the BKPF table. you will get the document number posted and put these document numbers in the BSEG table to get the line item details.

[Former Member]

Hi niraj,

I am very appreciate your kindly help, it really makes me clear about this problem.

But still 2 confused points:

1. for AP invoice in table BKPF, does it mean field

BKPF-BLART = 'RV'

?

for AR invoice in table BKPF, does it mean filed

BKPF-BLART = 'KR'

?

2. for all AP/AR invoice, has no relationship with table VBRK, right?

Thanks a lot.

Sincerely Julie.

[Former Member]

Hi julie,

BKPF-BLART = 'RV' means account receivable (Customer Invoice), if you are updating reference number in BKPF, then you will find the entry in VBRK,VBRP

BKPF-BLART = 'KR' mean account payable invoice (Vendor Invoice), if you are updating reference number in BKPF, then you will find the entry in RBKP & RSEG.

Regards

Vinod

[Former Member]

>

> Hi  julie,
> 
> BKPF-BLART = 'RV' means account receivable (Customer Invoice),  if you are updating reference number in BKPF, then you will find the entry in VBRK,VBRP
> 
> BKPF-BLART = 'KR' mean account payable invoice (Vendor Invoice), if you are updating reference number in BKPF, then you will find the entry in RBKP & RSEG.
> 
> Regards
> Vinod

Hi Vinod,

As you mentioned upside,

BKPF-BLART = 'RV' means account receivable (Customer Invoice), if you are updating reference number in BKPF, then you will find the entry in VBRK,VBRP.

But there is still a field value BKPF-BLART = 'DR'. (Customer Invoice) I want to know, is this kind of document type belongs to AP Invoice?

Thanks a lot.

Sincerely Julie

[Former Member]

Hi,

RV & KR are the basic document types used for AP/AR Invoices. You can check the other document types in table T003. There may be other Z Document types specific to your company. Take the help of Functional consultant to get the other document types related to AP/AR (like DR,DG for AR).

Regards

Vinod

[vallamuthu_madheswaran2]

Hi,

If your using BSEG & BKPF for AP/AP it'll make a performance issue use the following tables first goto SE11 and the the values.

AP closed/posted item --> use the table BSAK (ur requirement)

AP Open item --> BSIK

AR closed/posted item --> use the table BSAd (ur requirement)

AR Open item --> BSID

Thanks & Regards,

Vallamuthu.M

[former_member183990]

When ever a invoice is parked for approval it creates an entry in BKPF table and whenever it is posted , an entry is created in BSEG table

, This validation at runtime in FV60,MIRO can be done through BTE 2118

cheers

S.Janagar

[Former Member]

Hi,

The BKPF & BSEG tables are attached to SD or MM module with field --> BKPF-AWTYP, BKPF-AWKEY & BKPF-BLART.

Here you required ref. for VBRK.

So,

BKPF-AWTYP = 'VBRK' (fix value)

BKPF-AWKEY = Your invoice no. (from VBRK) like it_vbrk-vbeln

BKPF-BLART = 'RV' (for sales) *

NOTE: * 'RV' is for billing transfer . 'KR' is for Vendor invoice. Also search other z-doc. types (In T003 table) if it's there for your client. Sometimes if CS module is implemented Z- doc. types are used for it.

It may happen, you won't find the same value, but for sure you'll get the reference from this three fields only.

[vallamuthu_madheswaran2]

Hi,

AP closed/posted item --> use the table BSAK

AP Open item --> BSIK

AR closed/posted item --> use the table BSAd

AR Open item --> BSID

Thanks & Regards,

Vallamuthu.M

[former_member183990]

Whenever a invoice is posted , account document is created and it can been seen in BSEG

cheers

S.Janagar