Does ECC on Oracle DB & ECC on HANA DB " TABLES " will be same ???

[Former Member]

Hi All,

We are planning to install ECC on HANA DB.

We are struck up with 1 thing which is  " Does ECC on Oracle DB Instance & ECC on HANA DB Instance " tables " will be same "

VBAK, VBKD, VBAP, VBUP, VBUK, VBPA these are the few SAP SD tables which are available in ECC on Oracle DB Instance.

If i install ECC on HANA DB will i get the same tables in my new instance also OR

does the sap tables will changes if the DB is changed from Oracle to HANA DB....

[Former Member · Accepted solution]

Header 1

Header 2

ORACLE Name Null?    Type ----------------------------------------- -------- ---------------------------- MANDT                                     NOT NULL VARCHAR2(9) VBELN                                     NOT NULL VARCHAR2(30) ERDAT                                     NOT NULL VARCHAR2(24) ERZET                                     NOT NULL VARCHAR2(18) ERNAM                                     NOT NULL VARCHAR2(36) ANGDT                                     NOT NULL VARCHAR2(24) BNDDT                                     NOT NULL VARCHAR2(24) AUDAT                                     NOT NULL VARCHAR2(24) VBTYP                                     NOT NULL VARCHAR2(3) TRVOG                                     NOT NULL VARCHAR2(3) AUART                                     NOT NULL VARCHAR2(12) AUGRU                                     NOT NULL VARCHAR2(9) GWLDT                                     NOT NULL VARCHAR2(24) SUBMI                                     NOT NULL VARCHAR2(30) LIFSK                                     NOT NULL VARCHAR2(6) FAKSK                                     NOT NULL VARCHAR2(6) NETWR                                     NOT NULL NUMBER(15,2) WAERK                                     NOT NULL VARCHAR2(15) VKORG                                     NOT NULL VARCHAR2(12) VTWEG                                     NOT NULL VARCHAR2(6) SPART                                     NOT NULL VARCHAR2(6) VKGRP                                     NOT NULL VARCHAR2(9) VKBUR                                     NOT NULL VARCHAR2(12) GSBER                                     NOT NULL VARCHAR2(12) GSKST                                     NOT NULL VARCHAR2(12) GUEBG                                     NOT NULL VARCHAR2(24) GUEEN                                     NOT NULL VARCHAR2(24) KNUMV                                     NOT NULL VARCHAR2(30) VDATU                                     NOT NULL VARCHAR2(24) VPRGR                                     NOT NULL VARCHAR2(3) AUTLF                                     NOT NULL VARCHAR2(3) VBKLA                                     NOT NULL VARCHAR2(27) VBKLT                                     NOT NULL VARCHAR2(3) KALSM                                     NOT NULL VARCHAR2(18) VSBED                                     NOT NULL VARCHAR2(6) FKARA                                     NOT NULL VARCHAR2(12) AWAHR                                     NOT NULL VARCHAR2(9) KTEXT                                     NOT NULL VARCHAR2(120) BSTNK                                     NOT NULL VARCHAR2(60) BSARK                                     NOT NULL VARCHAR2(12) BSTDK                                     NOT NULL VARCHAR2(24) BSTZD                                     NOT NULL VARCHAR2(12) IHREZ                                     NOT NULL VARCHAR2(36) BNAME                                     NOT NULL VARCHAR2(105) TELF1                                     NOT NULL VARCHAR2(48) MAHZA                                     NOT NULL NUMBER(3) MAHDT                                     NOT NULL VARCHAR2(24) KUNNR                                     NOT NULL VARCHAR2(30) KOSTL                                     NOT NULL VARCHAR2(30) STAFO                                     NOT NULL VARCHAR2(18) STWAE                                     NOT NULL VARCHAR2(15) AEDAT                                     NOT NULL VARCHAR2(24) KVGR1                                     NOT NULL VARCHAR2(9) KVGR2                                     NOT NULL VARCHAR2(9) KVGR3                                     NOT NULL VARCHAR2(9) KVGR4                                     NOT NULL VARCHAR2(9) KVGR5                                     NOT NULL VARCHAR2(9) KNUMA                                     NOT NULL VARCHAR2(30) KOKRS                                     NOT NULL VARCHAR2(12) PS_PSP_PNR                                NOT NULL VARCHAR2(24) KURST                                     NOT NULL VARCHAR2(12) KKBER                                     NOT NULL VARCHAR2(12) KNKLI                                     NOT NULL VARCHAR2(30) GRUPP                                     NOT NULL VARCHAR2(12) SBGRP                                     NOT NULL VARCHAR2(9) CTLPC                                     NOT NULL VARCHAR2(9) CMWAE                                     NOT NULL VARCHAR2(15) CMFRE                                     NOT NULL VARCHAR2(24) CMNUP                                     NOT NULL VARCHAR2(24) CMNGV                                     NOT NULL VARCHAR2(24) AMTBL                                     NOT NULL NUMBER(15,2) HITYP_PR                                  NOT NULL VARCHAR2(3) ABRVW                                     NOT NULL VARCHAR2(9) ABDIS                                     NOT NULL VARCHAR2(3) VGBEL                                     NOT NULL VARCHAR2(30) OBJNR                                     NOT NULL VARCHAR2(66) BUKRS_VF                                  NOT NULL VARCHAR2(12) TAXK1                                     NOT NULL VARCHAR2(3) TAXK2                                     NOT NULL VARCHAR2(3) TAXK3                                     NOT NULL VARCHAR2(3) TAXK4                                     NOT NULL VARCHAR2(3) TAXK5                                     NOT NULL VARCHAR2(3) TAXK6                                     NOT NULL VARCHAR2(3) TAXK7                                     NOT NULL VARCHAR2(3) TAXK8                                     NOT NULL VARCHAR2(3) TAXK9                                     NOT NULL VARCHAR2(3) XBLNR                                     NOT NULL VARCHAR2(48) ZUONR                                     NOT NULL VARCHAR2(54) VGTYP                                     NOT NULL VARCHAR2(3) KALSM_CH                                  NOT NULL VARCHAR2(18) AGRZR                                     NOT NULL VARCHAR2(6) AUFNR                                     NOT NULL VARCHAR2(36) QMNUM                                     NOT NULL VARCHAR2(36) VBELN_GRP                                 NOT NULL VARCHAR2(30) SCHEME_GRP                                NOT NULL VARCHAR2(12) ABRUF_PART                                NOT NULL VARCHAR2(3) ABHOD                                     NOT NULL VARCHAR2(24) ABHOV                                     NOT NULL VARCHAR2(18) ABHOB                                     NOT NULL VARCHAR2(18) RPLNR                                     NOT NULL VARCHAR2(30) VZEIT                                     NOT NULL VARCHAR2(18) STCEG_L                                   NOT NULL VARCHAR2(9) LANDTX                                    NOT NULL VARCHAR2(9) XEGDR                                     NOT NULL VARCHAR2(3) ENQUEUE_GRP                               NOT NULL VARCHAR2(3) DAT_FZAU                                  NOT NULL VARCHAR2(24) FMBDAT                                    NOT NULL VARCHAR2(24) VSNMR_V                                   NOT NULL VARCHAR2(36) HANDLE                                    NOT NULL VARCHAR2(66) PROLI                                     NOT NULL VARCHAR2(9) CONT_DG                                   NOT NULL VARCHAR2(3) CRM_GUID                                  NOT NULL VARCHAR2(210) UPD_TMSTMP                                NOT NULL NUMBER(21,7) MSR_ID                                    NOT NULL VARCHAR2(30) TM_CTRL_KEY                               NOT NULL VARCHAR2(12) SWENR                                     NOT NULL VARCHAR2(24) SMENR                                     NOT NULL VARCHAR2(24) PHASE                                     NOT NULL VARCHAR2(33) MTLAUR                                    NOT NULL VARCHAR2(3) STAGE                                     NOT NULL NUMBER(10) HB_CONT_REASON                            NOT NULL VARCHAR2(6) HB_EXPDATE                                NOT NULL VARCHAR2(24) HB_RESDATE                                NOT NULL VARCHAR2(24) LOGSYSB                                   NOT NULL VARCHAR2(30) KALCD                                     NOT NULL VARCHAR2(18) MULTI                                     NOT NULL VARCHAR2(3) HANDOVERLOC                               NOT NULL VARCHAR2(30) PSM_BUDAT                                 NOT NULL VARCHAR2(24) SPPAYM                                    NOT NULL VARCHAR2(6)

HANA Name;SQL Data Type;Dimension;Column Store Data Type;Key;Not Null;Default;Comment MANDT;NVARCHAR;3;STRING;X(1);X;000; VBELN;NVARCHAR;10;STRING;X(2);X;; ERDAT;NVARCHAR;8;STRING;;X;00000000; ERZET;NVARCHAR;6;STRING;;X;000000; ERNAM;NVARCHAR;12;STRING;;X;; ANGDT;NVARCHAR;8;STRING;;X;00000000; BNDDT;NVARCHAR;8;STRING;;X;00000000; AUDAT;NVARCHAR;8;STRING;;X;00000000; VBTYP;NVARCHAR;1;STRING;;X;; TRVOG;NVARCHAR;1;STRING;;X;; AUART;NVARCHAR;4;STRING;;X;; AUGRU;NVARCHAR;3;STRING;;X;; GWLDT;NVARCHAR;8;STRING;;X;00000000; SUBMI;NVARCHAR;10;STRING;;X;; LIFSK;NVARCHAR;2;STRING;;X;; FAKSK;NVARCHAR;2;STRING;;X;; NETWR;DECIMAL;15,2;FIXED;;X;0; WAERK;NVARCHAR;5;STRING;;X;; VKORG;NVARCHAR;4;STRING;;X;; VTWEG;NVARCHAR;2;STRING;;X;; SPART;NVARCHAR;2;STRING;;X;; VKGRP;NVARCHAR;3;STRING;;X;; VKBUR;NVARCHAR;4;STRING;;X;; GSBER;NVARCHAR;4;STRING;;X;; GSKST;NVARCHAR;4;STRING;;X;; GUEBG;NVARCHAR;8;STRING;;X;00000000; GUEEN;NVARCHAR;8;STRING;;X;00000000; KNUMV;NVARCHAR;10;STRING;;X;; VDATU;NVARCHAR;8;STRING;;X;00000000; VPRGR;NVARCHAR;1;STRING;;X;; AUTLF;NVARCHAR;1;STRING;;X;; VBKLA;NVARCHAR;9;STRING;;X;; VBKLT;NVARCHAR;1;STRING;;X;; KALSM;NVARCHAR;6;STRING;;X;; VSBED;NVARCHAR;2;STRING;;X;; FKARA;NVARCHAR;4;STRING;;X;; AWAHR;NVARCHAR;3;STRING;;X;000; KTEXT;NVARCHAR;40;STRING;;X;; BSTNK;NVARCHAR;20;STRING;;X;; BSARK;NVARCHAR;4;STRING;;X;; BSTDK;NVARCHAR;8;STRING;;X;00000000; BSTZD;NVARCHAR;4;STRING;;X;; IHREZ;NVARCHAR;12;STRING;;X;; BNAME;NVARCHAR;35;STRING;;X;; TELF1;NVARCHAR;16;STRING;;X;; MAHZA;DECIMAL;3;FIXED;;X;0; MAHDT;NVARCHAR;8;STRING;;X;00000000; KUNNR;NVARCHAR;10;STRING;;X;; KOSTL;NVARCHAR;10;STRING;;X;; STAFO;NVARCHAR;6;STRING;;X;; STWAE;NVARCHAR;5;STRING;;X;; AEDAT;NVARCHAR;8;STRING;;X;00000000; KVGR1;NVARCHAR;3;STRING;;X;; KVGR2;NVARCHAR;3;STRING;;X;; KVGR3;NVARCHAR;3;STRING;;X;; KVGR4;NVARCHAR;3;STRING;;X;; KVGR5;NVARCHAR;3;STRING;;X;; KNUMA;NVARCHAR;10;STRING;;X;; KOKRS;NVARCHAR;4;STRING;;X;; PS_PSP_PNR;NVARCHAR;8;STRING;;X;00000000; KURST;NVARCHAR;4;STRING;;X;; KKBER;NVARCHAR;4;STRING;;X;; KNKLI;NVARCHAR;10;STRING;;X;; GRUPP;NVARCHAR;4;STRING;;X;; SBGRP;NVARCHAR;3;STRING;;X;; CTLPC;NVARCHAR;3;STRING;;X;; CMWAE;NVARCHAR;5;STRING;;X;; CMFRE;NVARCHAR;8;STRING;;X;00000000; CMNUP;NVARCHAR;8;STRING;;X;00000000; CMNGV;NVARCHAR;8;STRING;;X;00000000; AMTBL;DECIMAL;15,2;FIXED;;X;0; HITYP_PR;NVARCHAR;1;STRING;;X;; ABRVW;NVARCHAR;3;STRING;;X;; ABDIS;NVARCHAR;1;STRING;;X;; VGBEL;NVARCHAR;10;STRING;;X;; OBJNR;NVARCHAR;22;STRING;;X;; BUKRS_VF;NVARCHAR;4;STRING;;X;; TAXK1;NVARCHAR;1;STRING;;X;; TAXK2;NVARCHAR;1;STRING;;X;; TAXK3;NVARCHAR;1;STRING;;X;; TAXK4;NVARCHAR;1;STRING;;X;; TAXK5;NVARCHAR;1;STRING;;X;; TAXK6;NVARCHAR;1;STRING;;X;; TAXK7;NVARCHAR;1;STRING;;X;; TAXK8;NVARCHAR;1;STRING;;X;; TAXK9;NVARCHAR;1;STRING;;X;; XBLNR;NVARCHAR;16;STRING;;X;; ZUONR;NVARCHAR;18;STRING;;X;; VGTYP;NVARCHAR;1;STRING;;X;; KALSM_CH;NVARCHAR;6;STRING;;X;; AGRZR;NVARCHAR;2;STRING;;X;00; AUFNR;NVARCHAR;12;STRING;;X;; QMNUM;NVARCHAR;12;STRING;;X;; VBELN_GRP;NVARCHAR;10;STRING;;X;; SCHEME_GRP;NVARCHAR;4;STRING;;X;; ABRUF_PART;NVARCHAR;1;STRING;;X;; ABHOD;NVARCHAR;8;STRING;;X;00000000; ABHOV;NVARCHAR;6;STRING;;X;000000; ABHOB;NVARCHAR;6;STRING;;X;000000; RPLNR;NVARCHAR;10;STRING;;X;; VZEIT;NVARCHAR;6;STRING;;X;000000; STCEG_L;NVARCHAR;3;STRING;;X;; LANDTX;NVARCHAR;3;STRING;;X;; XEGDR;NVARCHAR;1;STRING;;X;; ENQUEUE_GRP;NVARCHAR;1;STRING;;X;; DAT_FZAU;NVARCHAR;8;STRING;;X;00000000; FMBDAT;NVARCHAR;8;STRING;;X;00000000; VSNMR_V;NVARCHAR;12;STRING;;X;; HANDLE;NVARCHAR;22;STRING;;X;; PROLI;NVARCHAR;3;STRING;;X;; CONT_DG;NVARCHAR;1;STRING;;X;; CRM_GUID;NVARCHAR;70;STRING;;X;; UPD_TMSTMP;DECIMAL;21,7;FIXED;;X;0; MSR_ID;NVARCHAR;10;STRING;;X;; TM_CTRL_KEY;NVARCHAR;4;STRING;;X;; SWENR;NVARCHAR;8;STRING;;X;; SMENR;NVARCHAR;8;STRING;;X;; PHASE;NVARCHAR;11;STRING;;X;; MTLAUR;NVARCHAR;1;STRING;;X;; STAGE;INTEGER;;INT;;X;0; HB_CONT_REASON;NVARCHAR;2;STRING;;X;; HB_EXPDATE;NVARCHAR;8;STRING;;X;00000000; HB_RESDATE;NVARCHAR;8;STRING;;X;00000000; LOGSYSB;NVARCHAR;10;STRING;;X;; KALCD;NVARCHAR;6;STRING;;X;; MULTI;NVARCHAR;1;STRING;;X;; HANDOVERLOC;NVARCHAR;10;STRING;;X;; PSM_BUDAT;NVARCHAR;8;STRING;;X;00000000; SPPAYM;NVARCHAR;2;STRING;;X;;

[Former Member · Accepted solution]

For the visual check -->  I did it for the table VBAK.

Pls check, but it looks the same for the field names but differ in the length.