- Home
- Resources
- SAP Tables
- S274 - Do not use!
SAP Table S274
Do not use!
S274 (Do not use!) 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 S274 to other SAP tables.
Source: S274 (Do not use!)
S274 table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
SPTAG |
Period to analyze - current date |
SPTAG |
|
DATS |
|
8 |
0 |
|
WERKS |
Plant |
WERKS_D |
T001W
|
CHAR |
|
4 |
0 |
|
MATNR |
Material Number |
MATNR |
MARA
|
CHAR |
|
18 |
0 |
|
BSTTYP |
Stock categories in the Logistics Information System |
BSTTYP |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Valuated Stock |
K |
Vendor Consignment |
E |
Sales Order Stock |
Q |
Project Stock |
M |
Returnable Transport Packaging |
R |
Blocked Stock Returns |
V |
Consumption |
U |
Non-Valuated Stock |
T |
Issuing Stock in Transit |
B |
Customer Stock |
|
BSTAUS |
Stock Values in the Logistics Information System |
BSTAUS |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not Defined |
A |
Unrestricted Use |
B |
Quality Inspection |
C |
Blocked Stock Returns |
D |
Blocked Stock |
E |
Restricted-Use |
F |
Stock Transfer |
G |
Material Provided By Customer |
H |
Transit |
K |
Customer Consignment, Unrestricted Use |
L |
Customer Consignment in Quality Inspection |
M |
Customer Consignment, Restricted Use |
N |
Customer Returnable Packaging, Unrestricted Use |
O |
Customer Returnable Packaging in Quality Inspection |
P |
Customer Returnable Packaging, Restricted Use |
Q |
Unrestricted-Use Material(s) Provided to Vendor |
R |
Materials Provided to Vendor in Quality Inspection |
S |
Stock of Material Provided to Vendor, Restricted Use |
T |
Tied Empties |
V |
Consumption |
W |
Valuated Goods Receipt Blocked Stock |
U |
Stock in Transfer for Subcontracting (Plant to Plant) |
X |
Stock in Transfer for Customer Consignment (Plant to Plant) |
|
SHKZG |
Debit/Credit Indicator |
SHKZG |
|
CHAR |
|
1 |
0 |
Possible values
|
LIFNR |
Vendor Account Number |
ELIFN |
LFA1
|
CHAR |
|
10 |
0 |
|
PKUNAG |
Sold-to party |
KUNAG |
KNA1
|
CHAR |
|
10 |
0 |
|
LGORT |
Storage Location |
LGORT_D |
T001L
|
CHAR |
|
4 |
0 |
|
CHARG |
Batch Number |
CHARG_D |
MCHA
|
CHAR |
|
10 |
0 |
|
VRSIO |
Version number in the information structure |
VRSIO |
|
CHAR |
|
3 |
0 |
|
SPMON |
Period to analyze - month |
SPMON |
|
NUMC |
|
6 |
0 |
|
SPWOC |
Period to analyze - week |
SPWOC |
|
NUMC |
|
6 |
0 |
|
SPBUP |
Period to analyze - posting period |
SPBUP |
|
NUMC |
|
6 |
0 |
|
SSOUR |
Statistic(s) origin |
SSOUR |
|
CHAR |
|
4 |
0 |
|
PERIV |
Fiscal Year Variant |
PERIV |
|
CHAR |
|
2 |
0 |
|
VWDAT |
Pointer to administrative data |
VWDAT |
|
NUMC |
|
10 |
0 |
|
BASME |
Base Unit of Measure |
MEINS |
T006
|
UNIT |
|
3 |
0 |
|
HWAER |
Local Currency |
HWAER |
TCURC
|
CUKY |
|
5 |
0 |
|
BIWMNG |
RIS/Reporting Server - Transfer base quantity |
MCW_BIWMNG |
|
QUAN |
|
15 |
3 |
|
BIWGEO |
RIS/Reporting Server - Transfer cost price |
MCW_BIWGEO |
|
CURR |
|
19 |
2 |
|
BIWGVO |
RIS/Reporting Server - Transfer retail price |
MCW_BIWGVO |
|
CURR |
|
19 |
2 |
|
BIWGVP |
RIS/Reporting Server - Transfer retail price with tax |
MCW_BIWGVP |
|
CURR |
|
19 |
2 |
|
S274 foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
S274 |
BASME |
S274 |
BASME |
T006 |
Units of Measurement |
MSEHI |
S274 |
BASME |
S274 |
MANDT |
T006 |
Units of Measurement |
MANDT |
S274 |
CHARG |
S274 |
CHARG |
MCHA |
Batches |
CHARG |
S274 |
CHARG |
S274 |
WERKS |
MCHA |
Batches |
WERKS |
S274 |
CHARG |
S274 |
MATNR |
MCHA |
Batches |
MATNR |
S274 |
CHARG |
S274 |
MANDT |
MCHA |
Batches |
MANDT |
S274 |
HWAER |
S274 |
MANDT |
TCURC |
Currency Codes |
MANDT |
S274 |
HWAER |
S274 |
HWAER |
TCURC |
Currency Codes |
WAERS |
S274 |
LGORT |
S274 |
MANDT |
T001L |
Storage Locations |
MANDT |
S274 |
LGORT |
S274 |
LGORT |
T001L |
Storage Locations |
LGORT |
S274 |
LGORT |
S274 |
WERKS |
T001L |
Storage Locations |
WERKS |
S274 |
LIFNR |
S274 |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
S274 |
LIFNR |
S274 |
LIFNR |
LFA1 |
Vendor Master (General Section) |
LIFNR |
S274 |
MANDT |
S274 |
MANDT |
T000 |
Clients |
MANDT |
S274 |
MATNR |
S274 |
MATNR |
MARA |
General Material Data |
MATNR |
S274 |
MATNR |
S274 |
MANDT |
MARA |
General Material Data |
MANDT |
S274 |
PKUNAG |
S274 |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
S274 |
PKUNAG |
S274 |
PKUNAG |
KNA1 |
General Data in Customer Master |
KUNNR |
S274 |
WERKS |
S274 |
WERKS |
T001W |
Plants/Branches |
WERKS |
S274 |
WERKS |
S274 |
MANDT |
T001W |
Plants/Branches |
MANDT |