SAP ABAP Table SMT_TEST_S_SPFLI (Flight schedule and flight information), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `SMT_TEST_S_SPFLI` {Flight schedule and flight information}

Home

                title {label: "SAP ABAP table SMT_TEST_S_SPFLI {Flight schedule and flight information}", size: "20"}

# Entities

[SMT_TEST_S_SPFLI] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+CARRID {label: "CHAR (3)"}
+COUNTRYFR {label: "CHAR (3)"}
+CITYFROM {label: "CHAR (20)"}
+AIRPFROM {label: "CHAR (3)"}
+COUNTRYTO {label: "CHAR (3)"}
+CITYTO {label: "CHAR (20)"}
+AIRPTO {label: "CHAR (3)"}

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

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

[SGEOCITY] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*CITY {label: "CHAR (20)"}
*COUNTRY {label: "CHAR (3)"}

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

# Relationships

SMT_TEST_S_SPFLI 1--* SAIRPORT {label: "SMT_TEST_S_SPFLI-AIRPFROM = SAIRPORT-ID"}
SMT_TEST_S_SPFLI 1--* SAIRPORT {label: "SMT_TEST_S_SPFLI-AIRPTO = SAIRPORT-ID"}
SMT_TEST_S_SPFLI 1--* SCARR {label: "SMT_TEST_S_SPFLI-CARRID = SCARR-CARRID"}
SMT_TEST_S_SPFLI 1--* SGEOCITY {label: "SMT_TEST_S_SPFLI-CITYFROM = SGEOCITY-CITY"}
SMT_TEST_S_SPFLI 1--* SGEOCITY {label: "SMT_TEST_S_SPFLI-CITYTO = SGEOCITY-CITY"}
SMT_TEST_S_SPFLI 1--* SGEOCITY {label: "SMT_TEST_S_SPFLI-COUNTRYFR = SGEOCITY-COUNTRY"}
SMT_TEST_S_SPFLI 1--* SGEOCITY {label: "SMT_TEST_S_SPFLI-COUNTRYTO = SGEOCITY-COUNTRY"}
SMT_TEST_S_SPFLI *--* T000 {label: "SMT_TEST_S_SPFLI-MANDT = T000-MANDT"}

E-R Diagram for table SMT_TEST_S_SPFLI (Flight schedule and flight information)

Foreign Key tables (4)

SAIRPORT {Airports}
SCARR {Airline}
SGEOCITY {Geographical position of a city}
T000 {Clients}

SAP ABAP Table SMT_TEST_S_SPFLI {Flight schedule and flight information}

Foreign Key tables (4)

SAP ABAP Table `SMT_TEST_S_SPFLI` {Flight schedule and flight information}