SAP ABAP Table ESALES_SETTYPE_SERVLOC (Set Type: Premise), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `ESALES_SETTYPE_SERVLOC` {Set Type: Premise}

Home

                title {label: "SAP ABAP table ESALES_SETTYPE_SERVLOC {Set Type: Premise}", size: "20"}

# Entities

[ESALES_SETTYPE_SERVLOC] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+TXTLANGU {label: "LANG (1)"}
+VBSART {label: "CHAR (8)"}
+EIGENT {label: "CHAR (10)"}
+OBJNR {label: "CHAR (22)"}
+TPLNUMMER {label: "CHAR (30)"}
+BEGRUC {label: "CHAR (4)"}
+SWERKC {label: "CHAR (4)"}
+COUNCC {label: "CHAR (3)"}
+REGIOGROUPC {label: "CHAR (8)"}
+REGPOLITC {label: "CHAR (8)"}
+REGIOGROUP_PERMC {label: "CHAR (8)"}
+CITY_CODEA {label: "CHAR (12)"}
+CITYP_CODEA {label: "CHAR (8)"}
+CITYH_CODEA {label: "CHAR (12)"}
+REGIOGROUPA {label: "CHAR (8)"}
+DONT_USE_PA {label: "CHAR (4)"}
+CITY_CODE2A {label: "CHAR (12)"}
+PO_BOX_REGA {label: "CHAR (3)"}
+PO_BOX_CTYA {label: "CHAR (3)"}
+TRANSPZONEA {label: "CHAR (10)"}
+DONT_USE_SA {label: "CHAR (4)"}
+STREETCODEA {label: "CHAR (12)"}
+STREETABBRA {label: "CHAR (2)"}
+COUNTRYA {label: "CHAR (3)"}
+LANGUA {label: "LANG (1)"}
+REGIONA {label: "CHAR (3)"}
+ADDRORIGINA {label: "CHAR (4)"}
+TIME_ZONEA {label: "CHAR (6)"}
+LANGU_CREAA {label: "LANG (1)"}
+DELI_SERV_TYPEA {label: "CHAR (4)"}
+COUNTY_CODEA {label: "CHAR (8)"}
+TOWNSHIP_CODEA {label: "CHAR (8)"}

[ADDRC_DELI_SERV] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*DELI_SERV_TYPE {label: "CHAR (4)"}

[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)"}

[ADRCOUNTY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*COUNTY_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)"}

[ADRSTRTYPE] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRTYPEAB {label: "CHAR (2)"}

[ADRTOWNSHIP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*+COUNTY_CODE {label: "CHAR (8)"}
*TOWNSHIP_CODE {label: "CHAR (8)"}

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

[IFLOT] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*TPLNR {label: "CHAR (30)"}

[ONR00] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*OBJNR {label: "CHAR (22)"}

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

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

[T002] {bgcolor: "#d0e0d0"}
*SPRAS {label: "LANG (1)"}

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

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

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

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

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

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

[TSAD12] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*UNDELIVER {label: "CHAR (4)"}

[TSAD6] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ORIGIN {label: "CHAR (4)"}

[TTZZ] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TZONE {label: "CHAR (6)"}

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

# Relationships

ESALES_SETTYPE_SERVLOC ?--* TSAD6 {label: "ESALES_SETTYPE_SERVLOC-ADDRORIGINA = TSAD6-ORIGIN"}
ESALES_SETTYPE_SERVLOC ?--* T370B {label: "ESALES_SETTYPE_SERVLOC-BEGRUC = T370B-BEGRU"}
ESALES_SETTYPE_SERVLOC ?--* ADRCITY {label: "ESALES_SETTYPE_SERVLOC-CITYH_CODEA = ADRCITY-CITY_CODE"}
ESALES_SETTYPE_SERVLOC ?--* ADRCITYPRT {label: "ESALES_SETTYPE_SERVLOC-CITYP_CODEA = ADRCITYPRT-CITYP_CODE"}
ESALES_SETTYPE_SERVLOC ?--* ADRCITY {label: "ESALES_SETTYPE_SERVLOC-CITY_CODE2A = ADRCITY-CITY_CODE"}
ESALES_SETTYPE_SERVLOC ?--* ADRCITY {label: "ESALES_SETTYPE_SERVLOC-CITY_CODEA = ADRCITY-CITY_CODE"}
ESALES_SETTYPE_SERVLOC *--* T005E {label: "ESALES_SETTYPE_SERVLOC-COUNCC = T005E-COUNC"}
ESALES_SETTYPE_SERVLOC ?--* T005 {label: "ESALES_SETTYPE_SERVLOC-COUNTRYA = T005-LAND1"}
ESALES_SETTYPE_SERVLOC ?--* ADRCOUNTY {label: "ESALES_SETTYPE_SERVLOC-COUNTY_CODEA = ADRCOUNTY-COUNTY_CODE"}
ESALES_SETTYPE_SERVLOC 1--* ADDRC_DELI_SERV {label: "ESALES_SETTYPE_SERVLOC-DELI_SERV_TYPEA = ADDRC_DELI_SERV-DELI_SERV_TYPE"}
ESALES_SETTYPE_SERVLOC ?--* TSAD12 {label: "ESALES_SETTYPE_SERVLOC-DONT_USE_PA = TSAD12-UNDELIVER"}
ESALES_SETTYPE_SERVLOC ?--* TSAD12 {label: "ESALES_SETTYPE_SERVLOC-DONT_USE_SA = TSAD12-UNDELIVER"}
ESALES_SETTYPE_SERVLOC *--* BUT000 {label: "ESALES_SETTYPE_SERVLOC-EIGENT = BUT000-PARTNER"}
ESALES_SETTYPE_SERVLOC ?--* T002 {label: "ESALES_SETTYPE_SERVLOC-LANGUA = T002-SPRAS"}
ESALES_SETTYPE_SERVLOC ?--* T002 {label: "ESALES_SETTYPE_SERVLOC-LANGU_CREAA = T002-SPRAS"}
ESALES_SETTYPE_SERVLOC *--* T000 {label: "ESALES_SETTYPE_SERVLOC-MANDT = T000-MANDT"}
ESALES_SETTYPE_SERVLOC *--* ONR00 {label: "ESALES_SETTYPE_SERVLOC-OBJNR = ONR00-OBJNR"}
ESALES_SETTYPE_SERVLOC ?--* T005 {label: "ESALES_SETTYPE_SERVLOC-PO_BOX_CTYA = T005-LAND1"}
ESALES_SETTYPE_SERVLOC ?--* T005S {label: "ESALES_SETTYPE_SERVLOC-PO_BOX_REGA = T005S-BLAND"}
ESALES_SETTYPE_SERVLOC ?--* ADRREGGRP {label: "ESALES_SETTYPE_SERVLOC-REGIOGROUPA = ADRREGGRP-REGIOGROUP"}
ESALES_SETTYPE_SERVLOC ?--* ADRREGGRP {label: "ESALES_SETTYPE_SERVLOC-REGIOGROUPC = ADRREGGRP-REGIOGROUP"}
ESALES_SETTYPE_SERVLOC ?--* ADRREGGRP {label: "ESALES_SETTYPE_SERVLOC-REGIOGROUP_PERMC = ADRREGGRP-REGIOGROUP"}
ESALES_SETTYPE_SERVLOC ?--* T005S {label: "ESALES_SETTYPE_SERVLOC-REGIONA = T005S-BLAND"}
ESALES_SETTYPE_SERVLOC ?--* TE227 {label: "ESALES_SETTYPE_SERVLOC-REGPOLITC = TE227-REGPOLIT"}
ESALES_SETTYPE_SERVLOC ?--* ADRSTRTYPE {label: "ESALES_SETTYPE_SERVLOC-STREETABBRA = ADRSTRTYPE-STRTYPEAB"}
ESALES_SETTYPE_SERVLOC ?--* ADRSTREET {label: "ESALES_SETTYPE_SERVLOC-STREETCODEA = ADRSTREET-STRT_CODE"}
ESALES_SETTYPE_SERVLOC 1--* T001W {label: "ESALES_SETTYPE_SERVLOC-SWERKC = T001W-WERKS"}
ESALES_SETTYPE_SERVLOC ?--* TTZZ {label: "ESALES_SETTYPE_SERVLOC-TIME_ZONEA = TTZZ-TZONE"}
ESALES_SETTYPE_SERVLOC ?--* ADRTOWNSHIP {label: "ESALES_SETTYPE_SERVLOC-TOWNSHIP_CODEA = ADRTOWNSHIP-TOWNSHIP_CODE"}
ESALES_SETTYPE_SERVLOC *--* IFLOT {label: "ESALES_SETTYPE_SERVLOC-TPLNUMMER = IFLOT-TPLNR"}
ESALES_SETTYPE_SERVLOC ?--* TZONE {label: "ESALES_SETTYPE_SERVLOC-TRANSPZONEA = TZONE-ZONE1"}
ESALES_SETTYPE_SERVLOC 1--* T002 {label: "ESALES_SETTYPE_SERVLOC-TXTLANGU = T002-SPRAS"}
ESALES_SETTYPE_SERVLOC *--* TE102 {label: "ESALES_SETTYPE_SERVLOC-VBSART = TE102-VBSART"}

E-R Diagram for table ESALES_SETTYPE_SERVLOC (Set Type: Premise)

Foreign Key tables (24)

ADDRC_DELI_SERV {Address Service Types}
ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRCOUNTY {County codes}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
ADRSTRTYPE {Street type}
ADRTOWNSHIP {Township codes}
BUT000 {BP: General data I}
IFLOT {Functional Location (Table)}
ONR00 {General Object Number}
T000 {Clients}
T001W {Plants/Branches}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005E {County}
T005S {Taxes: Region (Province) Key}
T370B {Technical object authorization group}
TE102 {Premise Types}
TE227 {Elements of Political Regional Structure}
TSAD12 {Reasons for Non-Delivery (Business Address Services)}
TSAD6 {Source Address or Personal Data (Business Address Services)}
TTZZ {Time zones}
TZONE {Customers: Regional zones}

SAP ABAP Table ESALES_SETTYPE_SERVLOC {Set Type: Premise}

Foreign Key tables (24)

SAP ABAP Table `ESALES_SETTYPE_SERVLOC` {Set Type: Premise}