FNDEI_QAMR_FILTER

Filter View for table QAMR | view: FNDEIFQAMR | TRAN | Extraction: Not supported | Component: View Provisioning: Orchestration
Tables used: QALS, QAMR, QAMR
Column Name Description
prueflos FK Inspection Lot Number
vorglfnr Current Node Number from Order Counter
merknr Inspection Characteristic Number
Column Name Description
Column Name Description
Column Name Description
erstelldat System Date on Which Data Record Was Created
aenderdat System Date on Which Data Record Was Changed
pruefdatuv Start Date in Local Time Zone of Inspection
pruefdatub End Date in Local Time Zone of Inspection
pruefzeitv Start Time in Local Time Zone of Inspection
pruefzeitb End Time in Local Time Zone of Inspection
zeiterstl System Time at Which Data Record Was Created
zeitaend System Time at Which Data Record Was Changed
Column Name Description
attribut Attribute of the Results Record (Valid, Invalid,...) Show values
dbewertg Valuation of the Characteristic for Dynamic Modification Show values
mbewertg Inspection Result Valuation Show values
prltextkz Inspection Characteristic Long Text Exists Show values
anteilni Not Initialized for Fraction Show values
maxwertni Value Not Initial if Set Show values
medianni Value Not Initial if Set Show values
minwertni Value Not Initial if Set Show values
mittelwni Value Not Initial if Set Show values
varianzni Value Not Initial if Set Show values
moment3ni Value Not Initial if Set Show values
moment4ni Value Not Initial if Set Show values
anteiloni Value Not Initial if Set Show values
anteiluni Value Not Initial if Set Show values
ivarianzni Value Not Initial if Set Show values
sendeflag Characteristic Result Confirmation from Control Station Show values
aendbeleg Create Change Documents During Results Recording Show values
kzbewertg Valuation Copied or Forced Show values
kzverdicht Reduced No. of Samples for Characteristic Summarization Show values
inpproc_ready Input Processing Successfully Completed Show values
sign_state Status of Signature Process Show values
Column Name Description Domain name
ersteller Name of User Who Created the Data Record QAENDERER
aenderer Name of User Who Last Changed Data Record QAENDERER
changeddatetime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
pruefer Name of Inspector QPRUEFER
pruefbemkt Short Text QKURZTEXT
iststpanz Number of Partial Samples for Characteristic QANZAHL2
iststpumf Number of Recorded Sample Units QANZAHL4
anzfehleh Number of Nonconforming Sample Units QANZAHL4
anteil Estimated Fraction of Nonconforming Sample Units QSTATWERT
anzfehler Number of Defects Found QANZAHL4
anzwerto Number of Measured Values Above Tolerance Range QANZAHL4
anzwertu Number of Measured Values Below Tolerance Range QANZAHL4
anzwertg Number of Inspected Sample Units QANZAHL4
maxwert Maximum Value of Valid Measured Values QSTATWERT
medianwert Median of Valid Measured Values QSTATWERT
minwert Minimum Value of Valid Measured Values QSTATWERT
mittelwert Arithmetic Mean of Valid Measured Values QSTATWERT
varianz Dispersion (Variance) of Valid Measured Values QSTATWERT
moment3 Third Central Moment of Valid Measured Values QSTATWERT
moment4 Fourth Central Moment of Valid Measured Values QSTATWERT
anteilo Estimated Fraction Above Tolerance Range QSTATWERT
anteilu Estimated Fraction Below Tolerance Range QSTATWERT
guelstpanz Number of Valid Partial Samples QANZAHL2
ivarianz Internal Dispersion of Valid Measured Values QSTATWERT
gruppe1 Code Group QCODEGRP
code1 Code QCODE
version1 Version Number QVERSNR
gruppe2 Code Group QCODEGRP
code2 Code QCODE
version2 Version Number QVERSNR
gruppe3 Code Group QCODEGRP
code3 Code QCODE
version3 Version Number QVERSNR
gruppe4 Code Group QCODEGRP
code4 Code QCODE
version4 Version Number QVERSNR
gruppe5 Code Group QCODEGRP
code5 Code QCODE
version5 Version Number QVERSNR
maschine General Information QEQUNR
position Test Position QPRPOS
original_input Original Value Before Input Processing CHAR25
diff_dec_places Different Number of Decimal Places INT2
sign_id Digital Signature for Process SYSUUID_22
dummy_qamr_incl_eew_ps Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Defect Class
  • Client
  • Defect Class
  • FNDEI_QAMR_FILTER.MANDT == TQ17.MANDT
  • FNDEI_QAMR_FILTER.FEHLKLAS == TQ17.FEHLKLASSE
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • FNDEI_QAMR_FILTER.MANDT == TQ15.MANDT
  • FNDEI_QAMR_FILTER.KATALGART1 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • FNDEI_QAMR_FILTER.MANDT == TQ15.MANDT
  • FNDEI_QAMR_FILTER.KATALGART2 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • FNDEI_QAMR_FILTER.MANDT == TQ15.MANDT
  • FNDEI_QAMR_FILTER.KATALGART3 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • FNDEI_QAMR_FILTER.MANDT == TQ15.MANDT
  • FNDEI_QAMR_FILTER.KATALGART4 == TQ15.KATALOGART
Catalog Type of Assigned Code Group or Selected Set
  • Client
  • Catalog Type of Assigned Code Group or Selected Set
  • FNDEI_QAMR_FILTER.MANDT == TQ15.MANDT
  • FNDEI_QAMR_FILTER.KATALGART5 == TQ15.KATALOGART
Language Key FNDEI_QAMR_FILTER.LTEXTSPR == T002.SPRAS
Origin of Results Data
  • Client
  • Origin of Results Data
  • FNDEI_QAMR_FILTER.MANDT == TQ73.MANDT
  • FNDEI_QAMR_FILTER.QERGDATH == TQ73.QERGDATH
Results Record Status FNDEI_QAMR_FILTER.SATZSTATUS == TQ76.STATUS