SAP Table V_T5PED

Generated Table for View

V_T5PED (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link V_T5PED to other SAP tables.

V_T5PED table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUSGR Education/training categories AUSGR NUMC 3 0
GTEXT Education/training category text AGRTX CHAR 25 0
PSEDU PS - education level code PPT_PSEDU NUMC 3 0
110 Can not read or write
120 Can read and write but not attended 1st cycle of basic educ.
210 1st cycle of basic educ.(4th grade of primary education)
220 1st cycle of basic education with professional courses
310 2nd cycle of basic education (Prep.education, TV-school)
320 2nd cycle of basic education with professional courses
410 3rd cycle of basic education
420 Technical education: Business, Industry, Visual Arts
430 3rd cycle of basic education with professional courses
510 Complementary secondary education
520 Complementary technical secondary education
530 Professional technical secondary education
540 Secondary education with professional courses
600 Course in professional schools
700 Other unspecified bachelor degrees
711 Accounting, Administration, Business and Legal counselling
712 Enterpr.Resource, Busin., Intern.and Customs Management
713 Bank, Insurance and Tax Management
714 Industrial Management
715 Personnel Manag., Public Admin.,Communic.and Informatics
721 Civil, Environm., Geotech., Material, Works Proj.Engineering
722 Mechanical Engineering; Electromechanics; Transportation
723 Electronic Engineering; Telecommunications
724 Engineering of Energy, Power and Electrotechnics System
725 Chemical Engineering/Biotechnology; Ceramics and Glass
726 Agricultural, Cattle and Food Engineering
727 Informatics Engineering
728 Industrial Production and Maintenance Engineering
729 Other Engineering (Textile; Mining; Metallurgical; ...)
731 Plastic Arts (Painting, Sculpting and Design)
732 Decorative Arts and Design
733 Arts (Dancing, Singing, Theatre and Cinema, Photography)
734 Heritage Conservation and Restoration
741 Communications, Information and Journalism
742 Marketing, Advertising and Economical Relations
743 Secretariate and Public Relations
744 International Relations
745 Regional and Local Intervention
746 Hotel Management and Tourism
747 Languages/Secretariate/Translation
751 Physics; Physicochemical Sciences; Chemistry
752 Natural Sciences; Biophysical Planning; Geography
761 Kindergarten Workers
762 Primary education teachers
763 Basic education teachers/Teacher training
764 Social Worker
765 Humanities, History and Philosophy
771 Agro-feeding Engineering and Agricultural Technologies
772 Agricultural Companies Management
781 Social Sciences; Sociology; Social Security; Theology
782 Psychology; Organization Intervention; Human Relations
783 Law; Economy
791 Nursing
792 Pharmacy
800 Other unspecified licentiate degrees
811 Accounting, Organization and Company Management
812 Economy, Finance and Mathematics appl.to Econ.and Management
813 Regional and Urban Planning and Management; Hotel Management
814 Public Admin.and Management; HR Management; Heritage Manag.
815 Management Informatics; Management Technologies
821 Civil, Environ., Water Resources, Geolog., Material Engin.
822 Mechan.Eng.; Electromech.; Mecatronichs; Trans.; MaritimeEng
823 Telecommunic.Electronical; Aeronautical; Aerospacial Engin.
824 Engineering of Energy, Power Systems; Electrotechnics; ...
825 Chemical Eng.; Physics; Biotechnology; Biophysics; BiologEng
826 Mining Engineering; Metallurgy and Mechanical enginnering
827 Informatics Engineering; Systems and Informatics
828 Industrial Prod.and Maintenance Eng.; Ind.Management and Eng
829 Other Engineering (Paper; Textile; Clothing; Geographical)
831 Plastic Arts (Painting, Sculpting, Design)
832 Decorative Arts and Design
833 Arts (Dancing, Singing, Theater, Cinema, Photography)
834 Architechture, Town planning
841 Media, Information, Journalism, Communications Sciences
842 Marketing, Advertising
843 Public Relations; Secretariate and Administration Sciences
844 International Relations; Cooperation and European Studies
851 Physics; Chemistry; Physicochemical; Biochemistry
852 Natural Sciences; Geography; Geophysics; ...; AquaticEnvir.
853 Biology; Microbiology; Marine Biology; Botanic; Geology
854 Mathematics; Math.applied to Computer Sciences; Statistics
861 Educational Sciences; Secondary education teachers
862 Special education and Rehabilitation
863 Languages; Literature; Linguistics; Translation/Interpreters
864 History and Philosophy
865 Sports, Physical Education/Ergonomics
871 Agronomical Eng.; Agrarian Sciences; Nutrition; Enology
872 Agricultural Companies Management; Agro-industrial Eng.
873 Forestry Engineering; Forestry Production; Forestry
881 Social Sciences; Sociology; Anthropology; Politics; Theology
882 Psychology
883 Law
891 Pharmaceutical Sciences
892 Dentistry/Medicine
893 Veterinarian Medicine
PSED2 PS 2000 - education level code PPT_PSED2 NUMC 3 0
111 Can not read or write
112 Can read and write but not attended 1st cycle of basic educ.
211 1st cycle of basic educ.(4th grade of primary education)
212 1st cycle of basic education with professional courses
221 2nd cycle of basic education
222 2nd cycle of basic education with professional courses
231 3rd cycle of basic education
232 Technical education: Business, Industry, Visual Arts
233 3rd cycle of basic education with professional courses
234 Courses in professional schools - level II
311 Secondary education (12th grade) with professional courses
312 Complementary technical secondary education
313 Professional technical secondary education
314 Courses in professional schools - level III
315 Secondary education (12th grade or equiv.), complem.sec.ed.
316 Secondary education with professional nature courses
414 Post-secondary non-higher education f/teachers/educ.sciences
421 Post-secondary non-higher education - Arts
422 Post-secondary non-higher education - Humanities
431 Post-second.non-higher educ.- Social and behavioral sciences
432 Post-secondary non-higher educ.- Journalism and media
434 Post-second.non-higher education - Business & administration
438 Post-secondary non-higher education - Law
442 Post-secondary non-higher education - Life sciences
444 Post-secondary non-higher education - Physical sciences
446 Post-secondary non-higher educ.- Mathematics and statistics
448 Post-secondary non-higher education - Computer science
452 Post-second.non-higher educ.-Engineering & similar technique
454 Post-secondary non-higher educ.- Transf.and process.industry
458 Post-secondary non-higher educ.- Architecture and construct.
462 Post-secondary non-higher educ.- Agric.,forestry, fishing
464 Post-secondary non-higher education - Veterinary sciences
472 Post-secondary non-higher education - Health
476 Post-secondary non-higher education - Social services
481 Post-secondary non-higher education - Personal services
484 Post-secondary non-higher educ.- Transportation services
485 Post-secondary non-higher educ.- Environmental protection
486 Post-secondary non-higher education - Security services
499 Post-secondary non-higher education - Unknown or unspecified
514 Baccalaureate - Teacher training and educational sciences
521 Baccalaureate - Arts
522 Baccalaureate - Humanities
531 Baccalaureate - Social and behavioral sciences
532 Baccalaureate - Journalism and media
534 Baccalaureate - Business and administration
538 Baccalaureate - Law
542 Baccalaureate - Life sciences
544 Baccalaureate - Physical sciences
546 Baccalaureate - Mathematics and statistics
548 Baccalaureate - Computer science
552 Baccalaureate - Engineering and similar techniques
554 Baccalaureate - Transformation and processing industries
558 Baccalaureate - Architecture and construction
562 Baccalaureate - Agriculture, forestry and fishing
564 Baccalaureate - Veterinary sciences
572 Baccalaureate - Health
576 Baccalaureate - Social services
581 Baccalaureate - Personal services
584 Baccalaureate - Transportation services
585 Baccalaureate - Environmental protection
586 Baccalaureate - Security services
599 Baccalaureate - Unknown or unspecified
614 Master degree - Teacher training and educational sciences
621 Master degree - Arts
622 Master degree - Humanities
631 Master degree - Social and behavioral sciences
632 Master degree - Journalism and media
634 Master degree - Business and administration
638 Master degree - Law
642 Master degree - Life sciences
644 Master degree - Physical sciences
646 Master degree - Mathematics and statistics
648 Master degree - Computer science
652 Master degree - Engineering and similar techniques
654 Master degree - Transformation and processing industries
658 Master degree - Architecture and construction
662 Master degree - Agriculture, forestry and fishing
664 Master degree - Veterinary sciences
672 Master degree - Health
676 Master degree - Social services
681 Master degree - Personal services
684 Master degree - Transportation services
685 Master degree - Environmental protection
686 Master degree - Security services
699 Master degree - Unknown or unspecified
714 Post-Master's degree - Teacher training and educ.sciences
721 Post-Master's degree - Arts
722 Post-Master's degree - Humanities
731 Post-Master's degree - Social and behavioral sciences
732 Post-Master's degree - Journalism and media
734 Post-Master's degree - Business and administration
738 Post-Master's degree - Law
742 Post-Master's degree - Life sciences
744 Post-Master's degree - Physical sciences
746 Post-Master's degree - Mathematics and statistics
748 Post-Master's degree - Computer science
752 Post-Master's degree - Engineering and similar techniques
754 Post-Master's degree - Transformation and process.industries
758 Post-Master's degree - Architechture and construction
762 Post-Master's degree - Agriculture, forestry and fishing
764 Post-Master's degree - Veterinary sciences
772 Post-Master's degree - Health
776 Post-Master's degree - Social services
781 Post-Master's degree - Personal services
784 Post-Master's degree - Transportation services
785 Post-Master's degree - Environmental protection
786 Post-Master's degree - Security services
799 Post-Master's degree - Unknown or unspecified
814 Doctorate - Teacher training and educational sciences
821 Doctorate - Arts
822 Doctorate - Humanities
831 Doctorate - Social and behavioral sciences
832 Doctorate - Journalism and media
834 Doctorate - Business and administration
838 Doctorate - Law
842 Doctorate - Life sciences
844 Doctorate - Physical sciences
846 Doctorate - Mathematics and statistics
848 Doctorate - Computer science
852 Doctorate - Engineering and similar techniques
854 Doctorate - Transformation and processing industries
858 Doctorate - Architecture and construction
862 Doctorate - Agriculture, forestry and fishing
864 Doctorate - Veterinary sciences
872 Doctorate - Health
876 Doctorate - Social services
881 Doctorate - Personal services
884 Doctorate - Transportation services
885 Doctorate - Environmental protection
886 Doctorate - Security services
899 Doctorate - Unknown or unspecified
SBEDU BS - Educational level code PPT_SBEDU NUMC 3 0
100 Less than Basic Education 1st Cycle
200 Basic Education 1st Cycle
300 Basic Education 2nd Cycle
400 Basic Education 3rd Cycle
500 High School
600 Professional-Oriented High School
700 Technical Education
800 University Education
900 Others
NIQUA Training qualification level PPT_NIQUA CHAR 2 0
01 Level 1
02 Level 2
03 Level 3
04 Level 4
05 Level 5
06 Level 6
07 Level 7
08 Level 8
09 Without level assignment
99 Unknown
NULL Not applicable

V_T5PED foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_T5PED MANDT V_T5PED MANDT T000 Clients MANDT