SAP ABAP Table MSR_S_INSP_ITEM (Advanced Returns Management - Inspection Item)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-ARM-INS (Application Component) Inspection
⤷ MSR_INSPECTION (Package) Multi-Step Returns: Inspections
⤷ LO-ARM-INS (Application Component) Inspection
⤷ MSR_INSPECTION (Package) Multi-Step Returns: Inspections
Basic Data
Table Category | INTTAB | Structure |
Structure | MSR_S_INSP_ITEM | Table Relationship Diagram |
Short Description | Advanced Returns Management - Inspection Item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | INSPEC_NUMB | /SPE/INSPEC_NO | /SPE/INSPEC_NO | CHAR | 12 | 0 | Inspection Outcome number | ||
2 | INSPEC_ITEM | /SPE/INSP_ITEM_NO | /SPE/INSP_ITEM_NO | NUMC | 4 | 0 | Inspection Item Number | ||
3 | DELIV_NUMB | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
4 | DELIV_ITEM | POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
5 | DELIV_TYPE | MSR_DOC_TYPE | MSR_DOC_TYPE | CHAR | 2 | 0 | Document Type | ||
6 | EXIDV | EXIDV | EXIDV | CHAR | 20 | 0 | External Handling Unit Identification | ||
7 | MSR_ID | MSR_PROCESS_ID | MSR_PROCESS_ID | CHAR | 10 | 0 | Process Identification Number | ||
8 | MSR_ITEM | MSR_PROCESS_ITEM | MSR_PROCESS_ITEM | NUMC | 6 | 0 | Item Number | ||
9 | MSR_SPLIT_ID | MSR_SPLIT_ID | MSR_SPLIT_ID | NUMC | 3 | 0 | Split Identification Number | ||
10 | REF_DOC_NR | MSR_DOC_NR | MSR_DOC_NR | CHAR | 30 | 0 | Document Number | ||
11 | REF_DOC_ITEM | MSR_DOC_ITEM | MSR_DOC_ITEM | NUMC | 10 | 0 | Document Item | ||
12 | REF_DOC_TYPE | MSR_DOC_TYPE | MSR_DOC_TYPE | CHAR | 2 | 0 | Document Type | ||
13 | DEC_CODE_CAT | /SPE/DEC_CODE_CAT | /SPE/CODE_CAT | CHAR | 1 | 0 | Inspection Outcome: Catalog Decision | ||
14 | DEC_CODE_GROUP | /SPE/DEC_CODE_GROUP | /SPE/CODE_GROUP | CHAR | 8 | 0 | Inspection Outcome: Code group Decision | ||
15 | DEC_CODE | MSR_INSPECTION_CODE | QCODE | CHAR | 4 | 0 | Inspection Code | * | |
16 | DEC_CODE_DESC | MSR_INSP_DEC_CODE_DESC | QKURZTEXT | CHAR | 40 | 0 | Description of Inspection Decision Code | ||
17 | FU_CODE_CAT | /SPE/FU_CODE_CAT | /SPE/CODE_CAT | CHAR | 1 | 0 | Inspection Outcome: Catalog Follow-up activity | ||
18 | FU_CODE_GROUP | /SPE/FU_CODE_GROUP | /SPE/CODE_GROUP | CHAR | 8 | 0 | Inspection Outcome: Code group Follow-up activity | ||
19 | FU_CODE | MSR_FU_CODE | MSR_FU_CODE | CHAR | 4 | 0 | Follow-Up Activity Code | * | |
20 | FU_CODE_DESC | MSR_FU_CODE_TEXT | TEXT60 | CHAR | 60 | 0 | Follow-Up Activity Description | ||
21 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
22 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
23 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
24 | ARKTX | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
25 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
26 | TOTAL_QUAN | MSR_INSP_TOTAL_QTY | MENG13 | QUAN | 13 | 3 | Total Inspected Quantity | ||
27 | ORG_QUAN | MSR_INSP_ORG_QTY | MENG13 | QUAN | 13 | 3 | Original Quantity | ||
28 | INSP_QUAN | MSR_INSP_INSPECTED_QTY | MENG13 | QUAN | 13 | 3 | Inspected Quantity | ||
29 | INSP_UNIT | MSR_INSP_QUAN_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Inspected Quantity | * | |
30 | UOM_INDICATOR | MSR_INSP_UOM_INDICATOR | MSR_INSP_UOM_INDICATOR | CHAR | 1 | 0 | Indicator for Leading UoM in Inspection | ||
31 | INSP_QUAN_BUOM | MSR_INSP_QUAN | /SPE/INSPQTY | QUAN | 13 | 3 | Inspected Quantity in Base Unit of Measure | ||
32 | INSP_BUOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
33 | INSP_QUAN_SUOM | MSR_INSP_QTY_SALES_UNIT | MENG13 | QUAN | 13 | 3 | Inspected Quantity in Sales Unit of Measure | ||
34 | INSP_SUOM | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
35 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
36 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
37 | LGMNG | LGMNG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered in stockkeeping units | ||
38 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
39 | LFIMG | LFIMG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered (in sales units) | ||
40 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
41 | INSP_OUT_GUID | MSR_INSP_GUID | RAW | 16 | 0 | Inspection GUID | |||
42 | WADAT_IST | WADAT_IST | DATUM | DATS | 8 | 0 | Actual Goods Movement Date | ||
43 | RMA_CUSTOMER | MSR_CRMA_NR | MSR_RMA_NR | CHAR | 20 | 0 | Customer RMA Number | ||
44 | CUSTOMER | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
45 | CUSTOMER_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
46 | RMA_VENDOR | MSR_VRMA_NR | MSR_RMA_NR | CHAR | 20 | 0 | Vendor RMA Number | ||
47 | RMA_VENDOR_REQ | MSR_VRMA_REQ | XFELD | CHAR | 1 | 0 | Vendor RMA Number Required | ||
48 | VENDOR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
49 | VENDOR_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
50 | ADRNR | ADRN2 | AD_ADDRNUM | CHAR | 10 | 0 | Number of delivery address | * | |
51 | VENDOR_ADRNR | ADRN2 | AD_ADDRNUM | CHAR | 10 | 0 | Number of delivery address | * | |
52 | RET_REASON | MSR_RETURNS_REASON | MSR_RETURNS_REASON | CHAR | 3 | 0 | Return Reason | * | |
53 | RET_REASON_DESC | BEZEI60 | TEXT60 | CHAR | 60 | 0 | Description of rule | ||
54 | INSPECTOR | MSR_INSP_INSPECTOR | MSR_INSP_INSPECTOR | CHAR | 80 | 0 | Person Responsible for Inspection | ||
55 | INSPECTION_DATE | MSR_INSP_DATE | DATUM | DATS | 8 | 0 | Inspection Date | ||
56 | INSP_VENDOR | MSR_INSP_VENDOR | LIFNR | CHAR | 10 | 0 | Inspecting Vendor | * | |
57 | LFU_RESPONSIBLE | MSR_INSP_LDM_RESP | MSR_INSP_LFU_RESPONSIBLE | CHAR | 80 | 0 | Person Responsible for Logistical Follow-Up | ||
58 | LFU_DATE | MSR_INSP_LDM_DATE | DATUM | DATS | 8 | 0 | Release Date of Logistical Follow-Up | ||
59 | SUPPLY_PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
60 | SUPPLY_LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
61 | NEXT_PLANT | MSR_NEXT_PLANT | WERKS | CHAR | 4 | 0 | Next Plant | T001W | |
62 | NEXT_PLANT_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
63 | MULTIPLE_PLANTS | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
64 | TRANSSHIPMENT | MSR_TRANSSHIPMENT_PLANT | XFELD | CHAR | 1 | 0 | Transshipment Plant | ||
65 | IM_INSMK | MSR_INSMK_SPECIFIED | INSMK | CHAR | 1 | 0 | Target Stock Type for Transfer to Specified Stock | ||
66 | IM_PLANT | MSR_PLANT_SPECIFIED | WERKS | CHAR | 4 | 0 | Target Plant for Transfer to Specified Stock | T001W | |
67 | IM_PLANT_NAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
68 | IM_LGORT | MSR_SLOC_SPECIFIED_INSP | LGORT | CHAR | 4 | 0 | Storage Location for Transfer to Specified Stock | T001L | |
69 | IM_MATERIAL | MSR_MAT_SPECIFIED | MATNR | CHAR | 18 | 0 | Target Material for Transfer to Specified Stock | * | |
70 | IM_MATERIAL_NAME | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
71 | REFUND_CONTROL | MSR_REFUND_CONTROL_INSP | MSR_REFUND_CONTROL_INSP | CHAR | 1 | 0 | Refund Control During Inspection | ||
72 | REFUND_CODE | MSR_INSP_REFUND_CODE | MSR_RETURNS_REFUND_CODE | CHAR | 3 | 0 | Returns Refund Code | ||
73 | REFUND_BLOCK | MSR_REFUND_BLOCK_INSP | XFELD | CHAR | 1 | 0 | Refunding After Receipt of Credit Memo | ||
74 | BSGRU | BSGRU | BSGRU | CHAR | 3 | 0 | Reason for Ordering | TBSG | |
75 | DECISION_LEVEL | MSR_INSP_DECISION_LEVEL | MSR_INSP_DECISION_LEVEL | CHAR | 1 | 0 | Decision Level | ||
76 | PUBLSTATUS | MSR_INSP_PUBLSTATUS | MSR_INSP_PUBLSTATUS | CHAR | 1 | 0 | Publishing Status | ||
77 | CREATED_ON | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
78 | TZONE | TZNZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | * | |
79 | CREATED_ON_DATE | DATE | CHAR8 | CHAR | 8 | 0 | Date in CHAR format | ||
80 | CREATED_ON_TIME | TIME | CHAR6 | CHAR | 6 | 0 | Time in CHAR Format | ||
81 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
82 | COMMENT_TEXT | MSR_INSP_COMMENT | TEXT132 | CHAR | 132 | 0 | Inspection Comment Line | ||
83 | COMMENT_AVAILABLE | MSR_INSP_TEXT_AVAILABLE | FLAG | CHAR | 1 | 0 | Comment Available | ||
84 | ARCHIV_ID | SAEADOKID | SADC40_BL | CHAR | 40 | 0 | SAP ArchiveLink: Doc_ID | ||
85 | AT_CUSTOMER_SITE | MSR_AT_CUSTOMER_SITE | XFELD | CHAR | 1 | 0 | Inspection at Customer Site | ||
86 | LOG_HANDLE | BALLOGHNDL | SYSUUID_22 | CHAR | 22 | 0 | Application Log: Log Handle | ||
87 | FUP_BLOCK | MSR_INSP_FUP_BLOCK | MSR_INSP_FUP_BLOCK | CHAR | 4 | 0 | Block for Follow-Up Activities | MSR_D_FUP_BLOCK | |
88 | FUP_BLOCK_DESC | MSR_INSP_FUP_BLOCK_DESC | MSR_INSP_FUP_BLOCK_DESC | CHAR | 60 | 0 | Description of Follow-Up Activity Block | ||
89 | FU_CODE_ERP | MSR_FU_CODE_ERP | MSR_FU_CODE_ERP | CHAR | 1 | 0 | Maintenance of Follow-Up Code in ERP | ||
90 | INSP_STATUS_ITEM | MSR_INSP_INSP_STATUS | MSR_INSP_INSP_STATUS | CHAR | 1 | 0 | Inspection Status | ||
91 | LFU_STATUS_ITEM | MSR_INSP_LDM_STATUS | MSR_INSP_LDM_STATUS | CHAR | 1 | 0 | Logistical Follow-Up Status | ||
92 | SPLIT_GROUP | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
93 | INSP_IN_RO | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
94 | DB_DELFLAG | /SPE/LSKENZ | /SPE/LSKENZ | CHAR | 1 | 0 | Inspection Outcome: Delete flag | ||
95 | DELETED | MSR_INSP_DELETE | FLAG | CHAR | 1 | 0 | Deleted | ||
96 | CANCELLED | MSR_INSP_CANCELLED | FLAG | CHAR | 1 | 0 | Inspection Cancelled | ||
97 | CHANGEABLE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
98 | UPDKZ | MSR_INSP_UPDKZ | MSR_INSP_UPDKZ | CHAR | 1 | 0 | Update Update | ||
99 | .INCLUDE | 0 | 0 | Inspection Replacement Material | |||||
100 | .INCLUDE | 0 | 0 | Replacement Material | |||||
101 | .INCLUDE | 0 | 0 | Replacement Material | |||||
102 | REPLACE_MATNR | MSR_REPLACE_MATNR | MATNR | CHAR | 18 | 0 | Replacement Material | MARA | |
103 | REPLACE_QTY | MSR_REPLACE_QTY | MENG15 | QUAN | 15 | 3 | Replacement Material Quantity | ||
104 | REPLACE_UNIT | MSR_REPLACE_UNIT | MEINS | UNIT | 3 | 0 | Replacement Material Unit of Measure | T006 | |
105 | POSGUID | POSGUID | SYSUUID_22 | CHAR | 22 | 0 | ATP: Encryption of DELNR and DELPS | ||
106 | REP_AVAIL_DATE | MSR_REPLACE_AVAILABILITY_DATE | DATS | DATS | 8 | 0 | Replacement Material Availability Date | ||
107 | REP_AVAIL_QTY | MSR_REPLACE_AVAILABILITY_QTY | MENG15 | QUAN | 15 | 3 | Available Quantity for Replacement Material | ||
108 | .INCLUDE | 0 | 0 | Replacement Material Financial Fields | |||||
109 | REPLACED_QTY | MSR_REPLACED_QTY | MENG15 | QUAN | 15 | 3 | Replaced Quantity if Compensation by Replacement Material | ||
110 | REPLACED_UNIT | MSR_REPLACED_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure for Replaced Quantity in Customer Returns | T006 | |
111 | CMR_QTY | MSR_CMR_QTY | MENG15 | QUAN | 15 | 3 | Credit Memo Request Quantity | ||
112 | CMR_UNIT | MSR_CMR_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure for Credit Memo Request Quantity | T006 | |
113 | ABGRU | ABGRU_VA | ABGRU_VA | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | TVAG | |
114 | .INCLUDE | 0 | 0 | Additional Data for Replacement Material handling | |||||
115 | NFU_CODE | MSR_NFU_CODE | MSR_FU_CODE | CHAR | 4 | 0 | Default for Next Follow-Up Activity in Material Inspection | MSR_I_CODE | |
116 | REFUND_TYPE | MSR_REFUND_TYPE | MSR_REFUND_TYPE | CHAR | 1 | 0 | Refund Type | ||
117 | PAYING_PLANT | MSR_REPLACE_PLANT | WERKS | CHAR | 4 | 0 | Supplying Plant for Replacement Material | * | |
118 | PRE_REFUND | MSR_PRELIMINARY_REFUND | XFELD | CHAR | 1 | 0 | Preliminary Refund Determined | ||
119 | .INCLUDE | 0 | 0 | Additional Data for Replacement Material handling | |||||
120 | REPLACE_RELEASED | MSR_REPLACEMENT_RELEASED | XFELD | CHAR | 1 | 0 | Release Subsequent Delivery Free of Charge | ||
121 | REFUND_RELEASED | MSR_REFUNDING_RELEASED | XFELD | CHAR | 1 | 0 | Release Credit Memo Request | ||
122 | REPLACE_REQUEST | MSR_REPLACEMENT_REQUESTED | XFELD | CHAR | 1 | 0 | Replacement Material from Vendor Requested | ||
123 | REPLACE_MATNRTXT | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
124 | REPLACEMENT_STATUS | MSR_REPLACEMENT_STATUS | MSR_INSP_LDM_STATUS | CHAR | 1 | 0 | Replacement Status UI | ||
125 | REFUNDING_STATUS | MSR_REFUNDING_STATUS | MSR_INSP_LDM_STATUS | CHAR | 1 | 0 | Refunding Status UI | ||
126 | ATP_STATUS | MSR_ATP_STATUS | MSR_ATP_STATUS | CHAR | 1 | 0 | ATP Status | ||
127 | PAYING_PLANT_TXT | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
128 | .INCLUDE | 0 | 0 | Customer Inspection | |||||
129 | CUST_INSP_CODE | MSR_CUST_INSP_CODE | QCODE | CHAR | 4 | 0 | Customer Inspection Code | * | |
130 | CUST_INSP_COMM | MSR_CUST_INSP_COMMENT | TEXT132 | CHAR | 132 | 0 | Customer Inspection Comment | ||
131 | CUST_COMMENT_AVAILABLE | MSR_INSP_TEXT_AVAILABLE | FLAG | CHAR | 1 | 0 | Comment Available |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MSR_S_INSP_ITEM | ABGRU | TVAG | ABGRU | |||
2 | MSR_S_INSP_ITEM | BSGRU | TBSG | BSGRU | |||
3 | MSR_S_INSP_ITEM | CMR_UNIT | T006 | MSEHI | |||
4 | MSR_S_INSP_ITEM | FUP_BLOCK | MSR_D_FUP_BLOCK | FUP_BLOCK | |||
5 | MSR_S_INSP_ITEM | IM_LGORT | T001L | LGORT | |||
6 | MSR_S_INSP_ITEM | IM_PLANT | T001W | WERKS | |||
7 | MSR_S_INSP_ITEM | NEXT_PLANT | T001W | WERKS | |||
8 | MSR_S_INSP_ITEM | NFU_CODE | MSR_I_CODE | FU_CODE | |||
9 | MSR_S_INSP_ITEM | REPLACED_UNIT | T006 | MSEHI | |||
10 | MSR_S_INSP_ITEM | REPLACE_MATNR | MARA | MATNR | |||
11 | MSR_S_INSP_ITEM | REPLACE_UNIT | T006 | MSEHI | |||
12 | MSR_S_INSP_ITEM | SUPPLY_PLANT | T001W | WERKS | |||
13 | MSR_S_INSP_ITEM | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 604 |