Is it possible to create a report that contains data regarding the value of the payment receipts (irrespective of the receipt methods) structured on: currency, time period, business partner group, business partner, sales region?
A: You can locally customise the Payment window, and, then, you can bring to the table 2 more virtual columns: "Business Partner Group" and "Sales Region" (assuming that the sales region is not modified on the issued invoices). This way, you can filter the payments and receipts directly from this window and use the corresponding list report (obviously, you need to add the two columns to this as well). Log into the database with the System user and do the following:
In the Table and Column window, on the C_Payment table, add two new columns: C_BP_Group_ID and C_SalesRegion_ID. The element names and the system elements need to be identical to these. Choose them by the system element and the system will automatically bring the rest of the information when saving the record.
Make sure you have selected User Maintained in the Entity Type field and Table Direct in the Reference field.
In the Column SQL field, in the Column tab you need to enter the following data:
for C_BP_Group_ID: (SELECT C_BP_Group_ID FROM C_BPartner WHERE C_BPartner.C_BPartner_ID=C_Payment.C_BPartner_ID)
and for C_SalesRegion_ID: (SELECT MAX(C_SalesRegion_ID) FROM C_BPartner_Location WHERE C_BPartner_Location.C_BPartner_ID=C_Payment.C_BPartner_ID)
use the Synchronise Columns button for each of them (the ** {IsVirtualColumn} message needs to be displayed);
Go to the Window, Tab & Field window, select the Payment record, the Payment tab, the Business Partner field:
Use the Copy button to add another field for the Business Partner Group, linked to the new column C_BP_Group_ID_Business Partner Group (use Refresh if you cannot see this). Still "User Maintained" and "ReadOnly" with the next sequence after the Business Partner. Save.
Repeat the steps to add the Sales Region field linked to the C_SalesRegion_ID_Sales Region column. Assign this the next sequence and you may also select the Next Row checkbox to make it be displayed in the group (depending on the other existing customisations). Save.
Use the Cache Reset Client + Server process in the Tools menu and log out. Verify that the two new fields have appeared in the Payment window and have been filled in.
How can I view a schema with a detailed structure of the database and the tables inside the database, together with their links to one another?
A: There is no document containing the structure of the database. The metadata can be read directly from the context or from the application dictionary (the structure of the database is documented in the Application Dictionary). If necessary you can use a documentation tool for the Database (to model the database) that knows how to connect to the Oracle base and extract (read) the structure of the database.