SAP ABAP Table GLE_MCA_STR_BSEG (MCA STR BSEG)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-GL-CU-MCA (Application Component) Multi Currency Accounting
⤷ FAGL_MCA_AL_GEN (Package) FI: MCA General Functions
⤷ FI-GL-CU-MCA (Application Component) Multi Currency Accounting
⤷ FAGL_MCA_AL_GEN (Package) FI: MCA General Functions
Basic Data
Table Category | INTTAB | Structure |
Structure | GLE_MCA_STR_BSEG | Table Relationship Diagram |
Short Description | MCA STR BSEG |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | MCA Key Fields BSEG | |||||
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
4 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
6 | .INCLUDE | 0 | 0 | MCA document line (reduced number of fields) | |||||
7 | NEWBK | NEWBK | BUKRS | CHAR | 4 | 0 | Company Code for the Next Line Item | T001 | |
8 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
9 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
10 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
11 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
12 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
13 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
14 | PARGB | PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | TGSB | |
15 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
16 | DMBTR | GLE_MCA_DTE_DMBTR | WERTV12 | CURR | 23 | 2 | Amount Local Currency | ||
17 | WRBTR | GLE_MCA_DTE_WRBTR | WERTV12 | CURR | 23 | 2 | Amount in Document Currency | ||
18 | MWSTS | MWSTS | WERT7 | CURR | 13 | 2 | Tax Amount in Local Currency | ||
19 | WMWST | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
20 | FWBAS | FWBAS | WERT7 | CURR | 13 | 2 | Tax Base Amount in Document Currency | ||
21 | QSSHB | QSSHB | WERT7 | CURR | 13 | 2 | Withholding Tax Base Amount | ||
22 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
23 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
24 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
25 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | T880 | |
26 | BEWAR | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | T856 | |
27 | ALTKT | BILKT_SKA1 | SAKNR | CHAR | 10 | 0 | Group Account Number | * | |
28 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
29 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
30 | VBEL2 | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | VBUK | |
31 | POSN2 | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP | |
32 | ETEN2 | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | VBEP | |
33 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | ANLH | |
34 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ANLA | |
35 | ANBWA | ANBWA | BWASL | CHAR | 3 | 0 | Asset Transaction Type | TABW | |
36 | BZDAT | BZDAT | DATUM | DATS | 8 | 0 | Asset Value Date | ||
37 | XUMSW | XUMSW | XFELD | CHAR | 1 | 0 | Indicator: Sales-Related Item ? | ||
38 | XKRES | XKRES | XFELD | CHAR | 1 | 0 | Indicator: Can Line Items Be Displayed by Account? | ||
39 | XOPVW | XOPVW | XFELD | CHAR | 1 | 0 | Indicator: Open Item Management? | ||
40 | XSKRL | XSKRL | XFELD | CHAR | 1 | 0 | Indicator: Line item not liable to cash discount? | ||
41 | XNCOP | XNCOP | XFELD | CHAR | 1 | 0 | Indicator: Items Cannot Be Copied? | ||
42 | XZAHL | XZAHL | XFELD | CHAR | 1 | 0 | Indicator: Is Posting Key Used in a Payment Transaction? | ||
43 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
44 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
45 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
46 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
47 | XBILK | XBILK | XFELD | CHAR | 1 | 0 | Indicator: Account is a balance sheet account? | ||
48 | GVTYP | GVTYP | CHAR2 | CHAR | 2 | 0 | P&L statement account type | ||
49 | SKFBT | SKFBT | WERT7 | CURR | 13 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
50 | WSKTO | WSKTO | WERT7 | CURR | 13 | 2 | Cash Discount Amount in Document Currency | ||
51 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | * | |
52 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | * | |
53 | QSFBT | QSFBT | WERT7 | CURR | 13 | 2 | Withholding Tax-Exempt Amount (in Document Currency) | ||
54 | BUALT | BUALT | WERTV7 | CURR | 13 | 2 | Amount posted in alternative price control | ||
55 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
56 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
57 | EGRUP | JV_EGROUP | JV_EGROUP | CHAR | 3 | 0 | Equity group | * | |
58 | VERTT | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
59 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
60 | PROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
61 | DMBE2 | GLE_MCA_DTE_DMBE2 | WERTV12 | CURR | 23 | 2 | Amount in Second Local Currency | ||
62 | DMBE3 | GLE_MCA_DTE_DMBE3 | WERTV12 | CURR | 23 | 2 | Amount in Third Local Currency | ||
63 | LOKKT | ALTKT_SKB1 | SAKNR | CHAR | 10 | 0 | Alternative Account Number in Company Code | * | |
64 | PPRCT | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
65 | FKBER | FKBER_SHORT | FKBER_SHORT | CHAR | 4 | 0 | Functional Area | ||
66 | FKBER_LONG | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
67 | AUGGJ | AUGGJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of Clearing Document | ||
68 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | TCURC | |
69 | PSWBT | GLE_MCA_DTE_PSWBT | WERTV12 | CURR | 23 | 2 | Amount for Updating in General Ledger | ||
70 | XAUTO | XAUTO | XFELD | CHAR | 1 | 0 | Indicator: Line item automatically created | ||
71 | .INCLUDE | 0 | 0 | ||||||
72 | ACCOUNT | GLE_MCA_DTE_ACCOUNT | GLE_MCA_ACCOUNT | CHAR | 10 | 0 | Account Item | ||
73 | .INCLUDE | 0 | 0 | Additional Information of posting line items on screen | |||||
74 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
75 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
76 | HWAE2 | HWAE2 | WAERS | CUKY | 5 | 0 | Currency Key of Second Local Currency | * | |
77 | HWAE3 | HWAE3 | WAERS | CUKY | 5 | 0 | Currency Key of Third Local Currency | * | |
78 | KURSF | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
79 | KURS2 | KURS2 | KURSF | DEC | 9 | 5 | Exchange Rate for the Second Local Currency | ||
80 | KURS3 | KURS3 | KURSF | DEC | 9 | 5 | Exchange Rate for the Third Local Currency | ||
81 | KURSX | GLE_FXR_DTE_RATEX28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate | ||
82 | KUR2X | GLE_FXR_DTE_RATE2X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 2 | ||
83 | KUR3X | GLE_FXR_DTE_RATE3X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 3 | ||
84 | FLAG | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
85 | CHEXRAT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
86 | CHEXRAT2 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
87 | CHEXRAT3 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
88 | HD_BUKRS | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
89 | XFC1 | GLE_MCA_XFC | BOOLEAN | CHAR | 1 | 0 | Functional Currency | ||
90 | XFC2 | GLE_MCA_XFC | BOOLEAN | CHAR | 1 | 0 | Functional Currency | ||
91 | XFC3 | GLE_MCA_XFC | BOOLEAN | CHAR | 1 | 0 | Functional Currency | ||
92 | KURSF_INT | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
93 | KURS2_INT | KURS2 | KURSF | DEC | 9 | 5 | Exchange Rate for the Second Local Currency | ||
94 | KURS3_INT | KURS3 | KURSF | DEC | 9 | 5 | Exchange Rate for the Third Local Currency | ||
95 | KURSX_INT | GLE_FXR_DTE_RATEX28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate | ||
96 | KUR2X_INT | GLE_FXR_DTE_RATE2X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 2 | ||
97 | KUR3X_INT | GLE_FXR_DTE_RATE3X28 | GLE_FXR_RATEX28 | DEC | 28 | 14 | Market Data Exchange Rate 3 | ||
98 | IINP1 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
99 | IINP2 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
100 | IINP3 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
101 | FAUS1 | FAUS1 | FA050 | CHAR | 50 | 0 | Account/Posting Key Field Selection | ||
102 | FAUS2 | FAUS1 | FA050 | CHAR | 50 | 0 | Account/Posting Key Field Selection | ||
103 | RDIF1 | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
104 | RDIF2 | DMBE2 | WERT7 | CURR | 13 | 2 | Amount in Second Local Currency | ||
105 | RDIF3 | DMBE3 | WERT7 | CURR | 13 | 2 | Amount in Third Local Currency | ||
106 | .INCLUDE | 0 | 0 | ||||||
107 | .INCLUDE | 0 | 0 | Average Daily Balance: Average Activity | |||||
108 | AVGACT_G | GLE_DTE_ADB_AVG_ACT_G_DI | CHAR | 26 | 0 | Monthly Average Activity in Group Currency (Direct Input) | |||
109 | AVGACT_L | GLE_DTE_ADB_AVG_ACT_L_DI | CHAR | 26 | 0 | Monthly Average Activity in Local Currency (Direct Input) | |||
110 | AVGACT_T | GLE_DTE_ADB_AVG_ACT_T_DI | CHAR | 26 | 0 | Monthly Average Activity in Transaction Currency (Dir.Input) | |||
111 | AVG_ACT_G_CURR | GLE_DTE_ADB_AVG_ACT_G_CURR_DI | CUKY | 5 | 0 | Group Currency for Monthly Average Activity (Direct Input) | |||
112 | AVG_ACT_L_CURR | GLE_DTE_ADB_AVG_ACT_L_CURR_DI | CUKY | 5 | 0 | Local Currency for Monthly Average Activity (Direct Input) | |||
113 | AVG_ACT_T_CURR | GLE_DTE_ADB_AVG_ACT_T_CURR_DI | CUKY | 5 | 0 | Transaction Crcy for Monthly Average Activity (Direct Input) | |||
114 | XREF1 | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
115 | XREF2 | XREF2 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
116 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | GLE_MCA_STR_BSEG | ANBWA | TABW | BWASL | |||
2 | GLE_MCA_STR_BSEG | ANLN1 | ANLH | ANLN1 | |||
3 | GLE_MCA_STR_BSEG | ANLN2 | ANLA | ANLN2 | |||
4 | GLE_MCA_STR_BSEG | AUFNR | AUFK | AUFNR | |||
5 | GLE_MCA_STR_BSEG | BEWAR | T856 | TRTYP | |||
6 | GLE_MCA_STR_BSEG | BSCHL | TBSL | BSCHL | |||
7 | GLE_MCA_STR_BSEG | ETEN2 | VBEP | ETENR | |||
8 | GLE_MCA_STR_BSEG | GSBER | TGSB | GSBER | |||
9 | GLE_MCA_STR_BSEG | KOSTL | CSKS | KOSTL | |||
10 | GLE_MCA_STR_BSEG | KUNNR | KNA1 | KUNNR | |||
11 | GLE_MCA_STR_BSEG | LIFNR | LFA1 | LIFNR | |||
12 | GLE_MCA_STR_BSEG | MWSKZ | T007A | MWSKZ | |||
13 | GLE_MCA_STR_BSEG | NEWBK | T001 | BUKRS | |||
14 | GLE_MCA_STR_BSEG | PARGB | TGSB | GSBER | |||
15 | GLE_MCA_STR_BSEG | POSN2 | VBUP | POSNR | |||
16 | GLE_MCA_STR_BSEG | PSWSL | TCURC | WAERS | C | CN | |
17 | GLE_MCA_STR_BSEG | VBEL2 | VBUK | VBELN | |||
18 | GLE_MCA_STR_BSEG | VBUND | T880 | RCOMP |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 701 |