Zum Hauptinhalt springen

Datenbanktabellen für MM-Buchungen

Allgemeine Informationen​

Bevor die jeweiligen Stammdatentabellen über den SAP-Connector abgefragt werden können, müssen natürlich die referenzierten Datenbank Tabellen angelegt werden.

sap_ekko​

Dies entspricht der EKKO SAP-Tabelle, im DMS Jargon orderheader

CREATE TABLE [dbo].[sap_ekko](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [BUKRS] [varchar](4) NULL,
 [EBELN] [varchar](10) NULL,
 [LIFNR] [varchar](10) NULL,
 [BEDAT] [date] NULL,
 [STATU] [varchar](1) NULL,
 [ERNAM] [varchar](12) NULL,
 CONSTRAINT [PK_sap_ekko] PRIMARY KEY CLUSTERED 
(
 [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 75, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
);

sap_ekpo​

Dies entspricht der EKPO SAP-Tabelle, im DMS Jargon orderitems

CREATE TABLE [dbo].[sap_ekpo](
 [EBELN] [varchar](10) NULL,
 [EBELP] [varchar](5) NULL,
 [AEDAT] [varchar](20) NULL,
 [TXZ01] [varchar](40) NULL,
 [MATNR] [varchar](18) NULL,
 [BUKRS] [varchar](4) NULL,
 [MENGE] [varchar](13) NULL,
 [MEINS] [varchar](3) NULL,
 [NETPR] [varchar](11) NULL,
 [PEINH] [varchar](5) NULL,
 [NETWR] [varchar](13) NULL,
 [ELIKZ] [varchar](1) NULL,
 [WEPOS] [varchar](1) NULL,
 [REPOS] [nchar](1) NULL,
 [MWSKZ] [varchar](2) NULL,
 [LOEKZ] [varchar](1) NULL,
 [WEBRE] [varchar](1) NULL
);

sap_ekbe​

Dies entspricht der EKBE SAP-Tabelle, welches die Bestellentwicklungen darstellt

CREATE TABLE [dbo].[sap_ekbe](
    [EBELN] [varchar](10) NULL,
    [EBELP] [varchar](5) NULL,
    [VGABE] [varchar](1) NULL,
    [GJAHR] [varchar](4) NULL,
    [BELNR] [varchar](10) NULL,
    [BEWTP] [varchar](1) NULL,
    [MENGE] [varchar](13) NULL,
    [BPMNG] [varchar](13) NULL,
    [SHKZG] [varchar](1) NULL,
    [LFBNR] [varchar](10) NULL,
    [CPUDT] [date] NULL,
    [CPUTM] [varchar](6) NULL
);

sap_ekkn​

Dies entspricht der EKKN SAP-Tabelle, welches die Kontierung im Einkaufsbeleg darstellt

CREATE TABLE [dbo].[sap_ekkn](
 [EBELN] [varchar](10) NULL,
 [EBELP] [varchar](5) NULL,
 [SAKTO] [varchar](10) NULL,
 [KOSTL] [varchar](10) NULL,
 [AUFNR] [varchar](12) NULL
);

sap_mkpf​

Dies entspricht der MKPF SAP-Tabelle, im DMS Jargon materialheader

CREATE TABLE [dbo].[sap_mkpf](
 [MBLNR] [varchar](10) NULL,
 [MJAHR] [varchar](4) NULL,
 [BLDAT] [date] NULL,
 [BUDAT] [date] NULL,
 [CPUDT] [date] NULL,
 [CPUTM] [varchar](6) NULL,
 [XBLNR] [varchar](16) NULL,
 [BKTXT] [varchar](25) NULL
);

sap_mseg​

Dies entspricht der MSEG SAP-Tabelle, im DMS Jargon materialitems

CREATE TABLE [dbo].[sap_mseg](
 [MBLNR] [varchar](10) NULL,
 [MJAHR] [varchar](4) NULL,
 [ZEILE] [varchar](4) NULL,
 [MATNR] [varchar](18) NULL,
 [LIFNR] [varchar](10) NULL,
 [EBELN] [varchar](10) NULL,
 [EBELP] [varchar](5) NULL,
 [MENGE] [varchar](13) NULL,
 [SGTXT] [varchar](50) NULL,
 [KOSTL] [varchar](10) NULL,
 [AUFNR] [varchar](12) NULL,
 [GJAHR] [varchar](4) NULL,
 [BUKRS] [varchar](4) NULL,
 [BELNR] [varchar](10) NULL,
 [BUZEI] [varchar](3) NULL,
 [CPUDT] [date] NULL,
 [CPUTM] [varchar](6) NULL,
 [BWART] [varchar](3) NULL,
 [SAKTO] [varchar](10) NULL
);

ufInternalOrders​

Dies entspricht der AUFK SAP-Tabelle, im DMS Jargon sind dies die Innenaufträge

CREATE TABLE [dbo].[ufInternalOrders](
 [orderId] [varchar](12) NOT NULL,
 [recipientId] [varchar](50) NULL,
 [costcenter] [varchar](50) NULL,
 [description] [varchar](50) NULL,
 [orderArt] [varchar](50) NULL,
 [orderType] [varchar](50) NULL,
 [opened] [varchar](50) NULL,
 [released] [varchar](50) NULL,
 [closedTechnical] [varchar](50) NULL,
 [closed] [varchar](50) NULL
);