on 01-15-2010 8:59 AM
Hi,
I have invoice number and can you please confirm weather invoice created date is same as invoice posting date? if not what is the exact field.
Regards,
suma.
Hello
RBKP-BUDAT - posting date
RBKP-CPUDT - creating date
Values may be different.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you all .It is solved by fetching from another table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Suma,
Check the Table RBKP with fields BLDAT document date, BUDAT posting date.
Thanks and Regards,
Thirukumaran. R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There is no corresponding xblnr record in BSAD table.But value is there in xblnr in VBRK table.
Thanks,
suma.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you please provide the link between vbrk-vbeln to invoice posting date.
Thanks,
suma.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In VBRK table you can see field BELNR-Accounting Document Number and same field you can find in BSAD table also,
with this tables try to fetch the data. Orelse one step more forword you can also see the field XBLNR-Reference Document Number which is present in both VBRK and BSAD. And BUDAT-Posting Date in the Document is present in BSAD table.
Hope the above links will help you.
Cheers!!
VEnk@
May be this statement can help you:-
SELECT bukrs lifnr augdt augbl zuonr belnr waers xblnr blart wrbtr sgtxt zlsch
FROM bsak INTO CORRESPONDING FIELDS OF TABLE it_bsak
WHERE blart IN s_blart AN
budat IN s_budat AND
AUGDT IN s_budat AND
bukrs IN s_bukrs AND
lifnr IN s_lifnr AND "it_ekko-lifnr or lifnr = s_lifnr ) and
xblnr IN s_xblnr .
Hi,
ERDAT - it is a Date on Which Record Was Created.
But there is no any positng date in invoice but there is FKDAT - Billing date for billing index and printout.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Table :RBKP.
Field:
BLDAT: document date.
BUDAT: posting date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.