Cómo SAP asigna el ObjType a los tipos de documento en tablas - Descubre el misterio detrás de los códigos en SAP

Gracias

Si bien no es la solución ideal, se podría crear una Tabla de Usuario.

O también hacer una Vista con los documentos y en este caso agregar el nombre en Inglés y Castellano.

CREATE VIEW VU_DOCUMSAP AS

SELECT '13' as "ObjType", 'AR Invoice' as "ObjNameF", 'Factura Vta' as "ObjName" --From DUMMY

UNION SELECT '14' as "ObjType", 'AR Credit Memo' as "ObjNameF", 'Nota Cred.Vta' as "ObjName" --From DUMMY

UNION SELECT '15' as "ObjType", 'Delivery' as "ObjNameF", 'Remito' as "ObjName" --From DUMMY

UNION SELECT '16' as "ObjType", 'Return' as "ObjNameF", 'Return' as "ObjName" --From DUMMY

UNION SELECT '18' as "ObjType", 'AP Invoice' as "ObjNameF", 'Factura Proveedor' as "ObjName" --From DUMMY

UNION SELECT '19' as "ObjType", 'AP Credit Memo' as "ObjNameF", 'Nota de Crédito Prv.' as "ObjName" --From DUMMY

UNION SELECT '20' as "ObjType", 'Goods Receipt PO' as "ObjNameF", 'Recepción Merc.OC' as "ObjName" --From DUMMY

UNION SELECT '202' as "ObjType", 'Production Order' as "ObjNameF", 'Orden de Producción' as "ObjName" --From DUMMY

UNION SELECT '21' as "ObjType", 'Goods Return' as "ObjNameF", 'Devolución Mercadería' as "ObjName" --From DUMMY

UNION SELECT '22' as "ObjType", 'Purchase Order' as "ObjNameF", 'Orden de Compra' as "ObjName" --From DUMMY

UNION SELECT '24' as "ObjType", 'Incoming Payments' as "ObjNameF", 'Pagos de Clientes' as "ObjName" --From DUMMY

UNION SELECT '30' as "ObjType", 'Journal Entry' as "ObjNameF", 'Registro Diario' as "ObjName" --From DUMMY

UNION SELECT '46' as "ObjType", 'Outgoing Payments' as "ObjNameF", 'Pagos a Prv.' as "ObjName" --From DUMMY

UNION SELECT '58' as "ObjType", 'Stock Posting' as "ObjNameF", 'Stock Posting' as "ObjName" --From DUMMY

UNION SELECT '59' as "ObjType", 'Goods Receipt/Receipt from production' as "ObjNameF", 'Recep.Merc./Recep.Merc.de Prod.' as "ObjName" --From DUMMY

UNION SELECT '60' as "ObjType", 'Goods Issue/Issue from Production' as "ObjNameF", 'Salida Merc./Salida Merc. de Prod.' as "ObjName" --From DUMMY

UNION SELECT '67' as "ObjType", 'InventoryTransfer' as "ObjNameF", 'Transf.Inventario' as "ObjName" --From DUMMY

UNION SELECT '69' as "ObjType", 'Landed Costs' as "ObjNameF", 'Landed Costs' as "ObjName" --From DUMMY

UNION SELECT '162' as "ObjType", 'Inventory Revaluation' as "ObjNameF", 'Revalución de Inventario' as "ObjName" --From DUMMY

UNION SELECT '140000009' as "ObjType", 'Outgoing Excise Invoice' as "ObjNameF", 'Impuestos Salientes de Factura' as "ObjName" --From DUMMY

UNION SELECT '140000010' as "ObjType", 'Incoming Excise Invoice' as "ObjNameF", 'Impuestos Entrantes de Factura' as "ObjName" --From DUMMY

El --From DUMMY es para que funcione en HANA sacándole el --

Espero que ayude.

Saludos.

Hola.

Aquí van algunos:

JDT1 - Detalle Diario Contable TransType Origen Tabla DocSubType

Facturas Deudores 13 RF OINV --

Nota Debito Deudores 13 RF OINV DN

Nota Credito Deudores 14 RC

Entregas 15 NE

Devoluciones Deudores 16 PD

Facturas Acreedores 18 TT OPCH --

Nota Debito Acreedores 18 TT OPCH DM

Nota Credito Acreedores 19 TP

Entradas Mercancia - Acreedores 20 EC

Devoluciones Acreedores 21 RC

Pagos Deudores 24 PR

Deposito 25 EO

Registro en Diario 30 PI

Pagos Acreedores 46 PP

58 PA

Entradas Mercancia - Inventario 59 IA

Recibo Producción 59 IA

Salida Mercancia - Inventario 60 OA

Transferencia Stock 67 IM

Costos Importacion 69 AI

Deposito Posfechados 76 DP

Revalorización Inventario 162 MR

Orden Fabricación 202 PW

Anticipos Deudores 203

Anticipos Acreedores 204 CD

Saludos.