Create a View in SAP - Database Views [english]

Sdílet
Vložit
  • čas přidán 6. 07. 2021
  • In this video I show you how to create a view in SAP.
    Application data is often spread across multiple tables and with views we can combine this data. The database tables accessed by views are called basis tables. If the view contains more than one basis table, the basis tables can be joined together.
    The structure of the view is created from the combined fields of the basis tables.
    A view does not store data. It is not created physically in the database.
    A view can be used for example in ABAP programs for the selection of data.
    #sap #create #view
    ▬▬ My Hardware ▬▬▬▬▬▬▬▬▬▬▬▬▬
    Microphone: amzn.to/3zj2UIz
    Headphone: amzn.to/3GUBRFg
    *The links are affiliate links. There are no additional costs.
    ▬▬ My Software (free) ▬▬▬▬▬▬▬▬▬▬▬
    Video Recorder: bit.ly/678fgh6
    Video Editor: bit.ly/38Rj9lb
    ▬▬ Further Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    Become my subscriber: bit.ly/CustAnd...
    All videos in English: bit.ly/CustAnd...
  • Věda a technologie

Komentáře • 10

  • @himanshusudra3675
    @himanshusudra3675 Před rokem

    Perfectly explained

    • @CustAndCode
      @CustAndCode  Před rokem

      Thank you very much for your feedback! 😀

  • @user-hu6yb5wq6i
    @user-hu6yb5wq6i Před rokem

    super clear thanks!

    • @CustAndCode
      @CustAndCode  Před rokem

      Thank you for your feedback! Glad to hear that! 🤗

  • @Chakravarthi.S
    @Chakravarthi.S Před 10 měsíci +1

    See i have doubt.... In ESTVA table combination of fields RECN and ACTN is the field OBJEK of AUSP table. So to get OBJEK we should CONCATENATE the RECN and ACTN. I know how to write in a program, But how can we do it in this se11 database view !!??

    • @CustAndCode
      @CustAndCode  Před 10 měsíci +1

      According to my information, this is unfortunately not possible in a database view. 🤔

  • @ngocthuong279
    @ngocthuong279 Před 2 lety

    Thanks sir

    • @CustAndCode
      @CustAndCode  Před 2 lety

      Thank you for your kind feedback! 😀

  • @gpsyking
    @gpsyking Před rokem

    Is it possible to see a source code for a created view?

    • @CustAndCode
      @CustAndCode  Před rokem +1

      If this is possible, I myself unfortunately do not know 🤔