on 06-10-2009 4:58 PM
Hello Gurus,
I know the payment document number. for this document number from which table can i get payment date and clearing date?
ANNWERED
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Go to Tcode: SE16 / SE16N
BSEG :
FI Document line item details stored in this table like posting key, GL account number, amount in local currency, amount in document currency, amount in 2nd & 3rd local currency, account assignment objects (cost center / internal order / WBS), short text, payment terms, discount details and etc.,
These line item entries updated if any changes made in the line items like change in the payment terms, payment block, payment method, short text and etc.,
Other than the above fields, some other fields also get updated like clearing details (clearing document number, clearing date).
BKPF :
FI Document header details stored in this table like document number, document date, posting date, entry date, reference, header text, exchange rate, document type, etc.,
This may update if any changes made in the document header like change in the header text / reference field.
Other than the above fields, some other fields also get updated like document change date, document reversal details (document number, date reversed)etc.,
SKS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Go to SE16
Table BSEG
You will find the details of clearing date.
For posting date refer BKPF table.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.