04-02-2010 8:32 PM
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
04-03-2010 8:03 AM
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.
04-03-2010 6:08 AM
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
04-03-2010 8:03 AM
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.
04-03-2010 8:59 AM
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.
04-05-2010 6:43 AM
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
04-05-2010 4:13 PM
>
> 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
04-06-2010 7:12 AM
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
04-06-2010 7:15 AM
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
04-05-2010 8:22 AM
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
04-05-2010 10:51 AM
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.
04-05-2010 3:47 PM
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
04-09-2010 1:23 PM
Whenever a invoice is posted , account document is created and it can been seen in BSEG
cheers
S.Janagar