Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find Invoice Posted

Former Member
0 Kudos
3,092

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

1 ACCEPTED SOLUTION

nirajgadre
Active Contributor
0 Kudos
847

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.

11 REPLIES 11

Former Member
0 Kudos
847

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
Active Contributor
0 Kudos
848

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.

0 Kudos
847

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.

0 Kudos
847

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

0 Kudos
847

>

> 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

0 Kudos
847

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

0 Kudos
847

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
Active Contributor
0 Kudos
847

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
0 Kudos
847

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
Active Contributor
0 Kudos
847

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
Active Contributor
0 Kudos
847

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

cheers

S.Janagar