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

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

Home

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

# Entities

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

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

[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_DET 1--* STRAVELAG {label: "PCFT_BSP_EXAMPLE_BOOK_DET-AGENCYNUM = STRAVELAG-AGENCYNUM"}
PCFT_BSP_EXAMPLE_BOOK_DET 1--* SCOUNTER {label: "PCFT_BSP_EXAMPLE_BOOK_DET-COUNTER = SCOUNTER-COUNTNUM"}
PCFT_BSP_EXAMPLE_BOOK_DET 1--* SCUSTOM {label: "PCFT_BSP_EXAMPLE_BOOK_DET-CUSTOMID = SCUSTOM-ID"}
PCFT_BSP_EXAMPLE_BOOK_DET 1--* SFLIGHT {label: "PCFT_BSP_EXAMPLE_BOOK_DET-FLDATE = SFLIGHT-FLDATE"}
PCFT_BSP_EXAMPLE_BOOK_DET 1--* SCURX {label: "PCFT_BSP_EXAMPLE_BOOK_DET-FORCURKEY = SCURX-CURRKEY"}
PCFT_BSP_EXAMPLE_BOOK_DET 1--* SCURX {label: "PCFT_BSP_EXAMPLE_BOOK_DET-LOCCURKEY = SCURX-CURRKEY"}
PCFT_BSP_EXAMPLE_BOOK_DET *--* T000 {label: "PCFT_BSP_EXAMPLE_BOOK_DET-MANDT = T000-MANDT"}
PCFT_BSP_EXAMPLE_BOOK_DET *--* T006 {label: "PCFT_BSP_EXAMPLE_BOOK_DET-WUNIT = T006-MSEHI"}

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

Foreign Key tables (7)

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

SAP ABAP Table PCFT_BSP_EXAMPLE_BOOK_DET {Blueprint for Database Table SBOOK}

Foreign Key tables (7)

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