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

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
Production Planning and Control :: Production Planning for Process Industries :: Process Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0POC_DB_C_SERVICE62Domain Model: Service Operation CollectionProcess Management
SQL:  selectupdate insert create

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

SELECT MANDT, VALUE_OID, O_OPERATION_CID, O_OPERATION_OID, SERVICE, DOCID FROM POC_DB_C_SERVICE
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2VALUE_OIDGlobally Unique Identifiervarbinary160
3O_OPERATION_CIDGlobally Unique Identifiervarbinary160
4O_OPERATION_OIDGlobally Unique Identifiervarbinary160
5SERVICEDomain Model: Service Type of an Operationchar10 Allow NULL? 
6DOCIDDomain Model: Document Identifiernvarchar180 Allow NULL? 
NamePrimaryUniqueTypeColumns
POC_DB_C_SERVICE00NoNoNONCLUSTEREDDOCID
POC_DB_C_SERVICE~0YesYesCLUSTEREDO_OPERATION_OID, O_OPERATION_CID, VALUE_OID, MANDT