SAP Table BAPI2045L4
Inspection points list
BAPI2045L4 (Inspection points list) 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 BAPI2045L4 to other SAP tables.
Source: BAPI2045L4 (Inspection points list)
BAPI2045L4 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| INSPLOT | Inspection Lot Number | QIBPLOSNR | QALS | NUMC | 12 | 0 | ||
| INSPOPER | Inspection Lot Operation Number | QIBPVORNR | CHAR | 4 | 0 | |||
| INSPPOINT | Inspection Point Number | QIBPPPKTNR | QAPP | NUMC | 6 | 0 | ||
| PART_LOT | Partial lot number | QTLOS | QALT | NUMC | 6 | 0 | ||
| QUANTITY | Inspection Point Quantity | QEIFMENGPP | CHAR | 17 | 0 | |||
| UNIT | Inspection Point Unit of Measure | QEIFEINHPR | T006 | UNIT | 3 | 0 | ||
| UNITC | ISO Code for Unit of Measure | QMEASUNITC | CHAR | 3 | 0 | |||
| UNITT | Short Text for Unit of Measure | QMEASUNITT | CHAR | 20 | 0 | |||
| EQUIPMENT | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||
| FUNCT_LOC | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||
| PHYS_SMPL | Physical Sample Number | QPHYS_NR | CHAR | 12 | 0 | |||
| USERC1 | User Field for 18 Characters | QUSRCHAR18 | CHAR | 18 | 0 | |||
| USERC2 | User Field for 10 Characters | QUSRCHAR10 | CHAR | 10 | 0 | |||
| USERN1 | User Field for 10 Digits | QUSRNUMC10 | NUMC | 10 | 0 | |||
| USERN2 | User Field for 3 Digits | QUSRNUMC3 | NUMC | 3 | 0 | |||
| USERD1 | User Field for Date | QEIFUSRDAT | DATS | 8 | 0 | |||
| USERT1 | User Field for Time | QEIFUSRTIM | TIMS | 6 | 0 | |||
| CAT_TYPE | Catalog | QKATART | TQ15 | CHAR | 1 | 0 | ||
| PSEL_SET | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| SEL_SET | Selected Set of the Usage Decision | QVMENGE | QPAM | CHAR | 8 | 0 | ||
| CODE_GRP | Code Group of the Usage Decision | QVGRUPPE | QPGR | CHAR | 8 | 0 | ||
| CODE | Usage Decision Code | QVCODE | QPCD | CHAR | 4 | 0 | ||
| REMARK | Short Text | QKURZTEXT | CHAR | 40 | 0 | |||
| MATERIAL | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| BATCH | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||
| INSP_DATE | Inspection Start Date (QM Subsystem Interface) | QEIFPRDATV | DATS | 8 | 0 | |||
| INSP_TIME | Inspection Start Time (QM Subsystem Interface) | QEIFPRZTV | TIMS | 6 | 0 | |||
| INSPECTOR | Name of the Inspector | QPRUEFER | CHAR | 12 | 0 | |||
| SCRP_QUANT | Scrap Quantity | QEIFASMG | CHAR | 17 | 0 | |||
| MATERIAL_EXTERNAL | Long Material Number for MATERIAL Field | MGV_MATERIAL_EXTERNAL | CHAR | 40 | 0 | |||
| MATERIAL_GUID | External GUID for MATERIAL Field | MGV_MATERIAL_GUID | CHAR | 32 | 0 | |||
| MATERIAL_VERSION | Version Number for MATERIAL Field | MGV_MATERIAL_VERSION | CHAR | 10 | 0 | |||
| REWORK_QUANT | Rework Quantity | QEIFNAMG | CHAR | 17 | 0 | |||
BAPI2045L4 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPI2045L4 | BATCH | SY | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| BAPI2045L4 | BATCH | BAPI2045L4 | MATERIAL | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| BAPI2045L4 | BATCH | BAPI2045L4 | BATCH | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| BAPI2045L4 | CAT_TYPE | SY | MANDT | TQ15 | Inspection catalog type index | MANDT |
| BAPI2045L4 | CAT_TYPE | BAPI2045L4 | CAT_TYPE | TQ15 | Inspection catalog type index | KATALOGART |
| BAPI2045L4 | CODE | * | QPCD | Inspection catalog codes | VERSION | |
| BAPI2045L4 | CODE | BAPI2045L4 | CODE | QPCD | Inspection catalog codes | CODE |
| BAPI2045L4 | CODE | BAPI2045L4 | CODE_GRP | QPCD | Inspection catalog codes | CODEGRUPPE |
| BAPI2045L4 | CODE | BAPI2045L4 | CAT_TYPE | QPCD | Inspection catalog codes | KATALOGART |
| BAPI2045L4 | CODE | SY | MANDT | QPCD | Inspection catalog codes | MANDT |
| BAPI2045L4 | CODE_GRP | BAPI2045L4 | CODE_GRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| BAPI2045L4 | CODE_GRP | SY | MANDT | QPGR | Inspection catalog code groups | MANDT |
| BAPI2045L4 | CODE_GRP | BAPI2045L4 | CAT_TYPE | QPGR | Inspection catalog code groups | KATALOGART |
| BAPI2045L4 | EQUIPMENT | BAPI2045L4 | EQUIPMENT | EQUI | Equipment master data | EQUNR |
| BAPI2045L4 | EQUIPMENT | SY | MANDT | EQUI | Equipment master data | MANDT |
| BAPI2045L4 | FUNCT_LOC | BAPI2045L4 | FUNCT_LOC | IFLOT | Functional Location (Table) | TPLNR |
| BAPI2045L4 | FUNCT_LOC | SY | MANDT | IFLOT | Functional Location (Table) | MANDT |
| BAPI2045L4 | INSPLOT | BAPI2045L4 | INSPLOT | QALS | Inspection lot record | PRUEFLOS |
| BAPI2045L4 | INSPLOT | SY | MANDT | QALS | Inspection lot record | MANDANT |
| BAPI2045L4 | INSPPOINT | SY | MANDT | QAPP | Inspection point | MANDT |
| BAPI2045L4 | INSPPOINT | BAPI2045L4 | INSPLOT | QAPP | Inspection point | PRUEFLOS |
| BAPI2045L4 | INSPPOINT | * | QAPP | Inspection point | VORGLFNR | |
| BAPI2045L4 | INSPPOINT | BAPI2045L4 | INSPPOINT | QAPP | Inspection point | PROBENR |
| BAPI2045L4 | MATERIAL | SY | MANDT | MARA | General Material Data | MANDT |
| BAPI2045L4 | MATERIAL | BAPI2045L4 | MATERIAL | MARA | General Material Data | MATNR |
| BAPI2045L4 | PART_LOT | BAPI2045L4 | PART_LOT | QALT | Partial lot | TEILLOS |
| BAPI2045L4 | PART_LOT | BAPI2045L4 | INSPLOT | QALT | Partial lot | PRUEFLOS |
| BAPI2045L4 | PART_LOT | SY | MANDT | QALT | Partial lot | MANDANT |
| BAPI2045L4 | PSEL_SET | SY | MANDT | T001W | Plants/Branches | MANDT |
| BAPI2045L4 | PSEL_SET | BAPI2045L4 | PSEL_SET | T001W | Plants/Branches | WERKS |
| BAPI2045L4 | SEL_SET | BAPI2045L4 | SEL_SET | QPAM | Inspection catalog selected sets | AUSWAHLMGE |
| BAPI2045L4 | SEL_SET | BAPI2045L4 | CAT_TYPE | QPAM | Inspection catalog selected sets | KATALOGART |
| BAPI2045L4 | SEL_SET | BAPI2045L4 | PSEL_SET | QPAM | Inspection catalog selected sets | WERKS |
| BAPI2045L4 | SEL_SET | SY | MANDT | QPAM | Inspection catalog selected sets | MANDT |
| BAPI2045L4 | UNIT | BAPI2045L4 | UNIT | T006 | Units of Measurement | MSEHI |
| BAPI2045L4 | UNIT | SY | MANDT | T006 | Units of Measurement | MANDT |
