/SAPAPO/SORSPLSR - Surplus Quantity Reporting
Surplus Quantity Reporting information is stored in SAP table /SAPAPO/SORSPLSR.
It is part of development package /SAPAPO/PSOR in software component SCM-APO-SPP. This development package consists of objects that can be grouped under "Surplus and Obsolescence Service".
It is part of development package /SAPAPO/PSOR in software component SCM-APO-SPP. This development package consists of objects that can be grouped under "Surplus and Obsolescence Service".
Fields for table /SAPAPO/SORSPLSR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| SRPLID | Surplus Quantity ID | X | /SAPAPO/SOR_SRPLID | RAW | 16 | |
| REPORTID | Reporting ID | X | /SAPAPO/SOR_REPORTING_ID | CHAR | 2 | |
| ORDID | TDL: Order GUID | /SCMB/TDL_ORDID | RAW | 16 | ||
| ORDNO | Order Number | /SAPAPO/ORDNO | CHAR | 24 | ||
| VRSIOID | Planning Version GUID | /SCMB/MDL_VRSIOID | RAW | 16 | ||
| VRSIOEX | Planning Version | /SCMB/MDL_VRSIOEX | CHAR | 20 | ||
| MATID | Internal Key for Product | /SCMB/MDL_MATID | RAW | 16 | ||
| MATNR | Product Number | /SCMB/MDL_MATNR | CHAR | 80 | ||
| LOCID | Location GUID | /SCMB/MDL_LOCID | RAW | 16 | ||
| LOCNO | Location Number | /SCMB/MDL_LOCNO | CHAR | 40 | ||
| UNAME | User Name | UNAME | CHAR | 24 | ||
| CREATEDATE | Time Stamp | /SCMB/TST | DEC | 8 | ||
| CHGDATE | Time Stamp | /SCMB/TST | DEC | 8 | ||
| DISPOCODE | Surplus Decision Code | /SAPAPO/SOR_DISPOCODE | CHAR | 12 | ||
| RSNCODE | Reason Code for Surplus Decision | /SAPAPO/SOR_REASON_CODE | CHAR | 8 | ||
| SCRAPINDI | Scrapping Indicator | /SAPAPO/SOR_SCRAPINDI | CHAR | 2 | ||
| SRPLSQTYSUGG | Suggested Surplus Quantity | /SAPAPO/SOR_SURPLUS_QTY_SUGG | DEC | 8 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 6 | ||
| SRPLSVALSUGG | Value of Suggested Surplus Quantity | /SAPAPO/SOR_SURPLUS_VAL_SUGG | DEC | 8 | ||
| SRPLSQTYFIN | Final Surplus Quantity | /SAPAPO/SOR_SURPLUS_QTY_FINAL | DEC | 8 | ||
| SRPLSVALFIN | Value of Final Surplus Quantity | /SAPAPO/SOR_SURPLUS_VAL_FINAL | DEC | 8 | ||
| RETQTY | Retention Quantity | /SAPAPO/SOR_RETENTION_QTY | DEC | 8 | ||
| RETVAL | Value of Retention Quantity | /SAPAPO/SOR_RETENTION_VAL | DEC | 8 | ||
| SRPLSQTYGROSS | Gross Surplus Quantity | /SAPAPO/SOR_SURPLUS_QTY_GROSS | DEC | 8 | ||
| SRPLSVALGROSS | Value of Gross Surplus Quantity | /SAPAPO/SOR_SURPLUS_VAL_GROSS | DEC | 8 | ||
| RETQTYREV | Retention Quantity (Corrected) | /SAPAPO/SOR_RETENTION_QTY_REV | DEC | 8 | ||
| RETVALREV | Value of Corrected Retention Quantity | /SAPAPO/SOR_RETENTION_VAL_REV | DEC | 8 | ||
| BODID | Hierarchy ID | /SCMB/MDL_HIERARCHY_ID | CHAR | 64 | ||
| BODNAME | Name of a Bill of Distribution | /SAPAPO/BODNAME | CHAR | 40 | ||
| LOCIDENTRY | Location GUID | /SCMB/MDL_LOCID | RAW | 16 | ||
| LOCNOENTRY | Entry Location | /SAPAPO/SOR_LOCNO_ENTRY | CHAR | 40 | ||
| PRDENDDT | Production End Date | /SAPAPO/PRD_ENDDT | DATS | 16 | ||
| REPLINDI | Replenishment Indicator | /SAPAPO/REPINDICAT | CHAR | 4 | ||
| ONHAND | Available Stock | /SAPAPO/SOR_ON_HAND_QTY | DEC | 8 | ||
| INVQUALINSP | Quality Inspection Stock Quantity | /SAPAPO/SOR_INV_QUAL_INSP_QTY | DEC | 8 | ||
| INVBLOCKED | Blocked Stock Quantity | /SAPAPO/SOR_INV_BLOCKED_QTY | DEC | 8 | ||
| INTRANSIT | Stock in Transit | /SAPAPO/SOR_IN_TRANSIT_QTY | DEC | 8 | ||
| BACKORDER | Total Quantity of Backorders | /SAPAPO/SOR_BACKORDER_QTY | DEC | 8 | ||
| HIST12MTHS | Demand of Current and Previous 12 Months | /SAPAPO/SOR_HISTDEM_12MTHS | DEC | 8 | ||
| FCST12MTHS | Order Items of Current and Next 12 Months | /SAPAPO/SOR_FCSTDEM_12MTHS | DEC | 8 | ||
| FCST12MTHSEN | Demand of Current and Next 12 Months (Order Items) | /SAPAPO/SOR_FCSTDEM_12MTHS_EN | DEC | 8 | ||
| ONRELTOSUPPL | Total Quantity of Fixed Orders | /SAPAPO/SOR_ON_RELEASE_TO_SUPP | DEC | 8 | ||
| RETGRPID | Retention Strategy Group | /SAPAPO/SOR_RETGRPID | CHAR | 20 | ||
| RETMANDDATE | End of Mandatory Retention Period (Mandatory Retention Date) | /SAPAPO/SOR_RET_PER_MAND_ENDDT | DATS | 16 | ||
| RETDATE | End Date of Retention Period (Retention Date) | /SAPAPO/SOR_RET_PER_END_DATE | DATS | 16 | ||
| RETPERREMAIN | Remaining Retention Period [Years] | /SAPAPO/SOR_RET_PER_REMAIN | DEC | 2 | ||
| TPOP | Third-Party Order Processing | /SAPAPO/TPOP | CHAR | 4 | ||
| PROCCOST | Procurement Costs for Product | /SAPAPO/PROC_COST | DEC | 7 | ||
| LOCIDPRIMESUPPL | Location GUID | /SCMB/MDL_LOCID | RAW | 16 | ||
| LOCNOPRIMESUPPL | Main Supplier of Entry Location | /SAPAPO/SOR_LOCNO_PRIME_SUPPL | CHAR | 40 | ||
| FLGSUPERSESSION | Indicator: Supersession | /SAPAPO/SOR_SUPERSESSION_FLG | CHAR | 2 | ||
| PENDINGOBSDATE | Supersession: Pending Obsolescence Date | /SAPAPO/SOR_PENDING_OBS_DATE | DATS | 16 | ||
| FLGFCSTOUTOFTOL | Forecast Outside of Approval Limit | /SAPAPO/SOR_FCST_OUTOF_TOL_FLG | CHAR | 2 | ||
| FLGRECALL | Indicator: Recall | /SAPAPO/SOR_RECALL_FLG | CHAR | 2 | ||
| FLGFIELDFIX | Indicator: Goodwill | /SAPAPO/SOR_FIELD_FIX_FLG | CHAR | 2 | ||
| FLGWARRANTY | Indicator: Warranty | /SAPAPO/SOR_WARRANTY_FLG | CHAR | 2 | ||
| FLGPROMOTION | Indicator: Promotion | /SAPAPO/SOR_PROMOTION_FLG | CHAR | 2 | ||
| FLGRDYTOOBS | Flag as Obsolete | /SAPAPO/SOR_READY_TO_OBSOL_FLG | CHAR | 2 | ||
| FREEDBINNUM | Number of Freed-Up Bins | /SAPAPO/SOR_FREED_BIN_NUM | INT4 | 4 | ||
| PALLETSIZE | Pallet Size | /SAPAPO/SOR_PALLET_SIZE | INT4 | 4 | ||
| FREEDPALLETNUM | Number of Freed-Up Pallets | /SAPAPO/SOR_FREED_PALLET_NUM | INT4 | 4 | ||
| GROUPVALUE | Product Group | /SAPAPO/GROUPVALUE | CHAR | 36 | ||
| GRPTYPE | Product Group Type | /SAPAPO/MATGRPTYPE | CHAR | 4 | ||
| CRE_DATE_CHAR | Field of type DATS | DATS | DATS | 16 | ||
| CHG_DATE_CHAR | Field of type DATS | DATS | DATS | 16 |