- How to create database table in SAP ABAP
- SAP Plant Table and SAP Company Code Table with usefull ABAP Tips
- SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
- A Guide to GST notes Implementation strategy
- SAP Tables affected by GST implementation for India
How to create database table in SAP ABAPBut if you have reference sales documents based on which you are trying to find invoice,then you can use document flow table VBFA with appropriate parameters to get the invoice numbers. Not what you're looking for? Search community questions. This question has been deleted. This question has been undeleted. Former Member. Posted on Dec 04, at AM Views. Hi, experts, what is the "invoice field name" in SD tables. ABAP Development. Add comment. Related questions. Sort by: Votes Newest Oldest. This answer has been deleted. This answer has been undeleted. Posted on Dec 04, at AM. Mark points if helpful. Alert Moderator. You already have an active moderator alert for this content. Regard,s Ravi Note - Please mark all the helpful answers. Hope this helps. Posted on Dec 04, at PM. Hi, you can find invno for invoice number. Please eloborate your question. Regards, Pankaj Singh. Hi Praveen, in SD the order,delivery or invoiceevrything has field name vbeln. VBFA will give you the complete flow of order, delivery and invoice e. Posted on Dec 05, at AM. Regards, Shehryar Dahar.
SAP Plant Table and SAP Company Code Table with usefull ABAP Tips
In this article, let us explore some interesting eWay Bill Setup and Configuration. The e-Way bill is an electronically generated document which is required for the movement of goods of value more than INRfrom one location to another. This document is generated online on the National Informatics Centre NIC portal for transportation of goods, both inter and intra-state and includes details such as the name of the consignor, consignee, point of origin of consignment, consignment destination, and route. E-way bill is an electronic document generated on the National Informatics Centre NIC portal evidencing movement of goods. This replaces the Way bill which was earlier required under the VAT regime. Note : All the required documents are attached below for reference. You can refer those to follow the best practices. ABAPers, if you are wondering, what is your duty. Check the below points. The eDocument Full solution requires the installation and integration of the following applications:. Note : Country-Specific installation Steps not available for other countries except India. The above steps and information might look like Greek for you if you have not started working on GST. Once you do some research, you would understand the flow. I struggled a lot while implementing this set up. Hope, this article would act as a guide to all consultants who would eventually need GST implemented in their ERP system. If you are stuck at any point, please feel free to reach out to me. Please register at SAPYard and start sharing your articles. Please join it using below link. You need to install the Telegram App first on your mobile device. Once you have it on your mobile, you can join the group and also access it from the Web on your computer and laptop.
SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
What really surprised me was the fact, that most of them are still using calculation views of a SQL Script type instead of Table Functions. What is more, some of them were even not aware that these type of views are deprecated and replaced by Table Functions. This inspired me to write the article about Table Functions and share my experience on that topic. Table functions are used whenever the graphical views are not sufficient i. Generally Table Functions should are used in case if the logic cannot be covered by graphical view or the logic is too complex to model it graphically. Additionally this function should display orders only for specific period of time which will be provided by the user. This is needed when you want to parametrize Table Function. This is needed when you transport the function between instances with different schemas i. If you provide the default schema in the definition of Table Function, then while transporting this schema will be automatically replaced with the schema of target system based on schema mapping. When applying default value for schema mapping, in the query you should use table names without schemas i. Preserve the columns order, column names case sensitive and their data types consistent with the select statement. Calling table Functions in SQL console is very easy. They are executed in the FROM clause. When executing the function, provide whole name of the function. In brackets provide values for input parameters. If there are no input parameters — leave the brackets empty they are always mandatory!!! Using Table Function as a source in Calculation View is also very simple. Create a new calculation view, and when adding object for the projection, type name of the Table Function:. If Table Function is using input parameters you need to recreate them also in the view. Now when previewing data on the view, there will be pop up with input parameters. Once values are inputted they will be passed directly to the table function and results will be displayed. The main limitation of table function is that you can pass only single values for each input parameter, which can be very annoying, because in most cases user wants to have possibility to pass multiple values in selection criteria of his report. There is a workaround for that limitation, which can help to fulfill requirement of passing multiple values directly to the query. I will describe it in the next post of my blog. Good to see this. Great article Konrad! So it can looks like this:. So if we want to pass Input Parameters as a placeholder and then use them in TF, it can looks like this:. Keep doing that, community needs people like you.
A Guide to GST notes Implementation strategy
GST is new tax system which has been effective in India, starting from 1 st July This blog will help technical members to understand challenges and best practices. Vipin Nagpal. Posted on February 14, 1 minute read. Follow RSS feed Like. This will help you while moving to Quality and Production environment. Manual notes: There are number of manual notes which need to be implemented. You need to have lot of patience with such OSS notes. Some of manual notes are quite lengthy, especially those OSS notes which were released by SAP support team in the beginning. This effort is also included trouble shooting which you may need to do when there is error while doing implementation of lengthy OSS notes. Access key while modify standard object: If you have authorization to generate access key while modify standard object, this is best situation. Otherwise, you always need to depends upon Basis Team. So Be ready to collaborate with Basis Team to get access keys. Find the root cause of this error and try to re implement same notes. Drop a mail to indiagst sap. Most of errors messages can be avoided if you will implement in correct sequence. Raise OSS message when there is error. Even after you are not able to resolve these error messages after implementing GST notes, then be ready to raise new OSS message. Convert Notes instruction pdf file to text file. You are implementing manual OSS notes and some time you need to copy of paste text. Example of that you are creating new message class with lot of messages. In such situation, convert notes instruction file to text file and copy message content from text file. Alert Moderator. Assigned tags. Related Blog Posts. Related Questions. Be the first to leave a comment. You must be Logged on to comment or reply to a post. Link Text. Open link in a new tab. No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.