Tip para SAP BO: Lista de objetos en SAP Business One

A veces, necesitará crear consultas simples para obtener una vista previa y analizar datos, puede usar la función «Generador de consultas» o crear alguna validación con SP Transaction Notification, crear otra SP Post Notification en su base de datos, con consultas personalizadas que se crearon directamente en Estudio de gestión SQL / estudio HANA. Pero no puedes recordar todos los nombres de las tablas en SAP Business One, así que esta lista de objetos con Primary Key te ayudará.

Lista de objetos en SAP Business One

TABLA	DESCRIPTION	DESCRIPCIÓN	PRIMARY KEY	OBJECT TYPE
OACT	G/L Accounts	Plan de cuentas	AcctCode	1
OCRD	Business Partner	Socios de negocios	CardCode	2
ODSC	Bank Codes	Códigos de bancos	AbsEntry	3
OITM	Items	Artículos	ItemCode	4
OVTG	Tax Definition	Definición de impuestos	Code	5
OPLN	Price Lists	Listas de precios	ListNum	6
OSPP	Special Prices	Precios especiales	CardCode, ItemCode	7
OITG	Item Properties	Propiedades de artículos	ItmsTypCod	8
ORTM	Rate Differences		LineNum, IsSysCurr	9
OCRG	Card Groups	Grupos de tarjetas	GroupCode	10
OCPR	Contact Persons	Personas de contacto	CntctCode	11
OUSR	Users	Usuarios	USERID	12
OINV	A/R Invoice		DocEntry	13
ORIN	A/R Credit Memo		DocEntry	14
ODLN	Delivery	Entregas	DocEntry	15
ORDN	Returns	Devoluciones	DocEntry	16
ORDR	Sales Order	Ordenes de venta / Pedidos	DocEntry	17
OPCH	A/P Invoice		DocEntry	18
ORPC	A/P Credit Memo		DocEntry	19
OPDN	Goods Receipt PO		DocEntry	20
ORPD	Goods Return		DocEntry	21
OPOR	Purchase Order	Ordenes de compra	DocEntry	22
OQUT	Sales Quotation	Cotización de venta	DocEntry	23
ORCT	Incoming Payment	Pagos recibidos	DocEntry	24
ODPS	Deposit	Depositos	DeposId	25
OMTH	Reconciliation History	Historia de reconciliaciones	MthAcctCod, IsInternal, MatchNum	26
OCHH	Check Register	Registro de cheques	CheckKey	27
OBTF	Journal Voucher Entry		BatchNum, TransId	28
OBTD	Journal Vouchers List		BatchNum	29
OJDT	Journal Entry	Registro de diario	TransId	30
OITW	Items – Warehouse	Artículos – Bodegas	ItemCode, WhsCode	31
OADP	Print Preferences	Preferencias de impresión	PrintId	32
OCLG	Activities	Actividades	ClgCode	33
ORCR	Recurring Postings		RcurCode, Instance	34
ONNM	Document Numbering	Numeración de documentos	ObjectCode, DocSubType	35
OCRC	Credit Cards	Tarjetas de crédito	CreditCard	36
OCRN	Currency Codes	Códigos de moneda	CurrCode	37
OIDX	CPI Codes		IdexCode	38
OADM	Administration	Administración	Code	39
OCTG	Payment Terms	Terminos de pago	GroupNum	40
OPRF	Preferences	Preferencias	FormNumber, UserSign	41
OBNK	External Bank Statement Received		AcctCode, Sequence	42
OMRC	Manufacturers	Fabricantes	FirmCode	43
OCQG	Card Properties	Propiedades de tarjeta	GroupCode	44
OTRC	Journal Entry Codes	Códigos de registro de diario	TrnsCode	45
OVPM	Outgoing Payments	Pagos efectuados	DocEntry	46
OSRL	Serial Numbers	Números de serie	ItemCode, SerialNum	47
OALC	Loading Expenses		AlcCode	48
OSHP	Delivery Types	Tipos de entrega	TrnspCode	49
OLGT	Length Units	Unidades de longitud	UnitCode	50
OWGT	Weight Units	Unidades de peso	UnitCode	51
OITB	Item Groups	Grupos de artículos	ItmsGrpCod	52
OSLP	Sales Employee	Empleado de ventas	SlpCode	53
OFLT	Report – Selection Criteria		FormNum, UserSign, FilterName	54
OTRT	Posting Templates		TrtCode	55
OARG	Customs Groups		CstGrpCode	56
OCHO	Checks for Payment	Cheques para el pago	CheckKey	57
OINM	Whse Journal		TransNum, Instance	58
OIGN	Goods Receipt		DocEntry	59
OIGE	Goods Issue		DocEntry	60
OPRC	Cost Center	Centros de costo	PrcCode	61
OOCR	Cost Rate	Tasa de costo	OcrCode	62
OPRJ	Project Codes	Códigos de proyecto	PrjCode	63
OWHS	Warehouses	Almacenes / Bodegas	WhsCode	64
OCOG	Commission Groups	Grupos de comisión	GroupCode	65
OITT	Product Tree	Árbol de productos	Code	66
OWTR	Inventory Transfer	Transferencia de inventario	DocEntry	67
OWKO	Production Instructions	Instrucciones de producción	OrderNum	68
OIPF	Landed Costs		DocEntry	69
OCRP	Payment Methods		CrTypeCode	70
OCDT	Credit Card Payment	Pagos con Tarjeta de crédito	Code	71
OCRH	Credit Card Management	Administración de Tarjeta de crédito	AbsId, Instance	72
OSCN	Customer/Vendor Cat. No.		ItemCode, CardCode, Substitute	73
OCRV	Credit Payments		AbsId, PayId, Instance	74
ORTT	CPI and FC Rates		RateDate, Currency	75
ODPT	Postdated Deposit		DeposId	76
OBGT	Budget	Presupuesto	AbsId	77
OBGD	Budget Cost Assess. Mthd		BgdCode	78
ORCN	Retail Chains		ChainCode	79
OALT	Alerts Template	Plantillas de alertas	Code	80
OALR	Alerts	Alertas	Code	81
OAIB	Received Alerts	Alertas recibidas	AlertCode, UserSign	82
OAOB	Message Sent	Mensajes enviados	AlertCode, UserSign	83
OCLS	Activity Subjects	Temas de actividades	Code	84
OSPG	Special Prices for Groups		CardCode, ObjType, ObjKey	85
SPRG	Application Start		LineNum, UserCode	86
OMLS	Distribution List	Listas de distribución	Code	87
OENT	Shipping Types	Tipos de envío	DocEntry	88
OSAL	Outgoing	Salidas	DocEntry	89
OTRA	Transition	Transiciones	DocEntry	90
OBGS	Budget Scenario	Escenario de presupuesto	AbsId	91
OIRT	Interest Prices		Numerator	92
OUDG	User Defaults	Usuario defaults	Code	93
OSRI	Serial Numbers for Items	Números de serie para artículos	ItemCode, SysSerial	94
OFRT	Financial Report Templates	Plantillas de reportes financieros	AbsId	95
OFRC	Financial Report Categories	Categorias de reportes financieros	TemplateId, CatId	96
OOPR	Opportunity	Oportunidades	OpprId	97
OOIN	Interest	Interés	Num	98
OOIR	Interest Level	Nivel de interés	Num	99
OOSR	Information Source	Fuentes de información	Num	100
OOST	Opportunity Stage	Escenario de oportunidad	Num	101
OOFR	Defect Cause		Num	102
OCLT	Activity Types	Tipos de actividad	Code	103
OCLO	Meetings Location		Code	104
OISR	Service Calls		RequestNum	105
OIBT	Batch No. for Item		ItemCode, BatchNum, WhsCode	106
OALI	Alternative Items 2		OrigItem, AltItem	107
OPRT	Partners		PrtId	108
OCMT	Competitors		CompetId	109
OUVV	User Validations		IndexID, LineNum	110
OFPR	Posting Period		AbsEntry	111
ODRF	Drafts		DocEntry	112
OSRD	Batches and Serial Numbers		ItemCode, DocType, DocEntry, DocLineNum	113
OUDC	User Display Cat.		CodeID	114
OPVL	Lender – Pelecard		Code	115
ODDT	Withholding Tax Deduction Hierarchy		Numerator	116
ODDG	Withholding Tax Deduction Groups		Numerator	117
OUBR	Branches		Code	118
OUDP	Departments		Code	119
OWST	Confirmation Level		WstCode	120
OWTM	Approval Templates		WtmCode	121
OWDD	Docs. for Confirmation		WddCode	122
OCHD	Checks for Payment Drafts		CheckKey	123
CINF	Company Info		Version	124
OEXD	Freight Setup		ExpnsCode	125
OSTA	Sales Tax Authorities		Code, Type	126
OSTT	Sales Tax Authorities Type		AbsId	127
OSTC	Sales Tax Codes		Code	128
OCRY	Countries		Code	129
OCST	States		Country, Code	130
OADF	Address Formats		Code	131
OCIN	A/R Correction Invoice		DocEntry	132
OCDC	Cash Discount		Code	133
OQCN	Query Catagories		CategoryId	134
OIND	Triangular Deal		Code	135
ODMW	Data Migration		Code	136
OCSTN	Workstation ID		Code	137
OIDC	Indicator		Code	138
OGSP	Goods Shipment		Code	139
OPDF	Payment Draft		DocEntry	140
OQWZ	Query Wizard		Code	141
OASG	Account Segmentation		AbsId	142
OASC	Account Segmentation Categories		SegmentId, Code	143
OLCT	Location		Code	144
OTNN	1099 Forms		FormCode	145
OCYC	Cycle		Code	146
OPYM	Payment Methods for Payment Wizard		PayMethCod	147
OTOB	1099 Opening Balance		VendCode, Form1099, Box1099	148
ORIT	Dunning Interest Rate		Code	149
OBPP	BP Priorities		PrioCode	150
ODUN	Dunning Letters		LineNum	151
CUFD	User Fields – Description		TableID, FieldID	152
OUTB	User Tables		TableName	153
OCUMI	My Menu Items		UserSign , Id_	154
OPYD	Payment Run		Code	155
OPKL	Pick List		AbsEntry	156
OPWZ	Payment Wizard		IdNumber	157
OPEX	Payment Results Table		AbsEntry	158
OPYB	Payment Block		AbsEntry	159
OUQR	Queries		IntrnalKey, Qcategory	160
OCBI	Central Bank Ind.		Indicator	161
OMRV	Inventory Revaluation		DocEntry	162
OCPI	A/P Correction Invoice		DocEntry	163
OCPV	A/P Correction Invoice Reversal		DocEntry	164
OCSI	A/R Correction Invoice		DocEntry	165
OCSV	A/R Correction Invoice Reversal		DocEntry	166
OSCS	Service Call Statuses		statusID	167
OSCT	Service Call Types		callTypeID	168
OSCP	Service Call Problem Types		prblmTypID	169
OCTT	Contract Template		TmpltName	170
OHEM	Employees		empID	171
OHTY	Employee Types		typeID	172
OHST	Employee Status		statusID	173
OHTR	Termination Reason		reasonID	174
OHED	Education Types		edType	175
OINS	Customer Equipment Card		insID	176
OAGP	Agent Name		AgentCode	177
OWHT	Withholding Tax		WTCode	178
ORFL	Already Displayed 347, 349 and WTax Reports		DocEntry, ReportType, DocType, LineNum, TaxCode, OrdinalNum	179
OVTR	Tax Report		AbsEntry	180
OBOE	Bill of Exchange for Payment		BoeKey	181
OBOT	Bill Of Exchang Transaction		AbsEntry	182
OFRM	File Format		AbsEntry	183
OPID	Period Indicator		Indicator	184
ODOR	Doubtful Debts		AbsEntry	185
OHLD	Holiday Table		HldCode	186
OCRB	BP – Bank Account		Country, BankCode, Account, CardCode	187
OSST	Service Call Solution Statuses		Number	188
OSLT	Service Call Solutions		SltCode	189
OCTR	Service Contracts		ContractID	190
OSCL	Service Calls		callID	191
OSCO	Service Call Origins		originID	192
OUKD	User Key Description		TableName, KeyId	193
OQUE	Queue		queueID	194
OIWZ	Inflation Wizard		AbsEntry	195
ODUT	Dunning Terms		TermCode	196
ODWZ	Dunning Wizard		WizardId	197
OFCT	Sales Forecast		AbsID	198
OMSN	MRP Scenarios		AbsEntry	199
OTER	Territories		territryID	200
OOND	Industries		IndCode	201
OWOR	Production Order		DocEntry	202
ODPI	A/R Down Payment		DocEntry	203
ODPO	A/P Down Payment		DocEntry	204
OPKG	Package Types		PkgCode	205
OUDO	User-Defined Object		Code	206
ODOW	Data Ownership – Objects		Object, SubObject	207
ODOX	Data Ownership – Exceptions		QueryId, Object, SubObject	208
209
OHPS	Employee Position		posID	210
OHTM	Employee Teams		teamID	211
OORL	Relationships		OrlCode	212
ORCM	Recommendation Data		DocEntry	213
OUPT	User Autorization Tree		AbsId	214
OPDT	Predefined Text		AbsEntry	215
OBOX	Box Definition		BoxCode, ReportType, BosCode	216
OCLA	Activity Status		statusID	217
OCHF	312		ObjName	218
OCSHS	User-Defined Values		IndexID	219
OACP	Periods Category		AbsEntry	220
OATC	Attachments		AbsEntry	221
OGFL	Grid Filter		FormID, GridID, UserCode	222
OLNG	User Language Table		Code	223
OMLT	Multi-Language Translation		TranEntry	224
OAPA3	225
OAPA4	226
OAPA5	227
SDIS	Dynamic Interface (Strings)		FormId, ItemId, ColumnId, Language	229
OSVR	Saved Reconciliations		acctCode	230
DSC1	House Bank Accounts		AbsEntry	231
RDOC	Document		DocCode	232
ODGP	Document Generation Parameter Sets		AbsEntry	233
OMHD	#740		AlertCode	234
OACG	Account Category		AbsId	238
OBCA	Bank Charges Allocation Codes		Code	239
OCFT	Cash Flow Transactions – Rows		CFTId	241
OCFW	Cash Flow Line Item		CFWId	242
OBPL	Business Place		BPLId	247
OJPE	Local Era Calendar		Code	250
ODIM	Cost Accounting Dimension		DimCode	251
OSCD	Service Code Table		AbsEntry	254
OSGP	Service Group for Brazil		AbsEntry	255
OMGP	Material Group		AbsEntry	256
ONCM	NCM Code		AbsEntry	257
OCFP	CFOP for Nota Fiscal		ID	258
OTSC	CST Code for Nota Fiscal		ID	259
OUSG	Usage of Nota Fiscal		ID	260
OCDP	Closing Date Procedure		ClsDateNum	261
ONFN	Nota Fiscal Numbering		ObjectCode, DocSubType	263
ONFT	Nota Fiscal Tax Category (Brazil)		AbsId	264
OCNT	Counties		AbsId	265
OTCD	Tax Code Determination		AbsId	266
ODTY	BoE Document Type		AbsEntry	267
OPTF	BoE Portfolio		AbsEntry	268
OIST	BoE Instruction		AbsEntry	269
OTPS	Tax Parameter		AbsId	271
OTFC	Tax Type Combination		AbsId	275
OFML	Tax Formula Master Table		AbsId	276
OCNA	CNAE Code		AbsId	278
OTSI	Sales Tax Invoice		DocEntry	280
OTPI	Purchase Tax Invoice		DocEntry	281
OCCD	Cargo Customs Declaration Numbers		CCDNum	283
ORSC	Resources		ResCode	290
ORSG	Resource Properties		ResTypCod	291
ORSB	ResGrpCod		ResGrpCod	292
RecordSet	300
Bridge	305
OITR	Internal Reconciliation		ReconNum	321
OPOS	POS Master Data		EquipNo	541
ODRF	Stock Transfer Draft		DocEntry	1179
OMSG	Messaging Service Settings		USERID	10000105
OBTN	Batch Numbers Master Data		AbsEntry	10000044
OSRN	Serial Numbers Master Data	Datos maestros de números de serie	AbsEntry	10000045
OIVK	IVL Vs OINM Keys		TransSeq	10000062
OIQR	Inventory Posting	Publicación de inventario	DocEntry	10000071
OFYM	Financial Year Master	Maestro del ejercicio financiero	AbsId	10000073
OSEC	Sections	Secciones	AbsId	10000074
OCSN	Certificate Series		AbsId	10000075
ONOA	Nature of Assessee		AbsId	10000077
RTYP	Document Type List	Lista de tipo de documento	CODE	10000196
OUGP	UoM Group		UgpEntry	10000197
OUOM	UoM Master Data		UomEntry	10000199
OBFC	Bin Field Configuration		AbsEntry	10000203
OBAT	Bin Location Attribute		AbsEntry	10000204
OBSL	Warehouse Sublevel		AbsEntry	10000205
OBIN	Bin Location		AbsEntry	10000206
ODNF	DNF Code		AbsEntry	140000041
OUGR	Authorization Group	Grupo de autorización	GroupId	231000000
OEGP	E-Mail Group	Grupo de email	EmlGrpCode	234000004
OGPC	Government Payment Code		AbsId	243000001
OIQI	Inventory Opening Balance		DocEntry	310000001
OBTW	Batch Attributes in Location		AbsEntry	310000008
OLLF	Legal List Format		AbsEntry	410000005
OHET	Object: HR Employee Transfer		TransferID	480000001
OTCX	Tax Code Determination	Determinación de código de impuesto	DocEntry	540000005
OPQT	Purchase Quotation	Cotización de compra	DocEntry	540000006
ORCP	Recurring Transaction Template	Plantilla de transacción recurrente	AbsEntry	540000040
OCCT	Cost Center Type	Tipo de centro de costos	CctCode	540000042
OACR	Accrual Type		Code	540000048
ONFM	Nota Fiscal Model	Modelo de nota fiscal	AbsEntry	540000056
OBFI	Brazil Fuel Indexer		ID	540000067
OBBI	Brazil Beverage Indexer		ID	540000068
OCPT	Cockpit Main Table		AbsEntry	1210000000
OWTQ	Inventory Transfer Request		DocEntry	1250000001
OOAT	Blanket Agreement		AbsID	1250000025
OKPI	Key Performance Indicator Package		AbsEntry	1320000000
OTGG	Target Group	Grupo objetivo	TargetCode	1320000002
OCPN	Campaign	Campañas	CpnNo	1320000012
OROC	Retorno Operation Codes		AbsEntry	1320000028
OPSC	Product Source Code		Code	1320000039
ODTP	Fixed Assets Depreciation Types		Code	1470000000
OADT	Fixed Assets Account Determination		Code	1470000002
ODPA	Fixed Asset Depreciation Areas		Code	1470000003
ODPP	Depreciation Type Pools		Code	1470000004
OACS	Asset Classes		Code	1470000032
OAGS	Asset Groups		Code	1470000046
ODMC	G/L Account Determination Criteria – Inventory		DmcId	1470000048
OACQ	Capitalization	Capitalización	DocEntry	1470000049
OGAR	G/L Account Advanced Rules		AbsEntry	1470000057
OACD	Credit Memo	Nota de crédito	DocEntry	1470000060
OBCD	Bar Code Master Data		BcdEntry	1470000062
OINC	Inventory Counting	Conteo de inventario	DocEntry	1470000065
OEDG	Discount Groups	Grupo de descuento	AbsEntry	1470000077
OCCS	Cycle Count Determination		WhsCode	1470000092
OPRQ	Purchase Request	Solicitud de compra	DocEntry	1470000113
OWLS	Workflow – Task Details	Workflow – Detalles de tarea	TaskID	1620000000