/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".

Fields for table /SAPAPO/SORSPLSR

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
SRPLIDSurplus Quantity IDX/SAPAPO/SOR_SRPLIDRAW16
REPORTIDReporting IDX/SAPAPO/SOR_REPORTING_IDCHAR2
ORDIDTDL: Order GUID/SCMB/TDL_ORDIDRAW16
ORDNOOrder Number/SAPAPO/ORDNOCHAR24
VRSIOIDPlanning Version GUID/SCMB/MDL_VRSIOIDRAW16
VRSIOEXPlanning Version/SCMB/MDL_VRSIOEXCHAR20
MATIDInternal Key for Product/SCMB/MDL_MATIDRAW16
MATNRProduct Number/SCMB/MDL_MATNRCHAR80
LOCIDLocation GUID/SCMB/MDL_LOCIDRAW16
LOCNOLocation Number/SCMB/MDL_LOCNOCHAR40
UNAMEUser NameUNAMECHAR24
CREATEDATETime Stamp/SCMB/TSTDEC8
CHGDATETime Stamp/SCMB/TSTDEC8
DISPOCODESurplus Decision Code/SAPAPO/SOR_DISPOCODECHAR12
RSNCODEReason Code for Surplus Decision/SAPAPO/SOR_REASON_CODECHAR8
SCRAPINDIScrapping Indicator/SAPAPO/SOR_SCRAPINDICHAR2
SRPLSQTYSUGGSuggested Surplus Quantity/SAPAPO/SOR_SURPLUS_QTY_SUGGDEC8
MEINSBase Unit of MeasureMEINSUNIT6
SRPLSVALSUGGValue of Suggested Surplus Quantity/SAPAPO/SOR_SURPLUS_VAL_SUGGDEC8
SRPLSQTYFINFinal Surplus Quantity/SAPAPO/SOR_SURPLUS_QTY_FINALDEC8
SRPLSVALFINValue of Final Surplus Quantity/SAPAPO/SOR_SURPLUS_VAL_FINALDEC8
RETQTYRetention Quantity/SAPAPO/SOR_RETENTION_QTYDEC8
RETVALValue of Retention Quantity/SAPAPO/SOR_RETENTION_VALDEC8
SRPLSQTYGROSSGross Surplus Quantity/SAPAPO/SOR_SURPLUS_QTY_GROSSDEC8
SRPLSVALGROSSValue of Gross Surplus Quantity/SAPAPO/SOR_SURPLUS_VAL_GROSSDEC8
RETQTYREVRetention Quantity (Corrected)/SAPAPO/SOR_RETENTION_QTY_REVDEC8
RETVALREVValue of Corrected Retention Quantity/SAPAPO/SOR_RETENTION_VAL_REVDEC8
BODIDHierarchy ID/SCMB/MDL_HIERARCHY_IDCHAR64
BODNAMEName of a Bill of Distribution/SAPAPO/BODNAMECHAR40
LOCIDENTRYLocation GUID/SCMB/MDL_LOCIDRAW16
LOCNOENTRYEntry Location/SAPAPO/SOR_LOCNO_ENTRYCHAR40
PRDENDDTProduction End Date/SAPAPO/PRD_ENDDTDATS16
REPLINDIReplenishment Indicator/SAPAPO/REPINDICATCHAR4
ONHANDAvailable Stock/SAPAPO/SOR_ON_HAND_QTYDEC8
INVQUALINSPQuality Inspection Stock Quantity/SAPAPO/SOR_INV_QUAL_INSP_QTYDEC8
INVBLOCKEDBlocked Stock Quantity/SAPAPO/SOR_INV_BLOCKED_QTYDEC8
INTRANSITStock in Transit/SAPAPO/SOR_IN_TRANSIT_QTYDEC8
BACKORDERTotal Quantity of Backorders/SAPAPO/SOR_BACKORDER_QTYDEC8
HIST12MTHSDemand of Current and Previous 12 Months/SAPAPO/SOR_HISTDEM_12MTHSDEC8
FCST12MTHSOrder Items of Current and Next 12 Months/SAPAPO/SOR_FCSTDEM_12MTHSDEC8
FCST12MTHSENDemand of Current and Next 12 Months (Order Items)/SAPAPO/SOR_FCSTDEM_12MTHS_ENDEC8
ONRELTOSUPPLTotal Quantity of Fixed Orders/SAPAPO/SOR_ON_RELEASE_TO_SUPPDEC8
RETGRPIDRetention Strategy Group/SAPAPO/SOR_RETGRPIDCHAR20
RETMANDDATEEnd of Mandatory Retention Period (Mandatory Retention Date)/SAPAPO/SOR_RET_PER_MAND_ENDDTDATS16
RETDATEEnd Date of Retention Period (Retention Date)/SAPAPO/SOR_RET_PER_END_DATEDATS16
RETPERREMAINRemaining Retention Period [Years]/SAPAPO/SOR_RET_PER_REMAINDEC2
TPOPThird-Party Order Processing/SAPAPO/TPOPCHAR4
PROCCOSTProcurement Costs for Product/SAPAPO/PROC_COSTDEC7
LOCIDPRIMESUPPLLocation GUID/SCMB/MDL_LOCIDRAW16
LOCNOPRIMESUPPLMain Supplier of Entry Location/SAPAPO/SOR_LOCNO_PRIME_SUPPLCHAR40
FLGSUPERSESSIONIndicator: Supersession/SAPAPO/SOR_SUPERSESSION_FLGCHAR2
PENDINGOBSDATESupersession: Pending Obsolescence Date/SAPAPO/SOR_PENDING_OBS_DATEDATS16
FLGFCSTOUTOFTOLForecast Outside of Approval Limit/SAPAPO/SOR_FCST_OUTOF_TOL_FLGCHAR2
FLGRECALLIndicator: Recall/SAPAPO/SOR_RECALL_FLGCHAR2
FLGFIELDFIXIndicator: Goodwill/SAPAPO/SOR_FIELD_FIX_FLGCHAR2
FLGWARRANTYIndicator: Warranty/SAPAPO/SOR_WARRANTY_FLGCHAR2
FLGPROMOTIONIndicator: Promotion/SAPAPO/SOR_PROMOTION_FLGCHAR2
FLGRDYTOOBSFlag as Obsolete/SAPAPO/SOR_READY_TO_OBSOL_FLGCHAR2
FREEDBINNUMNumber of Freed-Up Bins/SAPAPO/SOR_FREED_BIN_NUMINT44
PALLETSIZEPallet Size/SAPAPO/SOR_PALLET_SIZEINT44
FREEDPALLETNUMNumber of Freed-Up Pallets/SAPAPO/SOR_FREED_PALLET_NUMINT44
GROUPVALUEProduct Group/SAPAPO/GROUPVALUECHAR36
GRPTYPEProduct Group Type/SAPAPO/MATGRPTYPECHAR4
CRE_DATE_CHARField of type DATSDATSDATS16
CHG_DATE_CHARField of type DATSDATSDATS16
Privacy Policy