SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | YIT_O1STP
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription

B1 9.2: Top 10 requests

TableColumnsDescription

B1 8.8: Top 10 requests

TableColumnsDescription
1ERP EHP76.0YIT_O1STP71IDA: Original Table STP
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT KEY_EXT1, KEY_EXT2, KEY_INT1, FLGNUS, FLGNEX, FLGMAN, FLGLCK FROM YIT_O1STP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1KEY_EXT1Clientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2KEY_EXT2Project definition for standard projectnvarchar240CHAR(N' ')No*PS_SPDID Allow NULL? 
3KEY_INT1Current number for standard projectnvarchar80NUMC(N'00000000')No*PS_ISPSP Allow NULL? 
4FLGNUSIDA: Not Used Flagchar10CHAR(N' ')YesYID_FLGNUS Allow NULL? 
5FLGNEXIDA: Not Exist Flagchar10CHAR(N' ')YesYID_FLGNEX Allow NULL? 
6FLGMANIDA: Manual Added Flagchar10CHAR(N' ')YesYID_FLGMAN Allow NULL? 
7FLGLCKIDA: Locked for additional use Flagchar10CHAR(N' ')YesYID_FLGLCK Allow NULL? 
NamePrimaryUniqueTypeColumns
YIT_O1STP~0YesYesCLUSTEREDKEY_EXT1, KEY_EXT2, KEY_INT1

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy