1. Home
  2. Resources
  3. SAP Tables
  4. FRE_MD_ART_SITE_STY - Article Site Combinations

SAP Table FRE_MD_ART_SITE_STY

Article Site Combinations

FRE_MD_ART_SITE_STY (Article Site Combinations) 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 FRE_MD_ART_SITE_STY to other SAP tables.

FRE_MD_ART_SITE_STY table fields

Field Data element Checktable Datatype Length Decimals
FUNCTION F&R Function code FRE_BIF_FUNCTION CHAR 1 0
I Insert
D Delete
U Update
MATNR Article / Material Number in F&R FRE_MATNR CHAR 40 0
LOCNO Location number FRE_LOCNO CHAR 20 0
LOCTYPE Location type FRE_LOCTYPE CHAR 4 0
KEY_TST UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) FRE_TST_LONG DEC 21 7
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
BWSCL Source of Supply BWSCL CHAR 1 0
MAABC ABC Indicator MAABC CHAR 1 0
PLANNER_PUR MRP Controller (Materials Planner) DISPO CHAR 3 0
CONSREFMATNR F&R Product Number of the Reference Product for Consumption FRE_CONSREFMATNR CHAR 40 0
CONSREFMATTYPE F&R Product Type for PRODUCT Interface FRE_PROD_TYPE CHAR 2 0
01 Article
02 Merchandize Category
03 Merchandize Category Hierarchy
04 Article Hierarchy
05 Reference
99 Article-Hierarchy-ID
CONSREFLOCNO F&R Consumption Reference: Location Number FRE_CONSREFLOCNO CHAR 20 0
CONSREFLOCTYPE Location type FRE_LOCTYPE CHAR 4 0
CONSREFFAC F&R Consumption Reference: Factor FRE_CONSREFFAC DEC 13 3
CONSREFVALTO F&R Consumption Reference: Valid to FRE_CONSREFVALTO DEC 15 0
RPSTATUS F&R Replenishment type of the Product FRE_RPSTATUS CHAR 2 0
00 Inactive for Automatic Replenishment
01 Inactive for Automatic Replenishment Due to Cross Docking
09 Auto. Replen. w. Manual Target Stock + Manual Reorder Point
10 Auto. Replen. w. Manual Target Stock + Dynamic Reorder Point
11 Automatic Replen. w. Dyn. Target Stock + Dyn. Reorder Point
12 Manual Replenishment Only
13 Replenishment is Manual (But Automatic Also Possible)
MEASGRBUY Unit of Measure Group MEGRU CHAR 4 0
SALESPRICE FRE Sales Price FRE_SALESPRICE DEC 13 3
CURRENCY Currency Key CURRENCY CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
MAXSTOCK FRE Maximum Stock Quantity FRE_MAXSTOCK QUAN 19 6
MINSTOCK FRE Minimum Stock Quantity FRE_MINSTOCK QUAN 19 6
TARGETSTOCK FRE Target Stock FRE_TARGETSTOCK QUAN 19 6
REORD FRE Reorder Point FRE_REORD QUAN 19 6
PURTIME FRE Purchasing Department Processing Time in Hours FRE_PURTIME DEC 11 0
RELTIME FRE Order Release Time FRE_RELTIME DEC 11 0
GRPRT FRE Time Needed for GR in hours FRE_GRTIME DEC 11 0
SHLFLFEREQ_MIN FRE Required Minimum Shelf Life FRE_SHELF_LIFE_DUR DEC 11 0
SAISON FRE Flag Indicating Seansonal Products FRE_SEASON CHAR 1 0
X Yes
NULL No
LISTINGSTATUS F&R Listing Status FRE_LISTINGSTATUS NUMC 1 0
0 No GR possible
1 GR possible
PROFCST FRE Forecast Profile for FRP Module FRE_PROFCST CHAR 10 0
PROREPL F&R Replenishment Profile for FRP Module FRE_PROREPL CHAR 10 0
PROEXCP F&R Exception Profile for FRP Module FRE_PROEXCP CHAR 10 0
PROCL F&R Capital Lockup Profile FRE_PROCL CHAR 10 0
LEADTIMESHIFT F&R Lead Time Shift FRE_LEADTIMESHIFT NUMC 2 0
STOCKMULTIPLE F&R Stock Multiple FRE_STOCKMULTIPLE QUAN 19 6
FCHOROP Operational Forecast Horizon (in weeks) FRE_FCHOROP NUMC 3 0
FCOUTDAY Output Daily Forecast (in weeks) FRE_FCOUTDAY NUMC 3 0
FCOUTWEEK Output Weekly Forecast (in weeks) FRE_FCOUTWEEK NUMC 3 0
PROSL Service Level Profile FRE_PROSL CHAR 10 0
MINTROC Minimum Target Range of Coverage FRE_MINTROC NUMC 3 0
MAXTROC Maximum Target Range of Coverage FRE_MAXTROC NUMC 3 0
TEMPRPBLOCK Temporary replenishment blocking FRE_TEMPRBLOCK CHAR 2 0
INIT_BUY_CHECK Initial buy check FRE_INIT_BUY_CHECK CHAR 1 0
X Initial buy by SAP F&R
NULL No initial buy by SAP F&R
PROFREQ Character Field Length = 10 CHAR10 CHAR 10 0
NO_CONS No Consumption Data from SAP BI to be loaded FRE_NO_CONS CHAR 1 0
NULL Cons.Data from BI to be loaded if new Article-Site-Combin.
X No Consumption Data from SAP BI to be loaded
SELLCLASS Selling Class FRE_SELLCLASS NUMC 1 0
0 Ultra Slow Sellers 1
1 Ultra Slow Sellers 2
2 Slow Sellers 1
3 Slow Sellers 2
4 Fast Sellers 1
5 Fast Sellers 2
BALGR Character Field Length = 10 CHAR10 CHAR 10 0
PROCALIB Character Field Length = 10 CHAR10 CHAR 10 0
OFCHOR Numc3, internal use NUMC3 NUMC 3 0
PROOFFRQ Character Field Length = 10 CHAR10 CHAR 10 0
PROPREALLOC Character Field Length = 10 CHAR10 CHAR 10 0
REF_ID Package Identifier FRE_PACKAGE_ID CHAR 35 0