They are used for file handling in SAP.
What are variables? Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are entered into the workbooks. Mention what are the different types of variables? It is expensive Demands highly trained staff Lengthy implementation time Interfaces are a little bit complex Does not determine where master data resides Mention where are t-code name and program values stored?
Explain how can you find a list of all t-codes in the SAP system? To view transaction table TSTC you can use transaction code st11, and you can define a new t-code using transaction se OLAP : OLAP stands for Online Analytical Processing it is a reporting tool configured to understand your database schema, dimensions and composition facts Data Mining : It is an analytic process to explore data in search of consistent patterns or systematic relationship between variables. Mention what are the three stages of data-mining?
To create a table in the data dictionary, you have to follow this steps Creating domains data type, field length, range Creating data elements Properties and type for a table field Creating tables SE 11 Mention what is AWB? AWB stands for Administrator Workbench. It is a tool for monitoring, controlling and maintaining all the processes connected with data staging and processing in the business information warehousing. Explain what is Bex? Bex means Business Explorer. It allows end user to locate reports, analyze information, view reports and can execute queries.
The queries in workbook can be saved to their respective roles in the Bex browser.
It has following components Bex analyzer, Bex Map and Bex web. An ODS object serves to store debugged and consolidated transaction data on a document level. It defines a consolidated dataset from one or more info-sources. This data-set can be evaluated with a Bex query or Infoset query.
In contrast to multi-dimensional data storage with InfoCubes, the data in ODS object is stored in transparent, flat database tables. Mention what is the difference between Domain and Data Element? Data Element : It is an intermediate object between domain and table type Domain : It defines the attributes such as length, type, and possible value range Mention what are SET parameters and GET parameters?
To use parameter IDs, you need to "set" values in the global memory area and then "get" values from this parameter ID memory area. In the case of the online program, you have to "Set" values from screen fields, and you will "get" these values for screen fields. LUW is a span of time during which database records are updated either commit or rollback. Mention what is BDC stand for? How many methods of BDC are there?
The baseline date is the date from which the payment terms apply. Usually, it is the document date on the invoice but can also be the date of entry or posting date from the ledger.
Where best-of-breed WMS meets the ERP
Mention what do you mean by one-time vendors? In certain industries, it is not possible to create new master records for every vendor trading partner. One-time vendor enables for a dummy vendor code to be used on invoice entry and the information that is normally stored in the vendor master, is keyed on the invoice itself.
Proposal Scheduling : The system proposes list of invoices to be paid Payment booking: Booking of the actual payments into the ledger Printing of Payment forms: Printing of payment forms Mention what is the difference between the "residual payment" and "partial payment" methods of allocating cash in account receivable?
Mention what are internal tables, check tables, value tables, and transparent table? It is the standard data type object; it exists only during the runtime of the program. Using the message server, the application servers communicate with presentation components, the database and also with each other. All the data are stored in a centralized server, which is known as a database server. Explain what is a company in SAP?
Company in SAP is the highest organizational unit for which financial statements like profit and loss statements, balance sheets can be drawn according to the requirement of organizations. A single company contains one or many company codes.
While SAP basis is, the administration module of SAP used to control code changes, upgrades, database admin, network setup, etc. List out the different types of the source system in SAP? In the SAP source system, extractors is a data retrieval mechanism. It can fill the extract structure of a data source with the data from the SAP source system datasets. Explain what is extended star schema? The star schema consists of the fact tables and the dimension tables. The master data related tables are kept in separate tables, which has reference to the characteristics in the dimension tables.
These separate tables for master data are termed as the Extended Star Schema. Explain what should be the approach for writing a BDC program? The approach to writing BDC program is to Create recording Convert the legacy system data to a flat file into the internal table referred as "Conversion.
Mention the two types of services that are used to deal with communication? Copy sessions are available in the WOC module. Various trip details, which are created and maintained in the Transport Order Planning TOP module, can be added to specific transport document types. Consequently, there is no direct relationship between the TOD and CDE modules, yet, they are closely dependent on each other. A link to BAAN IV Distribution can be established, so that the order line status of the corresponding distribution order is updated automatically after international or Dutch bills of lading have been printed.
Specific sessions can be defined as an order step for a sales order, purchase order, or replenishment order type. Before using the Transport Order Documents module, certain master data must be set up. This involves defining the transport or warehouse order for which the freight documents are to be printed.
You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email.
Notify me of new posts via email. The Transport Order Documents module in perspective This chapter describes the main functions and objectives of the Transport Order Documents module. Figure The modules related to the TOD module Transport documents are printed based on either a transport order or specific order lines thereof or a public warehouse order or specific order lines thereof.
Master data and prerequisites Before using the Transport Order Documents module, certain master data must be set up. Like this: Like Loading