SAP ABAP Table
PIQ_STUDENTLDB_DETAILDATA
{Detailed Data for Logical Database RHIQ_STUDENT_LDB}
Home
title {label: "SAP ABAP table PIQ_STUDENTLDB_DETAILDATA {Detailed Data for Logical Database RHIQ_STUDENT_LDB}", size: "20"} # Entities [PIQ_STUDENTLDB_DETAILDATA] {bgcolor: "tomato"} +PLVAR {label: "CHAR (2)"} +OTYPE {label: "CHAR (2)"} +FORM_OF_ADDRESS_KEY {label: "CHAR (1)"} +TITEL {label: "CHAR (15)"} +NAME_AFFIX {label: "CHAR (15)"} +ARISTOCRATIC_TITLE {label: "CHAR (15)"} +COUNTRY_OF_BIRTH {label: "CHAR (3)"} +REGION_OF_BIRTH {label: "CHAR (3)"} +MARITAL_STATUS {label: "CHAR (1)"} +CORRESP_LANGUAGE {label: "LANG (1)"} +RELIGION {label: "CHAR (2)"} +ETHNIC_GRP {label: "CHAR (4)"} +JOB {label: "NUMC (8)"} +SOCIAL_GRP {label: "CHAR (2)"} +DRIVERS_LICENSE_COUNTRY {label: "CHAR (3)"} +DRIVERS_LICENSE_REGION {label: "CHAR (3)"} +CHALL_GRP {label: "CHAR (2)"} +CHALL_TYPE {label: "CHAR (2)"} +RESIDENCY_COUNTRY {label: "CHAR (3)"} +RESIDENCY_REGION {label: "CHAR (3)"} +RESIDENCY_COUNTY {label: "CHAR (3)"} +ORIGIN {label: "CHAR (4)"} +STUDENTGRP {label: "CHAR (4)"} +STUDENT_FEE_CATEG {label: "CHAR (4)"} +BENEFIT_CATEG {label: "CHAR (4)"} +PERS_DISCOUNT1 {label: "CHAR (4)"} +PERS_DISCOUNT2 {label: "CHAR (4)"} +PERS_DISCOUNT3 {label: "CHAR (4)"} +PERS_DISCOUNT4 {label: "CHAR (4)"} +PERS_DISCOUNT5 {label: "CHAR (4)"} +PERS_DISCOUNT6 {label: "CHAR (4)"} +IDENTIFICATIONTYPE {label: "CHAR (4)"} +ISSUING_COUNTRY {label: "CHAR (3)"} +REGIOGROUP {label: "CHAR (8)"} +PO_BOX_REG {label: "CHAR (3)"} +POBOX_CTRY {label: "CHAR (3)"} +STR_ABBR {label: "CHAR (2)"} +COUNTRY {label: "CHAR (3)"} +REGION {label: "CHAR (3)"} +TIME_ZONE {label: "CHAR (6)"} +ADDRESSTYPE {label: "CHAR (10)"} [ADRREGGRP] {bgcolor: "#d0e0d0"} *+CLIENT {label: "CLNT (3)"} *REGIOGROUP {label: "CHAR (8)"} [ADRSTRTYPE] {bgcolor: "#d0e0d0"} *+CLIENT {label: "CLNT (3)"} *+COUNTRY {label: "CHAR (3)"} *STRTYPEAB {label: "CHAR (2)"} [T002] {bgcolor: "#d0e0d0"} *SPRAS {label: "LANG (1)"} [T005] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *LAND1 {label: "CHAR (3)"} [T005E] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+LAND1 {label: "CHAR (3)"} *+REGIO {label: "CHAR (3)"} *COUNC {label: "CHAR (3)"} [T005S] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+LAND1 {label: "CHAR (3)"} *BLAND {label: "CHAR (3)"} [T502T] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *+SPRSL {label: "LANG (1)"} *FAMST {label: "CHAR (1)"} [T513C] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+SPRAS {label: "LANG (1)"} *TAETE {label: "NUMC (8)"} [T516T] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+SPRSL {label: "LANG (1)"} *KONFE {label: "CHAR (2)"} [T522G] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *ANRED {label: "CHAR (1)"} [T535N] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *ART {label: "CHAR (1)"} *TITEL {label: "CHAR (15)"} [T778O] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *OTYPE {label: "CHAR (2)"} [T778P] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PLVAR {label: "CHAR (2)"} [T7PIQBENCAT] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *BENCAT {label: "CHAR (4)"} [T7PIQCHGRP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *CHGRP {label: "CHAR (2)"} [T7PIQCHTYP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *CHTYP {label: "CHAR (2)"} [T7PIQETHNIC] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *ETHNIC {label: "CHAR (4)"} [T7PIQORIGIN] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *ORIGIN {label: "CHAR (4)"} [T7PIQPDISCT1] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PDISCT1 {label: "CHAR (4)"} [T7PIQPDISCT2] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PDISCT2 {label: "CHAR (4)"} [T7PIQPDISCT3] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PDISCT3 {label: "CHAR (4)"} [T7PIQPDISCT4] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *PDISCT4 {label: "CHAR (4)"} [T7PIQPDISCT5] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *PDISCT5 {label: "CHAR (4)"} [T7PIQPDISCT6] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *PDISCT6 {label: "CHAR (4)"} [T7PIQSOCIAL] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *SOCIAL {label: "CHAR (2)"} [T7PIQSTFEECAT] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *STFEECAT {label: "CHAR (4)"} [T7PIQSTGRP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *STGRP {label: "CHAR (4)"} [T7PIQVISATYPE] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *VISATYPE {label: "CHAR (4)"} [TB009] {bgcolor: "#d0e0d0"} *+CLIENT {label: "CLNT (3)"} *ADR_KIND {label: "CHAR (10)"} [TTZZ] {bgcolor: "#d0e0d0"} *+CLIENT {label: "CLNT (3)"} *TZONE {label: "CHAR (6)"} # Relationships PIQ_STUDENTLDB_DETAILDATA 1--* TB009 {label: "PIQ_STUDENTLDB_DETAILDATA-ADDRESSTYPE = TB009-ADR_KIND"} PIQ_STUDENTLDB_DETAILDATA 1--* T535N {label: "PIQ_STUDENTLDB_DETAILDATA-ARISTOCRATIC_TITLE = T535N-TITEL"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQBENCAT {label: "PIQ_STUDENTLDB_DETAILDATA-BENEFIT_CATEG = T7PIQBENCAT-BENCAT"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQCHGRP {label: "PIQ_STUDENTLDB_DETAILDATA-CHALL_GRP = T7PIQCHGRP-CHGRP"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQCHTYP {label: "PIQ_STUDENTLDB_DETAILDATA-CHALL_TYPE = T7PIQCHTYP-CHTYP"} PIQ_STUDENTLDB_DETAILDATA 1--* T002 {label: "PIQ_STUDENTLDB_DETAILDATA-CORRESP_LANGUAGE = T002-SPRAS"} PIQ_STUDENTLDB_DETAILDATA 1--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-COUNTRY = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA 1--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-COUNTRY_OF_BIRTH = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA 1--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-DRIVERS_LICENSE_COUNTRY = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA 1--* T005S {label: "PIQ_STUDENTLDB_DETAILDATA-DRIVERS_LICENSE_REGION = T005S-BLAND"} PIQ_STUDENTLDB_DETAILDATA *--* T7PIQETHNIC {label: "PIQ_STUDENTLDB_DETAILDATA-ETHNIC_GRP = T7PIQETHNIC-ETHNIC"} PIQ_STUDENTLDB_DETAILDATA 1--* T522G {label: "PIQ_STUDENTLDB_DETAILDATA-FORM_OF_ADDRESS_KEY = T522G-ANRED"} PIQ_STUDENTLDB_DETAILDATA *--* T7PIQVISATYPE {label: "PIQ_STUDENTLDB_DETAILDATA-IDENTIFICATIONTYPE = T7PIQVISATYPE-VISATYPE"} PIQ_STUDENTLDB_DETAILDATA *--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-ISSUING_COUNTRY = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA *--* T513C {label: "PIQ_STUDENTLDB_DETAILDATA-JOB = T513C-TAETE"} PIQ_STUDENTLDB_DETAILDATA 1--* T502T {label: "PIQ_STUDENTLDB_DETAILDATA-MARITAL_STATUS = T502T-FAMST"} PIQ_STUDENTLDB_DETAILDATA 1--* T535N {label: "PIQ_STUDENTLDB_DETAILDATA-NAME_AFFIX = T535N-TITEL"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQORIGIN {label: "PIQ_STUDENTLDB_DETAILDATA-ORIGIN = T7PIQORIGIN-ORIGIN"} PIQ_STUDENTLDB_DETAILDATA *--* T778O {label: "PIQ_STUDENTLDB_DETAILDATA-OTYPE = T778O-OTYPE"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT1 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT1 = T7PIQPDISCT1-PDISCT1"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT2 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT2 = T7PIQPDISCT2-PDISCT2"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT3 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT3 = T7PIQPDISCT3-PDISCT3"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT4 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT4 = T7PIQPDISCT4-PDISCT4"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT5 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT5 = T7PIQPDISCT5-PDISCT5"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQPDISCT6 {label: "PIQ_STUDENTLDB_DETAILDATA-PERS_DISCOUNT6 = T7PIQPDISCT6-PDISCT6"} PIQ_STUDENTLDB_DETAILDATA *--* T778P {label: "PIQ_STUDENTLDB_DETAILDATA-PLVAR = T778P-PLVAR"} PIQ_STUDENTLDB_DETAILDATA ?--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-POBOX_CTRY = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA ?--* T005S {label: "PIQ_STUDENTLDB_DETAILDATA-PO_BOX_REG = T005S-BLAND"} PIQ_STUDENTLDB_DETAILDATA ?--* ADRREGGRP {label: "PIQ_STUDENTLDB_DETAILDATA-REGIOGROUP = ADRREGGRP-REGIOGROUP"} PIQ_STUDENTLDB_DETAILDATA ?--* T005S {label: "PIQ_STUDENTLDB_DETAILDATA-REGION = T005S-BLAND"} PIQ_STUDENTLDB_DETAILDATA 1--* T005S {label: "PIQ_STUDENTLDB_DETAILDATA-REGION_OF_BIRTH = T005S-BLAND"} PIQ_STUDENTLDB_DETAILDATA *--* T516T {label: "PIQ_STUDENTLDB_DETAILDATA-RELIGION = T516T-KONFE"} PIQ_STUDENTLDB_DETAILDATA 1--* T005 {label: "PIQ_STUDENTLDB_DETAILDATA-RESIDENCY_COUNTRY = T005-LAND1"} PIQ_STUDENTLDB_DETAILDATA 1--* T005E {label: "PIQ_STUDENTLDB_DETAILDATA-RESIDENCY_COUNTY = T005E-COUNC"} PIQ_STUDENTLDB_DETAILDATA 1--* T005S {label: "PIQ_STUDENTLDB_DETAILDATA-RESIDENCY_REGION = T005S-BLAND"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQSOCIAL {label: "PIQ_STUDENTLDB_DETAILDATA-SOCIAL_GRP = T7PIQSOCIAL-SOCIAL"} PIQ_STUDENTLDB_DETAILDATA ?--* ADRSTRTYPE {label: "PIQ_STUDENTLDB_DETAILDATA-STR_ABBR = ADRSTRTYPE-STRTYPEAB"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQSTGRP {label: "PIQ_STUDENTLDB_DETAILDATA-STUDENTGRP = T7PIQSTGRP-STGRP"} PIQ_STUDENTLDB_DETAILDATA 1--* T7PIQSTFEECAT {label: "PIQ_STUDENTLDB_DETAILDATA-STUDENT_FEE_CATEG = T7PIQSTFEECAT-STFEECAT"} PIQ_STUDENTLDB_DETAILDATA ?--* TTZZ {label: "PIQ_STUDENTLDB_DETAILDATA-TIME_ZONE = TTZZ-TZONE"} PIQ_STUDENTLDB_DETAILDATA 1--* T535N {label: "PIQ_STUDENTLDB_DETAILDATA-TITEL = T535N-TITEL"}
View Full Image
View in PDF
Foreign Key tables (30)
ADRREGGRP
{Regional structure grouping}
ADRSTRTYPE
{Street type}
T002
{Language Keys (Component BC-I18)}
T005
{Countries}
T005E
{County}
T005S
{Taxes: Region (Province) Key}
T502T
{Marital Status Designators}
T513C
{Jobs With Other/Previous Employers}
T516T
{Religious Denomination Texts}
T522G
{Title Keys}
T535N
{Name affixes}
T778O
{Object Types}
T778P
{Plan Versions}
T7PIQBENCAT
{Benefit Categories}
T7PIQCHGRP
{Challenge Groups (Student)}
T7PIQCHTYP
{Challenge Types}
T7PIQETHNIC
{Ethnic Origins}
T7PIQORIGIN
{Origins}
T7PIQPDISCT1
{Discount/Surcharge Category 1}
T7PIQPDISCT2
{Discount/Surcharge Category 2}
T7PIQPDISCT3
{Discount/Surcharge Category 3}
T7PIQPDISCT4
{Discount/Surcharge Category 4}
T7PIQPDISCT5
{Discount/Surcharge Category 5}
T7PIQPDISCT6
{Discount/Surcharge Category 6}
T7PIQSOCIAL
{Social Classes}
T7PIQSTFEECAT
{Student Fee Categories}
T7PIQSTGRP
{Student Groups}
T7PIQVISATYPE
{Visa/Registration Type}
TB009
{BP address types}
TTZZ
{Time zones}