sap abap syntax join

-
*&---------------------------------------------------------------------*
*& Report ZABAP_SYNTAX_JOINS
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ZABAP_SYNTAX_JOINS.


types : begin of tp_mara,
         matnr type mara-matnr,
         mtart type mara-mtart,
         maktx type makt-maktx,
         werks type marc-werks,
        end of tp_mara.

data : gt_mara type table of tp_mara,
       gs_mara type tp_mara.

data : gv_matnr type mara-matnr,
       gv_werks type marc-werks.


select-OPTIONS : s_matnr for gv_matnr,
                 s_werks for gv_werks.



START-OF-SELECTION.

    select a~matnr, a~mtart,
           b~maktx,
           c~werks
           from mara as a INNER join makt as b
           on a~matnr = b~matnr
           inner join marc as c
           on a~matnr = c~matnr
           into TABLE @gt_mara
           WHERE a~matnr in @s_matnr
             and b~spras = @sy-langu
             and c~werks in @s_werks.


     loop at gt_mara into gs_mara.

     write :/5 gs_mara-matnr, 25 gs_mara-mtart, 40 gs_mara-maktx, 75 gs_mara-werks.

     clear : gs_mara.
     endloop.


*   select a~matnr, a~mtart,
*          b~werks
*          from mara as a left OUTER join marc as b
*          on a~matnr = b~matnr
*          into TABLE @gt_mara
*          WHERE a~matnr in @s_matnr
*            and b~werks in @s_werks.

*     cl_demo_output=>display( gt_mara ).





end-of-SELECTION.

Comments

Post a Comment

Popular posts from this blog

ES practical syit sem 4

-
Image
👉 ITSUDENT practical 1(a):- ES Practical 1 (A) Introduction to Arduino circuit (1b)Aim:-write program to enable switching effect in LED using Arduino. here is the code:- int animationSpeed=0; void setup() { pinMode(8,OUTPUT); } void loop() { animationSpeed=400; digitalWrite(8,HIGH); delay(animationSpeed); digitalWrite(8,LOW); delay(animationSpeed); } practical 2:- Aim:- Write a program to interface Light Sensitive Resistor  with Arduino:- here is code:- int ldr=A3; int bulb=7; void setup() { pinMode(bulb,OUTPUT); pinMode(ldr,INPUT); } void loop() { if(analogRead(ldr)>500) digitalWrite(bulb,0); else digitalWrite(bulb,1); } practical 3 :- Aim:-WRITE A PROGRAM TO INTERFACE TEMPRATURE SENSOR WITH ARDUINO. TABLE:- circuit diagram:- input:- here is the code:- click:-ctrl+A int baselineTemp=0; int celsius=0; int fahrenheit=0; void setup() { pinMode(A0,INPUT); Serial.begin(9600); pinMode(2,OUTPUT); pinMode(3,OUTPUT); pinMode(4,OUTPUT); } void loop() {...
Read more

Java programming practical

-
practical (1) Aim:-Write a program to create a class and implement a default, overloaded any copy constructor here is code:- import java.util.*; class Student{ int roll; String name; public Student(){ roll=101; name="Archana"; } public Student(int r,String n){ roll =r; name=n; } public Student(Student s){ roll=s.roll; name=s.name; } void display(){ System.out.println("Roll No="+roll+"\tName="+name); } } class ConstructorDemo{ public static void main(String args[]){ Student s1=new Student(); s1.display(); Student s2=new Student(111,"Charvi"); s2.display(); Student s3= new Student(s1); s3.display(); } } practical 1(B) Aim:-write a program to create a class and implement the concepts of method overloading here is the code:- class MethodOverload{ public int sum(int x,int y){ return (x+y); } public int sum(int x,int y,int z){ return (x+y+z); } public double sum(double x,double y){ return (x+y...
Read more

Master Linux Practical for B.Sc. IT Semester 5: Download pdf and the Comprehensive Guide

-
Are you pursuing B.Sc. IT and gearing up for your 5th semester Linux practicals? If so, you're in the right place! We understand how crucial practicals are in the curriculum, and that's why we have prepared a detailed PDF covering all the key commands and procedures you'll need. Whether you're a beginner or looking to brush up on your Linux skills, this PDF offers clear, easy-to-follow instructions that make mastering Linux practicals a breeze. DOWNLOAD PDF micro pdf print LSA PDF OPEN Why This PDF is a Must-Have for B.Sc. IT Students Linux is an integral part of the B.Sc. IT syllabus, and doing well in your practical exams requires a solid understanding of command-line operations. But let's be honest—sometimes the official material can be overwhelming or unclear. That’s where this PDF comes in. It’s designed with students in mind, breaking down complex commands into simple, step-by-step instructions. From basic file management to advanced networking commands, this ...
Read more

Introduction to computer system

-
Image
ITschoolsuraj   GQ.write note on computer system  Ans :  Computer System Computer is an electronic device that can be instructed to carry our sequences of arithmetic or logical operations . automatically via computer programming Modern computers have the ability to follow generalized sets of operations, called programs. These programs enable computers to perform an extremely wide range of tasks.  Computers are used as control systems for a wide variety of industrial and consumer devices.   Early computers were only conceived as calculating devices.  Since ancient times, simple manual devices like the abacus helps people in doing calculations.  Early in the Industrial Revolution, some mechanical devices were built to automate long tedious tasks, such as guiding patterns for looms.  More sophisticated electrical machines did specialized analog calculations in the early 20th century.  The first digital electronic calculating machines were d...
Read more

Advanced Web Designing (AWD) Practical Guide for B.Sc. IT 5th Semester

-
Welcome to the Advanced Web Designing (AWD) Practical Guide for B.Sc. IT 5th Semester. This blog aims to provide you with a detailed, step-by-step walkthrough on how to successfully complete the AWD practicals. The guide will help you write and run programs, and you can always refer to the attached PDF for more in-depth examples and resources. If you're new to web development or looking to refresh your knowledge, this guide will be invaluable as you tackle your practicals. You can access the official PDF containing all practicals, instructions, and examples through the link below: Open AWD Practical PDF 2 pdf awd Website copy button Ctrl+U Cookies:- <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="bot.aspx.cs" Inherits="Bootstrap.bot" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <script type="text/javascrip...
Read more

CGA practical

-
Practical :02 Aim:-study and enlist the basic function used for Graphics in C/C++/Python language .give an example for each of them:- ALL WRITTEN FILE PRACTICAL CGA FILE #include<stdio.h> #include<conio.h> #include<graphics.h> void main() { int gd= DETECT,gm,points[]={320,150,420,300,250,300,320,150}; initgraph(&gd,&gm,"c:\\tc\\bgi"); line(50,50,90,50); arc(100,100,210,330,50); circle(70,250,50); drawpoly(4,points); setcolor(RED); circle(50,420,40); floodfill(50,420,RED); setcolor(WHITE); outtext("press any key to clear the screen.."); getch(); cleardevice(); outtext("press any key to exit.."); getch(); closegraph(); } ------------------[practical 3]------------------------ Aim:-Draw a co-ordinate axis at the center of the screen #include<iostream.h> #include<math.h> #include<conio.h> #include<graphics.h> void main() { int gd,gm; int x0,y0,xmax,ymax; clrscr(); detectgraph(&gd,&gm); initgraph(&gd...
Read more

Mastering Advanced Java Practical(AJT): A Step-by-Step Guide

-
Welcome to this comprehensive guide on Advanced Java (AJT) Practical ! If you’re a student or developer working on your Java skills, you’ve come to the right place. In this blog, I’ll walk you through the practical aspects of Advanced Java, covering key concepts and hands-on steps, based on the practical exercises I’ve performed.    OPEN PDF AJT Manual PDF Practical No. 02 Aim: Create a registration servlet in Java using JDBC. Accept the details such as Username, Password, Email and Country from the user using HTML Form and store the registration details in the database. Index.html TODO supply a title Welcome to Registration page Enter User Name: Enter Password: Enter Email: Enter Country: RegisterServlet.java package mypack; import java.io.*; import java.sql.*; import javax.servlet.*...
Read more

Coding kaise sikhe

-
Image
Coding kaise sikhe  Yah janne ke liye ham Apko Aaj batayenge  Coding karna Kitana aashan hai  Coding se aap web design app developer  Ban sakte hai  Coding ke liye sabsebpale aapke pas computer ya laptop hona jaruri hai  Aap apne laptop me ya computer me w3School code  se Sikh sakte hai aap ko Google par ja kar search karna ho ga w3School aap is websites par #HTML #C++ ,C# ,#python Java script Sikh sakate hai.  Thanks 👍👍👍 for reading  Coding kaise shikhe 
Read more