Free SAP C-TB1200-07 Exam Dumps Questions & Answers

Every day my employees run a query to check how many orders we have issued on that day and what their value was. I have created a simple query using the Orders table (ORDR): Document Number, Document Date, Document Total Where Document Date EQUAL 01/05/07 (for example). How can I create a "general" query so I do not have to go into this query statement every day to change the date in the "Where" condition area?

• A.Delete the condition from the query. Create a general query that will display all the orders created in the system to date. When the report displays, use the Sort Table to display the desired data.
• B.Define a variable in the "Group By" condition area of the formula: Document Date EQUAL '[%3]' then save the query.
• C.Define a variable in the "Where" condition area of the formula: Document Date EQUAL '[%0]' then save the query. Each time you run it, the system will prompt you to enter the desired date.
• D.Define a variable in the "Where" condition area of the formula: Document Date NOT EQUAL '[%0]' then save the query. Each time you run it, the system will prompt you to enter the desired date.

You want to include pictures of items when you print quotations. You have already stored the pictures in the item master data. How can you now print these pictures on the quotation?

• A.Insert a picture field in the repetitive area before the item number and select source type Formula. In the properties of this field, point to the 'Picture' field in the item master table.
• B.Insert a picture field in the repetitive area before the item number and select source type File. In the properties of this field, insert the path to the storage location of the pictures. You can find this path in the General Settings in the System Initialization.
• C.Copy and paste each bitmap into the repetitive area before each item number.
• D.Insert a picture field in the repetitive area before the item number and select source type Database. In the properties window, on the Content tab, Column field, choose 'Picture' from the list of the item master table fields.

When using the Payment Wizard with Check selected as the payment means, how is the check due date determined?

• A.In the Business Partner master data, you can choose how the check due date is set.
• B.When you run the Payment Wizard, you can set the due date of the check.
• C.In the Payment Method set up, you can choose how the check due date is set.
• D.When you run the Payment Wizard, you can choose how the check due date is set.

You have issued a Goods Receipt PO. You see that there is an orange link arrow to the left of the Journal Remark field. When you select the arrow, the Journal Entry window opens and displays a journal entry. Why was a journal entry created?

• A.A journal entry is only created when moving average cost is set for your items.
• B.This journal entry is created when a business partner is tax liable. When a document containing a tax sum is created, the system automatically creates a journal entry.
• C.The journal entry is created when the warehouse used to receive the goods is defined as a drop-ship warehouse.
• D.If you use perpetual inventory, every document that affects inventory creates a journal entry to reflect the inventory value in the general ledger.

Mary is conducting a month-end closing and needs to post accrued expenses. She needs to reverse the transaction next month when the actual expenses will be recorded. What is the best way to do this?

• A.Using a User-Defined Field in the journal entry header, Mary defines the reversal date and a link to a User Alert to serve as a reminder to the reversal.
• B.Select the Reverse check box on the journal entry and enter the date for reversing the transaction. Mary will receive a prompt on the reversal date and can post the reversal.
• C.In the journal entry, select the Adjustment Transaction check box. Then use the transaction report and use Cancel from the Data menu to reverse the transaction when needed.
• D.Assign a Transaction Code to each journal entry that requires reversal. The system will prompt Mary with the appropriate reversals at login.