SAP ABAP Table PCFT_BSP_EXAMPLE_BOOK (Blueprint for Database Table SBOOK), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `PCFT_BSP_EXAMPLE_BOOK` {Blueprint for Database Table SBOOK}

Home

                title {label: "SAP ABAP table PCFT_BSP_EXAMPLE_BOOK {Blueprint for Database Table SBOOK}", size: "20"}

# Entities

[PCFT_BSP_EXAMPLE_BOOK] {bgcolor: "tomato"}
+MANDT {label: "CLNT (3)"}
+CARRID {label: "CHAR (3)"}
+CONNID {label: "NUMC (4)"}
+FLDATE {label: "DATS (8)"}
+CUSTOMID {label: "NUMC (8)"}
+WUNIT {label: "UNIT (3)"}
+FORCURKEY {label: "CUKY (5)"}
+LOCCURKEY {label: "CUKY (5)"}
+COUNTER {label: "NUMC (8)"}
+AGENCYNUM {label: "NUMC (8)"}

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

[SCOUNTER] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+CARRID {label: "CHAR (3)"}
*COUNTNUM {label: "NUMC (8)"}

[SCURX] {bgcolor: "#d0e0d0"}
*CURRKEY {label: "CUKY (5)"}

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

[SFLIGHT] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+CARRID {label: "CHAR (3)"}
*+CONNID {label: "NUMC (4)"}
*FLDATE {label: "DATS (8)"}

[SPFLI] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+CARRID {label: "CHAR (3)"}
*CONNID {label: "NUMC (4)"}

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

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

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

# Relationships

PCFT_BSP_EXAMPLE_BOOK 1--* STRAVELAG {label: "PCFT_BSP_EXAMPLE_BOOK-AGENCYNUM = STRAVELAG-AGENCYNUM"}
PCFT_BSP_EXAMPLE_BOOK 1--* SCARR {label: "PCFT_BSP_EXAMPLE_BOOK-CARRID = SCARR-CARRID"}
PCFT_BSP_EXAMPLE_BOOK *--* SPFLI {label: "PCFT_BSP_EXAMPLE_BOOK-CONNID = SPFLI-CONNID"}
PCFT_BSP_EXAMPLE_BOOK 1--* SCOUNTER {label: "PCFT_BSP_EXAMPLE_BOOK-COUNTER = SCOUNTER-COUNTNUM"}
PCFT_BSP_EXAMPLE_BOOK 1--* SCUSTOM {label: "PCFT_BSP_EXAMPLE_BOOK-CUSTOMID = SCUSTOM-ID"}
PCFT_BSP_EXAMPLE_BOOK 1--* SFLIGHT {label: "PCFT_BSP_EXAMPLE_BOOK-FLDATE = SFLIGHT-FLDATE"}
PCFT_BSP_EXAMPLE_BOOK 1--* SCURX {label: "PCFT_BSP_EXAMPLE_BOOK-FORCURKEY = SCURX-CURRKEY"}
PCFT_BSP_EXAMPLE_BOOK 1--* SCURX {label: "PCFT_BSP_EXAMPLE_BOOK-LOCCURKEY = SCURX-CURRKEY"}
PCFT_BSP_EXAMPLE_BOOK *--* T000 {label: "PCFT_BSP_EXAMPLE_BOOK-MANDT = T000-MANDT"}
PCFT_BSP_EXAMPLE_BOOK *--* T006 {label: "PCFT_BSP_EXAMPLE_BOOK-WUNIT = T006-MSEHI"}

E-R Diagram for table PCFT_BSP_EXAMPLE_BOOK (Blueprint for Database Table SBOOK)

Foreign Key tables (9)

SCARR {Airline}
SCOUNTER {Sales counter}
SCURX {Currency for Workbench training data model BC_Travel}
SCUSTOM {Flight customers}
SFLIGHT {Flight}
SPFLI {Flight schedule}
STRAVELAG {Travel agency}
T000 {Clients}
T006 {Units of Measurement}

SAP ABAP Table PCFT_BSP_EXAMPLE_BOOK {Blueprint for Database Table SBOOK}

Foreign Key tables (9)

SAP ABAP Table `PCFT_BSP_EXAMPLE_BOOK` {Blueprint for Database Table SBOOK}