SAP ABAP Table MCVU_ESTA (IS-U Sales Statistics: LIS Initial Interface), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `MCVU_ESTA` {IS-U Sales Statistics: LIS Initial Interface}

Home

                title {label: "SAP ABAP table MCVU_ESTA {IS-U Sales Statistics: LIS Initial Interface}", size: "20"}

# Entities

[MCVU_ESTA] {bgcolor: "tomato"}
+BUKRS {label: "CHAR (4)"}
+SPARTE {label: "CHAR (2)"}
+HVORG {label: "CHAR (4)"}
+KOFIZ {label: "CHAR (2)"}
+PORTION {label: "CHAR (8)"}
+ABLEINH {label: "CHAR (8)"}
+KTOKLASSE {label: "CHAR (4)"}
+BELZART {label: "CHAR (6)"}
+AKLASSE {label: "CHAR (4)"}
+BRANCHE {label: "CHAR (10)"}
+TVORG {label: "CHAR (4)"}
+EQUNR {label: "CHAR (18)"}
+MATNR {label: "CHAR (18)"}
+KONZIGR {label: "CHAR (10)"}
+TARIFTYP {label: "CHAR (10)"}
+STATTART {label: "CHAR (8)"}
+TARIFNR {label: "CHAR (10)"}
+KONDIGR {label: "CHAR (10)"}
+STGRQNT {label: "CHAR (6)"}
+STGRAMT {label: "CHAR (6)"}
+TWAERS {label: "CUKY (5)"}
+GSBER {label: "CHAR (4)"}
+PRCTR {label: "CHAR (10)"}
+CITY_CODE {label: "CHAR (12)"}
+CITYP_CODE {label: "CHAR (8)"}
+STREETCODE {label: "CHAR (12)"}
+COUNTRY {label: "CHAR (3)"}
+REGION {label: "CHAR (3)"}
+REGPOLIT {label: "CHAR (8)"}
+REGIOGROUP {label: "CHAR (8)"}
+ANLAGE {label: "CHAR (10)"}
+ANLART {label: "CHAR (4)"}
+SPEBENE {label: "CHAR (2)"}

[ADRCITY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*CITY_CODE {label: "CHAR (12)"}

[ADRCITYPRT] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+CITY_CODE {label: "CHAR (12)"}
*CITYP_CODE {label: "CHAR (8)"}

[ADRREGGRP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*REGIOGROUP {label: "CHAR (8)"}

[ADRSTREET] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRT_CODE {label: "CHAR (12)"}

[CEPC] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PRCTR {label: "CHAR (10)"}
*DATBI {label: "DATS (8)"}
*+KOKRS {label: "CHAR (4)"}

[EAKLASSE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*AKLASSE {label: "CHAR (4)"}

[EANL] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ANLAGE {label: "CHAR (10)"}

[EQUI] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*EQUNR {label: "CHAR (18)"}

[ETRF] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TARIFNR {label: "CHAR (10)"}

[ETTA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TARIFTYP {label: "CHAR (10)"}

[KONTOKLASSE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KTOKL {label: "CHAR (4)"}

[MARA] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MATNR {label: "CHAR (18)"}

[T001] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BUKRS {label: "CHAR (4)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[TB023] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*IND_SECTOR {label: "CHAR (10)"}

[TCURC] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*WAERS {label: "CUKY (5)"}

[TE067] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KONDIGR {label: "CHAR (10)"}

[TE069] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*TARIFART {label: "CHAR (8)"}

[TE097] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+BUKRS {label: "CHAR (4)"}
*+SPARTE {label: "CHAR (2)"}
*KOFIZ {label: "CHAR (2)"}

[TE227] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*REGPOLIT {label: "CHAR (8)"}

[TE241] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KONZIGR {label: "CHAR (10)"}

[TE369] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SPEBENE {label: "CHAR (2)"}

[TE420] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TERMSCHL {label: "CHAR (8)"}

[TE422] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TERMSCHL {label: "CHAR (8)"}

[TE439] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*ANLART {label: "CHAR (4)"}

[TE540] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*STGRQNT {label: "CHAR (6)"}

[TE541] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*STGRAMT {label: "CHAR (6)"}

[TE835] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BELZART {label: "CHAR (6)"}

[TFKHVO] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*APPLK {label: "CHAR (1)"}
*HVORG {label: "CHAR (4)"}

[TFKTVO] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*APPLK {label: "CHAR (1)"}
*+HVORG {label: "CHAR (4)"}
*TVORG {label: "CHAR (4)"}

[TGSB] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*GSBER {label: "CHAR (4)"}

[TSPA] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*SPART {label: "CHAR (2)"}

# Relationships

MCVU_ESTA *--* TE422 {label: "MCVU_ESTA-ABLEINH = TE422-TERMSCHL"}
MCVU_ESTA *--* EAKLASSE {label: "MCVU_ESTA-AKLASSE = EAKLASSE-AKLASSE"}
MCVU_ESTA *--* EANL {label: "MCVU_ESTA-ANLAGE = EANL-MANDT"}
MCVU_ESTA *--* TE439 {label: "MCVU_ESTA-ANLART = TE439-ANLART"}
MCVU_ESTA *--* TE835 {label: "MCVU_ESTA-BELZART = TE835-BELZART"}
MCVU_ESTA *--* TB023 {label: "MCVU_ESTA-BRANCHE = TB023-IND_SECTOR"}
MCVU_ESTA *--* T001 {label: "MCVU_ESTA-BUKRS = T001-BUKRS"}
MCVU_ESTA *--* ADRCITYPRT {label: "MCVU_ESTA-CITYP_CODE = ADRCITYPRT-CITYP_CODE"}
MCVU_ESTA *--* ADRCITY {label: "MCVU_ESTA-CITY_CODE = ADRCITY-CITY_CODE"}
MCVU_ESTA *--* T005 {label: "MCVU_ESTA-COUNTRY = T005-LAND1"}
MCVU_ESTA *--* EQUI {label: "MCVU_ESTA-EQUNR = EQUI-EQUNR"}
MCVU_ESTA *--* TGSB {label: "MCVU_ESTA-GSBER = TGSB-GSBER"}
MCVU_ESTA *--* TFKHVO {label: "MCVU_ESTA-HVORG = TFKHVO-HVORG"}
MCVU_ESTA *--* TE097 {label: "MCVU_ESTA-KOFIZ = TE097-KOFIZ"}
MCVU_ESTA *--* TE067 {label: "MCVU_ESTA-KONDIGR = TE067-KONDIGR"}
MCVU_ESTA *--* TE241 {label: "MCVU_ESTA-KONZIGR = TE241-KONZIGR"}
MCVU_ESTA *--* KONTOKLASSE {label: "MCVU_ESTA-KTOKLASSE = KONTOKLASSE-KTOKL"}
MCVU_ESTA *--* MARA {label: "MCVU_ESTA-MATNR = MARA-MATNR"}
MCVU_ESTA *--* TE420 {label: "MCVU_ESTA-PORTION = TE420-TERMSCHL"}
MCVU_ESTA *--* CEPC {label: "MCVU_ESTA-PRCTR = CEPC-PRCTR"}
MCVU_ESTA *--* ADRREGGRP {label: "MCVU_ESTA-REGIOGROUP = ADRREGGRP-REGIOGROUP"}
MCVU_ESTA *--* T005S {label: "MCVU_ESTA-REGION = T005S-BLAND"}
MCVU_ESTA *--* TE227 {label: "MCVU_ESTA-REGPOLIT = TE227-REGPOLIT"}
MCVU_ESTA *--* TSPA {label: "MCVU_ESTA-SPARTE = TSPA-SPART"}
MCVU_ESTA *--* TE369 {label: "MCVU_ESTA-SPEBENE = TE369-SPEBENE"}
MCVU_ESTA *--* TE069 {label: "MCVU_ESTA-STATTART = TE069-TARIFART"}
MCVU_ESTA *--* TE541 {label: "MCVU_ESTA-STGRAMT = TE541-STGRAMT"}
MCVU_ESTA *--* TE540 {label: "MCVU_ESTA-STGRQNT = TE540-STGRQNT"}
MCVU_ESTA *--* ADRSTREET {label: "MCVU_ESTA-STREETCODE = ADRSTREET-STRT_CODE"}
MCVU_ESTA *--* ETRF {label: "MCVU_ESTA-TARIFNR = ETRF-TARIFNR"}
MCVU_ESTA *--* ETTA {label: "MCVU_ESTA-TARIFTYP = ETTA-TARIFTYP"}
MCVU_ESTA *--* TFKTVO {label: "MCVU_ESTA-TVORG = TFKTVO-TVORG"}
MCVU_ESTA *--* TCURC {label: "MCVU_ESTA-TWAERS = TCURC-WAERS"}

E-R Diagram for table MCVU_ESTA (IS-U Sales Statistics: LIS Initial Interface)

Foreign Key tables (33)

ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
CEPC {Profit Center Master Data Table}
EAKLASSE {IS-U Billing Classes}
EANL {Installation}
EQUI {Equipment master data}
ETRF {Rate (Head. Data)}
ETTA {General Rate Cat.(Header Data)}
KONTOKLASSE {IS-U Acc. Classes}
MARA {General Material Data}
T001 {Company Codes}
T005 {Countries}
T005S {Taxes: Region (Province) Key}
TB023 {BP industries (Obsolete ==> TB038A)}
TCURC {Currency Codes}
TE067 {Fact Groups}
TE069 {Rate Types}
TE097 {Account Determ. IDs}
TE227 {Elements of Political Regional Structure}
TE241 {Franchise Tax Groups}
TE369 {Voltage Level}
TE420 {Sch. Mast. Data: Portion}
TE422 {Schedule Master Data for Meter Reading Unit}
TE439 {Installation Type}
TE540 {Quantity Statistics Group}
TE541 {Amount Statistics Group}
TE835 {Line Item Type}
TFKHVO {Main transactions in contract accts receivable and payable}
TFKTVO {Sub-transactions in Contract Accounts Receivable and Payable}
TGSB {Business Areas}
TSPA {Organizational Unit: Sales Divisions}