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
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
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
H Credit
S Debit
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