SAP ABAP Table FTPT_HOTEL (Travel Request Item - Hotel Service), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `FTPT_HOTEL` {Travel Request Item - Hotel Service}

Home

                title {label: "SAP ABAP table FTPT_HOTEL {Travel Request Item - Hotel Service}", size: "20"}

# Entities

[FTPT_HOTEL] {bgcolor: "tomato"}
*MANDT {label: "CLNT (3)"}
*PERNR {label: "NUMC (8)"}
*REINR {label: "NUMC (10)"}
*PLANNR {label: "NUMC (2)"}
*VARIANT {label: "NUMC (2)"}
*VARIANTVRS {label: "NUMC (2)"}
*+ITEM {label: "NUMC (3)"}
*SERVICE {label: "NUMC (3)"}
+HOTEL {label: "CHAR (3)"}
+LOC {label: "CHAR (3)"}
+CURRENCY {label: "CUKY (5)"}
+MEMBSHIP_KRZL {label: "CHAR (3)"}
+FLIGHT_MEM_KRZL {label: "CHAR (3)"}
+PNR_NR {label: "INT2 (5)"}
+CATALOGUE_ID {label: "CHAR (8)"}
+PREF1 {label: "CHAR (3)"}
+PREF2 {label: "CHAR (3)"}
+PREF3 {label: "CHAR (3)"}

[FTPT_ITEM] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*PERNR {label: "NUMC (8)"}
*REINR {label: "NUMC (10)"}
*PLANNR {label: "NUMC (2)"}
*VARIANT {label: "NUMC (2)"}
*+VARIANTVRS {label: "NUMC (2)"}
*ITEM {label: "NUMC (3)"}

[FTPT_PNR] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*PERNR {label: "NUMC (8)"}
*REINR {label: "NUMC (10)"}
*PLANNR {label: "NUMC (2)"}
*VARIANT {label: "NUMC (2)"}
*+VARIANTVRS {label: "NUMC (2)"}
*PNR_NR {label: "INT2 (5)"}

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

[TA21P] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*CATEGORY {label: "CHAR (1)"}
*PROVIDER {label: "CHAR (3)"}

[TA21PF] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*PROVCAT {label: "CHAR (1)"}
*+PROVIDER {label: "CHAR (3)"}
*KRZL {label: "CHAR (3)"}

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

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

# Relationships

FTPT_HOTEL *--* TA21PH {label: "FTPT_HOTEL-CATALOGUE_ID = TA21PH-HOTEL_ID"}
FTPT_HOTEL 1--* TCURC {label: "FTPT_HOTEL-CURRENCY = TCURC-WAERS"}
FTPT_HOTEL ?--* TA21PF {label: "FTPT_HOTEL-FLIGHT_MEM_KRZL = TA21PF-KRZL"}
FTPT_HOTEL 1--* TA21P {label: "FTPT_HOTEL-HOTEL = TA21P-PROVIDER"}
FTPT_HOTEL 1--* FTPT_ITEM {label: "FTPT_HOTEL-ITEM = FTPT_ITEM-VARIANTVRS"}
FTPT_HOTEL 1--* TA21L {label: "FTPT_HOTEL-LOC = TA21L-LOCID"}
FTPT_HOTEL ?--* TA21PF {label: "FTPT_HOTEL-MEMBSHIP_KRZL = TA21PF-KRZL"}
FTPT_HOTEL 1--* FTPT_PNR {label: "FTPT_HOTEL-PNR_NR = FTPT_PNR-VARIANTVRS"}
FTPT_HOTEL ?--* TA21P {label: "FTPT_HOTEL-PREF1 = TA21P-PROVIDER"}
FTPT_HOTEL ?--* TA21P {label: "FTPT_HOTEL-PREF2 = TA21P-PROVIDER"}
FTPT_HOTEL ?--* TA21P {label: "FTPT_HOTEL-PREF3 = TA21P-PROVIDER"}

E-R Diagram for table FTPT_HOTEL (Travel Request Item - Hotel Service)

Foreign Key tables (7)

FTPT_ITEM {Travel Service Request Item}
FTPT_PNR {Elements of passenger name records of travel plan variant}
TA21L {IATA Locations}
TA21P {Travel Service Providers}
TA21PF {Provider-Specific Customer Programs}
TA21PH {Customer-Specific Hotel Catalog}
TCURC {Currency Codes}

SAP ABAP Table FTPT_HOTEL {Travel Request Item - Hotel Service}

Foreign Key tables (7)

SAP ABAP Table `FTPT_HOTEL` {Travel Request Item - Hotel Service}