SAP ABAP Table
PIQRULEMASTERS
{Main Structure for Rules Related to Student}
Home
title {label: "SAP ABAP table PIQRULEMASTERS {Main Structure for Rules Related to Student}", size: "20"} # Entities [PIQRULEMASTERS] {bgcolor: "tomato"} SM_PLVAR {label: "CHAR (2)"} +SM_1746_SEVERITY {label: "NUMC (4)"} +SM_1744_DISZIPRIMARY {label: "CHAR (16)"} +SM_506_SMSTATUS {label: "NUMC (2)"} SM_506_STORREASON {label: "CHAR (4)"} +SM_506_SMRATING {label: "CHAR (3)"} +SM_506_PERID {label: "NUMC (3)"} +SM_506_PERYR {label: "NUMC (4)"} +CG_CATEGORY {label: "CHAR (4)"} +CG_DISZIPPRIMARY {label: "CHAR (16)"} +D_DELMODE {label: "CHAR (4)"} +D_CATEGORY {label: "CHAR (4)"} +D_TEACHMETHOD {label: "CHAR (4)"} +COUNTRY {label: "CHAR (3)"} +REGION {label: "CHAR (3)"} TRANSTYPE_HD {label: "CHAR (4)"} +TRSTATUS_HD {label: "CHAR (4)"} +RETURNINDIC_HD {label: "CHAR (4)"} +TOTSELFGPASCALE_HD {label: "CHAR (4)"} +TOTEXTGPA1SCALE_HD {label: "CHAR (4)"} +TOTEXTGPA2SCALE_HD {label: "CHAR (4)"} +TOTEXTGPA3SCALE_HD {label: "CHAR (4)"} +TOTCALCGPASCALE_HD {label: "CHAR (4)"} +TOTEXTCREDTYPE_HD {label: "UNIT (3)"} +TOTINTCREDTYPE_HD {label: "UNIT (3)"} +DEGEXTSCALEID_DG {label: "CHAR (4)"} +DEGINTSCALEID_DG {label: "CHAR (4)"} +DEGHONORS_DG {label: "CHAR (4)"} +SPECID_DS {label: "CHAR (16)"} +SPECTYPE_DS {label: "CHAR (4)"} +SESSIONID_PR {label: "CHAR (4)"} +STAGEID_PR {label: "NUMC (2)"} +PROGCLASSID_PR {label: "CHAR (4)"} +PROGACST_PR {label: "CHAR (4)"} +PROGSTAT_PR {label: "NUMC (3)"} +EXTSESGPASCALE_PR {label: "CHAR (4)"} +INTSESGPASCALE_PR {label: "CHAR (4)"} +EXTSESCREDTYPE_PR {label: "UNIT (3)"} +INTSESCREDTYPE_PR {label: "UNIT (3)"} +EXTGRADESCALE_SU {label: "CHAR (4)"} +INTGRADESCALE_SU {label: "CHAR (4)"} +EXTCOCREDTYPE_SU {label: "UNIT (3)"} +INTCOCREDTYPE_SU {label: "UNIT (3)"} +BASFORCOCRED_SU {label: "CHAR (4)"} +COSESID_SU {label: "CHAR (4)"} +CODEDNOTEID_CN {label: "CHAR (12)"} +TESTTYPETST {label: "CHAR (12)"} +SESSIONIDTST {label: "CHAR (4)"} +TESTSCALE_IDTST {label: "CHAR (4)"} +ENTRYMODETST {label: "CHAR (4)"} +RESULTSTATUSTST {label: "CHAR (3)"} +STATUSREASONTST {label: "CHAR (3)"} +SUBTESTIDSTS {label: "CHAR (12)"} +QQ_QUAL_GROUP {label: "CHAR (4)"} +QQ_QUAL_DISCI {label: "CHAR (4)"} +QQ_QUAL_LEVEL {label: "CHAR (4)"} +QQ_QUAL_CLASS {label: "CHAR (4)"} +QQ_SCALE_INTERNAL {label: "CHAR (4)"} +QQ_SCALE_EXTERNAL {label: "CHAR (4)"} [T005] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *LAND1 {label: "CHAR (3)"} [T005S] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+LAND1 {label: "CHAR (3)"} *BLAND {label: "CHAR (3)"} [T7PIQCATEGORY] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *CATEGORY {label: "CHAR (4)"} [T7PIQCP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+CPUNIT {label: "UNIT (3)"} [T7PIQDELMODE] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *DELMODE {label: "CHAR (4)"} [T7PIQINVRSN] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *REASONCODE {label: "CHAR (3)"} [T7PIQLEVEL] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *ACLEVEL {label: "NUMC (2)"} [T7PIQMETHOD] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *METHOD {label: "CHAR (4)"} [T7PIQMODGRPCAT] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *CATEGORY {label: "CHAR (4)"} [T7PIQPERIOD] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PERID {label: "NUMC (3)"} [T7PIQPROGCLASS] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PROGCLASS {label: "CHAR (4)"} [T7PIQPROGSTATUS] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *PROGSTATUS {label: "NUMC (3)"} [T7PIQQUALDISCI] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *QUAL_DISCI {label: "CHAR (4)"} [T7PIQQUALGROUP] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *QUAL_GROUP {label: "CHAR (4)"} [T7PIQQUAL_CLASS] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *QUAL_CLASS {label: "CHAR (4)"} [T7PIQQUAL_LEVEL] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *QUAL_LEVEL {label: "CHAR (4)"} [T7PIQREPSTAT] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *REPSTATE {label: "CHAR (4)"} [T7PIQSCALE] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *SCALEID {label: "CHAR (4)"} [T7PIQSEVERITY] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *SEVERITY {label: "NUMC (4)"} [T7PIQSMDISZIP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *DISZIP {label: "CHAR (16)"} [T7PIQSMRATING] {bgcolor: "#d0e0d0"} *MANDT {label: "CLNT (3)"} *SMRATING {label: "CHAR (3)"} [T7PIQSMSTAT] {bgcolor: "#d0e0d0"} *SMSTATUS {label: "NUMC (2)"} [T7PIQTRBASFORCP] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *BASISFORCP {label: "CHAR (4)"} [T7PIQTRCODNOTE] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *CODEDNOTEID {label: "CHAR (12)"} [T7PIQTRDEGHON] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *DEGHONORS {label: "CHAR (4)"} [T7PIQTRENTRYMOD] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *ENTRYMODE {label: "CHAR (4)"} [T7PIQTREXTSES] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *SESSIONID {label: "CHAR (4)"} [T7PIQTRPROGAS] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PROGACST {label: "CHAR (4)"} [T7PIQTRRETINDIC] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *RETURNINDIC {label: "CHAR (4)"} [T7PIQTRSTAT] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *STATUSCODE {label: "CHAR (3)"} [T7PIQTRSUBTEST] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *+TESTTYPE {label: "CHAR (12)"} *SUBTESTID {label: "CHAR (12)"} [T7PIQTRTESTTYPE] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *TESTTYPE {label: "CHAR (12)"} [T7PIQYEAR] {bgcolor: "#d0e0d0"} *+MANDT {label: "CLNT (3)"} *PERYR {label: "NUMC (4)"} # Relationships PIQRULEMASTERS 1--* T7PIQTRBASFORCP {label: "PIQRULEMASTERS-BASFORCOCRED_SU = T7PIQTRBASFORCP-BASISFORCP"} PIQRULEMASTERS *--* T7PIQMODGRPCAT {label: "PIQRULEMASTERS-CG_CATEGORY = T7PIQMODGRPCAT-CATEGORY"} PIQRULEMASTERS *--* T7PIQSMDISZIP {label: "PIQRULEMASTERS-CG_DISZIPPRIMARY = T7PIQSMDISZIP-DISZIP"} PIQRULEMASTERS 1--* T7PIQTRCODNOTE {label: "PIQRULEMASTERS-CODEDNOTEID_CN = T7PIQTRCODNOTE-CODEDNOTEID"} PIQRULEMASTERS 1--* T7PIQTREXTSES {label: "PIQRULEMASTERS-COSESID_SU = T7PIQTREXTSES-SESSIONID"} PIQRULEMASTERS *--* T005 {label: "PIQRULEMASTERS-COUNTRY = T005-LAND1"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-DEGEXTSCALEID_DG = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQTRDEGHON {label: "PIQRULEMASTERS-DEGHONORS_DG = T7PIQTRDEGHON-DEGHONORS"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-DEGINTSCALEID_DG = T7PIQSCALE-SCALEID"} PIQRULEMASTERS *--* T7PIQCATEGORY {label: "PIQRULEMASTERS-D_CATEGORY = T7PIQCATEGORY-CATEGORY"} PIQRULEMASTERS *--* T7PIQDELMODE {label: "PIQRULEMASTERS-D_DELMODE = T7PIQDELMODE-DELMODE"} PIQRULEMASTERS *--* T7PIQMETHOD {label: "PIQRULEMASTERS-D_TEACHMETHOD = T7PIQMETHOD-METHOD"} PIQRULEMASTERS 1--* T7PIQTRENTRYMOD {label: "PIQRULEMASTERS-ENTRYMODETST = T7PIQTRENTRYMOD-ENTRYMODE"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-EXTCOCREDTYPE_SU = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-EXTGRADESCALE_SU = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-EXTSESCREDTYPE_PR = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-EXTSESGPASCALE_PR = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-INTCOCREDTYPE_SU = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-INTGRADESCALE_SU = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-INTSESCREDTYPE_PR = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-INTSESGPASCALE_PR = T7PIQSCALE-SCALEID"} PIQRULEMASTERS *--* T7PIQTRPROGAS {label: "PIQRULEMASTERS-PROGACST_PR = T7PIQTRPROGAS-PROGACST"} PIQRULEMASTERS 1--* T7PIQPROGCLASS {label: "PIQRULEMASTERS-PROGCLASSID_PR = T7PIQPROGCLASS-PROGCLASS"} PIQRULEMASTERS 1--* T7PIQPROGSTATUS {label: "PIQRULEMASTERS-PROGSTAT_PR = T7PIQPROGSTATUS-PROGSTATUS"} PIQRULEMASTERS *--* T7PIQQUAL_CLASS {label: "PIQRULEMASTERS-QQ_QUAL_CLASS = T7PIQQUAL_CLASS-QUAL_CLASS"} PIQRULEMASTERS *--* T7PIQQUALDISCI {label: "PIQRULEMASTERS-QQ_QUAL_DISCI = T7PIQQUALDISCI-QUAL_DISCI"} PIQRULEMASTERS *--* T7PIQQUALGROUP {label: "PIQRULEMASTERS-QQ_QUAL_GROUP = T7PIQQUALGROUP-QUAL_GROUP"} PIQRULEMASTERS *--* T7PIQQUAL_LEVEL {label: "PIQRULEMASTERS-QQ_QUAL_LEVEL = T7PIQQUAL_LEVEL-QUAL_LEVEL"} PIQRULEMASTERS *--* T7PIQSCALE {label: "PIQRULEMASTERS-QQ_SCALE_EXTERNAL = T7PIQSCALE-SCALEID"} PIQRULEMASTERS *--* T7PIQSCALE {label: "PIQRULEMASTERS-QQ_SCALE_INTERNAL = T7PIQSCALE-SCALEID"} PIQRULEMASTERS *--* T005S {label: "PIQRULEMASTERS-REGION = T005S-BLAND"} PIQRULEMASTERS *--* T7PIQTRSTAT {label: "PIQRULEMASTERS-RESULTSTATUSTST = T7PIQTRSTAT-STATUSCODE"} PIQRULEMASTERS 1--* T7PIQTRRETINDIC {label: "PIQRULEMASTERS-RETURNINDIC_HD = T7PIQTRRETINDIC-RETURNINDIC"} PIQRULEMASTERS 1--* T7PIQTREXTSES {label: "PIQRULEMASTERS-SESSIONIDTST = T7PIQTREXTSES-SESSIONID"} PIQRULEMASTERS 1--* T7PIQTREXTSES {label: "PIQRULEMASTERS-SESSIONID_PR = T7PIQTREXTSES-SESSIONID"} PIQRULEMASTERS *--* T7PIQSMDISZIP {label: "PIQRULEMASTERS-SM_1744_DISZIPRIMARY = T7PIQSMDISZIP-DISZIP"} PIQRULEMASTERS *--* T7PIQSEVERITY {label: "PIQRULEMASTERS-SM_1746_SEVERITY = T7PIQSEVERITY-SEVERITY"} PIQRULEMASTERS *--* T7PIQPERIOD {label: "PIQRULEMASTERS-SM_506_PERID = T7PIQPERIOD-PERID"} PIQRULEMASTERS *--* T7PIQYEAR {label: "PIQRULEMASTERS-SM_506_PERYR = T7PIQYEAR-PERYR"} PIQRULEMASTERS *--* T7PIQSMRATING {label: "PIQRULEMASTERS-SM_506_SMRATING = T7PIQSMRATING-SMRATING"} PIQRULEMASTERS *--* T7PIQSMSTAT {label: "PIQRULEMASTERS-SM_506_SMSTATUS = T7PIQSMSTAT-SMSTATUS"} PIQRULEMASTERS 1--* T7PIQSMDISZIP {label: "PIQRULEMASTERS-SPECID_DS = T7PIQSMDISZIP-DISZIP"} PIQRULEMASTERS 1--* T7PIQMODGRPCAT {label: "PIQRULEMASTERS-SPECTYPE_DS = T7PIQMODGRPCAT-CATEGORY"} PIQRULEMASTERS 1--* T7PIQLEVEL {label: "PIQRULEMASTERS-STAGEID_PR = T7PIQLEVEL-ACLEVEL"} PIQRULEMASTERS *--* T7PIQINVRSN {label: "PIQRULEMASTERS-STATUSREASONTST = T7PIQINVRSN-REASONCODE"} PIQRULEMASTERS 1--* T7PIQTRSUBTEST {label: "PIQRULEMASTERS-SUBTESTIDSTS = T7PIQTRSUBTEST-SUBTESTID"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TESTSCALE_IDTST = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQTRTESTTYPE {label: "PIQRULEMASTERS-TESTTYPETST = T7PIQTRTESTTYPE-TESTTYPE"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TOTCALCGPASCALE_HD = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-TOTEXTCREDTYPE_HD = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TOTEXTGPA1SCALE_HD = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TOTEXTGPA2SCALE_HD = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TOTEXTGPA3SCALE_HD = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQCP {label: "PIQRULEMASTERS-TOTINTCREDTYPE_HD = T7PIQCP-CPUNIT"} PIQRULEMASTERS 1--* T7PIQSCALE {label: "PIQRULEMASTERS-TOTSELFGPASCALE_HD = T7PIQSCALE-SCALEID"} PIQRULEMASTERS 1--* T7PIQREPSTAT {label: "PIQRULEMASTERS-TRSTATUS_HD = T7PIQREPSTAT-REPSTATE"}
View Full Image
View in PDF
Foreign Key tables (33)
T005
{Countries}
T005S
{Taxes: Region (Province) Key}
T7PIQCATEGORY
{Categories}
T7PIQCP
{Credit Types}
T7PIQDELMODE
{Delivery Modes}
T7PIQINVRSN
{Possible reason codes for invalidating External Test Result}
T7PIQLEVEL
{Stages}
T7PIQMETHOD
{Teaching Methods}
T7PIQMODGRPCAT
{Module Group Categories}
T7PIQPERIOD
{Academic Sessions}
T7PIQPROGCLASS
{Progress Classifications}
T7PIQPROGSTATUS
{Progression Statuses}
T7PIQQUALDISCI
{Qualification Disciplines}
T7PIQQUALGROUP
{Qualification Groups}
T7PIQQUAL_CLASS
{Degree Levels}
T7PIQQUAL_LEVEL
{Degree Types}
T7PIQREPSTAT
{Transcript Statuses}
T7PIQSCALE
{Academic Scales}
T7PIQSEVERITY
{Academic Level per Module}
T7PIQSMDISZIP
{Module Disciplines}
T7PIQSMRATING
{Alternative Assessment Methods for Modules}
T7PIQSMSTAT
{Module Booking Statuses}
T7PIQTRBASFORCP
{Basis for Accomplished Credits}
T7PIQTRCODNOTE
{Coded Notes in External Transcripts}
T7PIQTRDEGHON
{Special Academic Qualification Distinctions}
T7PIQTRENTRYMOD
{Sources of External Test Results}
T7PIQTREXTSES
{External Academic Sessions}
T7PIQTRPROGAS
{External Academic Standing}
T7PIQTRRETINDIC
{Student's Eligibility to Return to External Organization}
T7PIQTRSTAT
{Table to hold External Test Result statuses}
T7PIQTRSUBTEST
{External Subtest Types}
T7PIQTRTESTTYPE
{External Test Types}
T7PIQYEAR
{Academic Years}