The document currency is determined in the document header and is identical for all items of the document. The local currency is defined for a company code and identical in every line of every document of the company code. Why we need update currency in each line item? But In some situation, we only want to keep balance in specific currency, for example, local currency.
That is the reason we need update currency in each line item to identify which amount and currency is updated in balance table. SAP Note : Update currency in line items. ERP Financials. Browse pages. A t tachments 0 Page History. Jira links. Created by Yan Zhao on May 23, Exception: The document was created in the course of a clearing. For an account with open item management as well as all sub-ledger accounts, the balance must always correspond to the total from the open items. If you then clear a document with document currency DEM with a document in USD, then a balance of zero must also result with respect to update currency.
For this reason, the system updates the clearing document with the update currency of the source document, or the clearing document contains additional lines in order to bring the balance in every update currency to zero.
Usually you will meet below behavior and they are caused by update currency: While clearing, the system generates unanticipated additional lines Line item display FBL3Nfor a selection with currency CUR, the system displays documents which document currency is not CUR. Balance display FS10N, when you select a certain currency, for example, EUR, and drill-down for the items, then the system displays documents with currency different from EUR.
No labels. Powered by Atlassian Confluence 7.If you have an answer for this question, then please use the Your Answer form at the bottom of the page instead. BSID is the secondary index table for customer realated transactions. If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead. Before you do this have a look to the OSS note about this, there are some riscks about this.
Attachments: Up to 10 attachments including images can be used with a maximum of 1. Search the SAP Community. This question has been deleted. This question has been undeleted. Former Member. Posted on Aug 30, at AM Regards, Raghunath.
SAP Table BSEG
Add a comment. Comment on This Question Help to improve this question by adding a comment. Related questions. Sort by: Votes Newest Oldest. This answer has been deleted. This answer has been undeleted. Posted on Aug 30, at AM.
Regards Venkat. Help to improve this answer by adding a comment. Alert Moderator. You already have an active moderator alert for this content. Comment on This Answer Help to improve this answer by adding a comment. Arvind Pereira.
In SQL, it would look something like this:. Learn more. Asked 6 years ago. Active 6 years ago. Viewed 3k times. Depending on the quantity of data it could take you a lot of time. Check if the date field you'll use is index. By the way, using the IN statement is a performance killer. Re IN statement, what do you then suggest?
The statement "using the IN statement is a performance killer" without any further knowledge of the actual situation is just wrong.
As for the original question - have you checked whether there are any standard reports that you could use? Extracting data is a complex task if you're interested in consistent results - you have to know a lot about cancellation flags, posting types and whatnot. Are you sure you want to re-invent this particular wheel? Active Oldest Votes.
If you have an answer for this question, then please use the Your Answer form at the bottom of the page instead. If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead. There are different options available in selection screen to restrict the selection of documents.
Check if this meets your requirement. You cannot use QuickView for the purpose as you described in your posting. You can build an infoset query though:. Attachments: Up to 10 attachments including images can be used with a maximum of 1.
Search the SAP Community. This question has been deleted. This question has been undeleted. Former Member. Posted on Nov 20, at AM 1. Regards Zunaid. Add a comment. Comment on This Question Help to improve this question by adding a comment. Related questions. Sort by: Votes Newest Oldest. This answer has been deleted. This answer has been undeleted.
Posted on Nov 20, at AM.
Help to improve this answer by adding a comment. Alert Moderator.SAP + SQVI + VBFA doc flow
You already have an active moderator alert for this content.I have two quick comments on this. First, this is only true for those modules currently in scope. BKPF is still part of the table architecture. BKPF still contains the basics such as the document type, document date, posting date, etc. With Acdoca table accomodating all the fields, relevance of SPL may slightly pushed back, what are your view on this?
There is a correction. BSEG will continue to be used in Simple finance to manage open items. BSEG for the time being will not change. You must make use of summarization for more than lines.
There are to my knowledge no plans to change this logic anytime soon. Just wanted to update this blog. I highly suggest exploring this t-code and the others. Nathan Genez. Posted on October 7, Less than a 1 minute read. Follow RSS feed Like. Alert Moderator. Assigned tags.
Relationship between BKPF and CE1xxxx tables
Related Blog Posts. Related Questions. You must be Logged on to comment or reply to a post. Former Member. October 7, at pm. Thanks Nathan. Like 0. October 12, at am.
Ramky Prabhakar. October 27, at pm. Thanks Prabhakar. Hi Nathan, Thanks to clarify. Thanks JPA.
Nathan Genez Post author. October 29, at pm. I imagined. Malolan R. November 11, at pm. Nathan There is a correction. December 16, at am.Once validations are done, one can substitute the entered value with some other value. This gives you the opportunity of having the system validate values that are to be substituted. A substitution value can be numeric or a string. The system first performs some validations and then substitutions.
So for creating custom user exits, one has to copy this include to a 'Z' Custom namespace program. The length of the name you choose should not exceed 8 characters. One has to specify a parameter type to enable the code generation program to determine correctly how to generate the user exit call ,i.
The following parameter types exist:. If you do not want to substitute a field, use this parameter in the substitution. Exactly one field is substituted. You need to be cautious when writing code for your user exit. No dialog boxes, warning messages, information or error messages must be issued in an exit.
As a result, the system writes, deletes or changes database records if you use the commands mentioned above. This can cause serious inconsistencies and problems in the document processing.
Now you can use this user exit for substitutions. Go to transaction GGB1. Also you can see the list of all the user exit on pressing F4 on the highlighted area in red.
Did you try it exactly this way? You should check your belnr has left padding '0' you can check it with double click on the record in SE16n tcode. Actually, you can directly link these table. Last option, If these are still not working for you, then you can link: However, it will kill the performance, I believe.
Learn more. Ask Question. Asked 2 years, 4 months ago. Active 2 years, 4 months ago. Viewed 5k times. I already browse the web but i find no answer that can solve my problem. Need some help! Dumbest Dumbest 47 1 1 silver badge 11 11 bronze badges. May 17 '18 at But do you have any idea on how the simulate button display all the data in the table control, or at least the flow? Is it possible to replicate the flow and get all the records same with data diplayed on simulate?
It's quite trivial. My mistake. I'll edit it. Active Oldest Votes. Oguz Oguz 1, 1 1 gold badge 13 13 silver badges 22 22 bronze badges. I' tried them all, same step as you said, but bseg always return with no values found.