SAP ABAP Table CE4S_AL (Airline Route Profit), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `CE4S_AL` {Airline Route Profit}

Home

                title {label: "SAP ABAP table CE4S_AL {Airline Route Profit}", size: "20"}

# Entities

[CE4S_AL] {bgcolor: "tomato"}
*+MANDT {label: "CLNT (3)"}
*AKTBO {label: "CHAR (1)"}
*PAOBJNR {label: "NUMC (10)"}
*PASUBNR {label: "NUMC (4)"}
+KNDNR {label: "CHAR (10)"}
+ARTNR {label: "CHAR (18)"}
+FKART {label: "CHAR (4)"}
+KAUFN {label: "CHAR (10)"}
+AUFNR {label: "CHAR (12)"}
+BUKRS {label: "CHAR (4)"}
+KOKRS {label: "CHAR (4)"}
+WERKS {label: "CHAR (4)"}
+GSBER {label: "CHAR (4)"}
+VKORG {label: "CHAR (4)"}
+VTWEG {label: "CHAR (2)"}
+SPART {label: "CHAR (2)"}
+PRCTR {label: "CHAR (10)"}
+PPRCTR {label: "CHAR (10)"}
+KSTRG {label: "CHAR (12)"}
+PSPNR {label: "NUMC (8)"}
+MEINH {label: "UNIT (3)"}
+KMATYP {label: "NUMC (2)"}
+KMDEST {label: "CHAR (5)"}
+KMFLTN {label: "CHAR (6)"}
+KMFLTY {label: "CHAR (4)"}
+KMIATA {label: "CHAR (5)"}
+KMLEGS {label: "CHAR (7)"}
+KMOPDY {label: "CHAR (2)"}
+KMORIG {label: "CHAR (5)"}
+KMROUT {label: "CHAR (5)"}
+KMZONE {label: "CHAR (5)"}
+KWBLOK_ME {label: "UNIT (3)"}
+KWFLHR_ME {label: "UNIT (3)"}
+KWFLKM_ME {label: "UNIT (3)"}
+KWFUEL_ME {label: "UNIT (3)"}
+KWPAXS_ME {label: "UNIT (3)"}
+KWSEAT_ME {label: "UNIT (3)"}
+KWBKPZ_ME {label: "UNIT (3)"}

[AUFK] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*AUFNR {label: "CHAR (12)"}

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

[CKPH] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KSTRG {label: "CHAR (12)"}
*DATBI {label: "DATS (8)"}

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

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

[PRPS] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*PSPNR {label: "NUMC (8)"}

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

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

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

[T006] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*MSEHI {label: "UNIT (3)"}

[T2207] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMIATA {label: "CHAR (5)"}

[T2208] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMOPDY {label: "CHAR (2)"}

[T2209] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMATYP {label: "NUMC (2)"}

[T2210] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMROUT {label: "CHAR (5)"}

[T2211] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMDEST {label: "CHAR (5)"}

[T2212] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMORIG {label: "CHAR (5)"}

[T2213] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*KMLEGS {label: "CHAR (7)"}

[T2214] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*KMZONE {label: "CHAR (5)"}

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

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

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

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

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

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

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

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

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

# Relationships

CE4S_AL ?--* MARA {label: "CE4S_AL-ARTNR = MARA-MATNR"}
CE4S_AL ?--* AUFK {label: "CE4S_AL-AUFNR = AUFK-AUFNR"}
CE4S_AL ?--* T001 {label: "CE4S_AL-BUKRS = T001-BUKRS"}
CE4S_AL ?--* TVFK {label: "CE4S_AL-FKART = TVFK-FKART"}
CE4S_AL ?--* TGSB {label: "CE4S_AL-GSBER = TGSB-GSBER"}
CE4S_AL ?--* VBUK {label: "CE4S_AL-KAUFN = VBUK-VBELN"}
CE4S_AL ?--* T2209 {label: "CE4S_AL-KMATYP = T2209-KMATYP"}
CE4S_AL ?--* T2211 {label: "CE4S_AL-KMDEST = T2211-KMDEST"}
CE4S_AL ?--* T2215 {label: "CE4S_AL-KMFLTN = T2215-KMFLTN"}
CE4S_AL ?--* T2216 {label: "CE4S_AL-KMFLTY = T2216-KMFLTY"}
CE4S_AL ?--* T2207 {label: "CE4S_AL-KMIATA = T2207-KMIATA"}
CE4S_AL ?--* T2213 {label: "CE4S_AL-KMLEGS = T2213-KMLEGS"}
CE4S_AL ?--* T2208 {label: "CE4S_AL-KMOPDY = T2208-KMOPDY"}
CE4S_AL ?--* T2212 {label: "CE4S_AL-KMORIG = T2212-KMORIG"}
CE4S_AL ?--* T2210 {label: "CE4S_AL-KMROUT = T2210-KMROUT"}
CE4S_AL ?--* T2214 {label: "CE4S_AL-KMZONE = T2214-KMZONE"}
CE4S_AL ?--* KNA1 {label: "CE4S_AL-KNDNR = KNA1-KUNNR"}
CE4S_AL ?--* TKA01 {label: "CE4S_AL-KOKRS = TKA01-KOKRS"}
CE4S_AL ?--* CKPH {label: "CE4S_AL-KSTRG = CKPH-KSTRG"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWBKPZ_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWBLOK_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWFLHR_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWFLKM_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWFUEL_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWPAXS_ME = T006-MSEHI"}
CE4S_AL ?--* T006 {label: "CE4S_AL-KWSEAT_ME = T006-MSEHI"}
CE4S_AL 1--* T000 {label: "CE4S_AL-MANDT = T000-MANDT"}
CE4S_AL ?--* T006 {label: "CE4S_AL-MEINH = T006-MSEHI"}
CE4S_AL ?--* CEPC {label: "CE4S_AL-PPRCTR = CEPC-PRCTR"}
CE4S_AL ?--* CEPC {label: "CE4S_AL-PRCTR = CEPC-PRCTR"}
CE4S_AL ?--* PRPS {label: "CE4S_AL-PSPNR = PRPS-PSPNR"}
CE4S_AL ?--* TSPA {label: "CE4S_AL-SPART = TSPA-SPART"}
CE4S_AL ?--* TVKO {label: "CE4S_AL-VKORG = TVKO-VKORG"}
CE4S_AL ?--* TVTW {label: "CE4S_AL-VTWEG = TVTW-VTWEG"}
CE4S_AL ?--* T001W {label: "CE4S_AL-WERKS = T001W-WERKS"}

E-R Diagram for table CE4S_AL (Airline Route Profit)

Foreign Key tables (27)

AUFK {Order master data}
CEPC {Profit Center Master Data Table}
CKPH {Master Record: Cost Object ID Number}
KNA1 {General Data in Customer Master}
MARA {General Material Data}
PRPS {WBS (Work Breakdown Structure) Element Master Data}
T000 {Clients}
T001 {Company Codes}
T001W {Plants/Branches}
T006 {Units of Measurement}
T2207 {Values for Characteristic "IATA Season "}
T2208 {Values for Characteristic "Day of Operation "}
T2209 {Values for Characteristic "Aircraft Type "}
T2210 {Values for Characteristic "Rotation "}
T2211 {Values for Characteristic "Destination "}
T2212 {Values for Characteristic "Departure Location "}
T2213 {Values for Characteristic "Flight Segment "}
T2214 {Values for Characteristic "Region "}
T2215 {Values for Characteristic "Flight Number "}
T2216 {Values for Characteristic "Flight Type "}
TGSB {Business Areas}
TKA01 {Controlling Areas}
TSPA {Organizational Unit: Sales Divisions}
TVFK {Billing: Document Types}
TVKO {Organizational Unit: Sales Organizations}
TVTW {Organizational Unit: Distribution Channels}
VBUK {Sales Document: Header Status and Administrative Data}