How can i create database view for this tables ?

[shubham_annadate96]

This is car production company

I required critical view of this scenarios :

● How many, which cars in which store were bought?

○ Fields to display:

○ Store Name

○ Customer Name

○ Order ID

○ ICPN

○ Quantity

○ Payment

○ Currency

○ Ordered At

This are database table fields which i have created : (Architecture)

http://prntscr.com/g4zoa3

I am new learner fresher in this field and your suggestions are valuable for me

[bertrand_delvallee]

Hello,

I'm sorry to inform you that you are not in the right place to ask for this kind of help. You should google for ABAP/developer forum for beginners. You need several weeks of professional formation or a real tutor beside you to learn that things. You can't achieve that here, you just missed a step.

By the way, as an ABAPer your job is to create only what doesn't already exist in your machine. SAP is not a MySQL server for little applications. As a beginner you are not suppose to create an architecture like this : you should received instructions by a senior consultant knowing standard objects, client process and customizing (s)he's about to perform. It's the person knowing all that who will say to you what are specific tables or fields missing for the project (and it's your job to create them, following specifications and needs). Without that knowledge you will quickly create horrible things in your machine and will not be able to maintain it more than 2 years.