SAP QIPPLMAT_D Table in S/4 HANA - I_INSPECTIONPLANTP I_INSPPLANMATERIALASSGMNTTP
QIPPLMAT_D is a standard SAP Table which is used to store I_INSPECTIONPLANTP I_INSPPLANMATERIALASSGMNTTP data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP QIPPLMAT_D table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Transparent table
Database Table: QIPPLMAT_D
QIPPLMAT_D table structure field list
Below is the full QIPPLMAT_D field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16(0) | SYSUUID | |||||
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16(0) | SYSUUID | |||||
| INSPECTIONPLANGROUP | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
| INSPECTIONPLAN | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
| INSPECTIONPLANINTERNALVERSION | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
| MATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
| INSPPLANMATLASSIGNMENT | Counter for additional criteria | DZKRIZ | NUMC | 7(0) | ZKRIZ | |||||
| INSPPLANMATLASSGMTINTVERSION | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
| BILLOFOPERATIONSDESC | Description | PLANTEXT | CHAR | 40(0) | TEXT40 | |||||
| VALIDITYSTARTDATE | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
| VALIDITYENDDATE | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
| CHANGENUMBER | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
| CREATIONDATE | Date Record Created On | ANDAT | DATS | 8(0) | DATUM | |||||
| CREATEDBYUSER | Created By User | VDM_CREATEDBYUSERID | CHAR | 12(0) | XUBNAME | |||||
| LASTCHANGEDATE | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
| LASTCHANGEDBYUSER | Last Changed By User | VDM_LASTCHANGEDBYUSERID | CHAR | 12(0) | XUBNAME | |||||
| ISDELETED | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
| ISIMPLICITLYDELETED | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
| SUPPLIER | Vendor's account number | ELIFN | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
| CUSTOMER | Account number of customer | CPKUNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | |||
| BOOSEARCHTEXT | Search Field for Customer-Specific Task List Selection | QSUCHFELD | CHAR | 20(0) | CHAR20 | |||||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 1(0) | BOOLE | |||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 21(7) | TZNTSTMPL | |||||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 21(7) | TZNTSTMPL | |||||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16(0) | SYSUUID | |||||
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 1(0) | SDRAFT_CONSISTENCY_STATUS | |||||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 1(0) | SDRAFT_OPERATION_CODE |
Search for further information about these or an SAP related objects