SAP ABAP Table BSISEXT (Secondary Index BSIS Plus Enhancement Section (BSEGA))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FREP (Package) RF reporting
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FREP (Package) RF reporting
Basic Data
Table Category | INTTAB | Structure |
Structure | BSISEXT | Table Relationship Diagram |
Short Description | Secondary Index BSIS Plus Enhancement Section (BSEGA) |
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 | Accounting: Secondary Index for G/L Accounts | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
5 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
6 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
7 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
8 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
9 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
10 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
11 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
12 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
13 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
14 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
15 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
16 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
17 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
18 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
19 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
20 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
21 | FKONT | FIPLS | FIPLS | NUMC | 3 | 0 | Financial Budget Item | ||
22 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
23 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
24 | MWSTS | MWSTS | WERT7 | CURR | 13 | 2 | Tax Amount in Local Currency | ||
25 | WMWST | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
26 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
27 | PROJN | PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
28 | AUFNR | AUFNR_NEU | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
29 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
30 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
31 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
32 | XOPVW | XOPVW | XFELD | CHAR | 1 | 0 | Indicator: Open Item Management? | ||
33 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
34 | BSTAT | BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
35 | BDIFF | BDIFF | WRTV7 | CURR | 13 | 2 | Valuation Difference | ||
36 | BDIF2 | BDIF2 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Second Local Currency | ||
37 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | T880 | |
38 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | TCURC | |
39 | WVERW | WVERW | WVERW | CHAR | 1 | 0 | Bill of Exchange Usage Type | ||
40 | DMBE2 | DMBE2 | WERT7 | CURR | 13 | 2 | Amount in Second Local Currency | ||
41 | DMBE3 | DMBE3 | WERT7 | CURR | 13 | 2 | Amount in Third Local Currency | ||
42 | MWST2 | MWST2 | WERT7 | CURR | 13 | 2 | Tax Amount in Second Local Currency | ||
43 | MWST3 | MWST3 | WERT7 | CURR | 13 | 2 | Tax Amount in Third Local Currency | ||
44 | BDIF3 | BDIF3 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Third Local Currency | ||
45 | RDIF3 | RDIF3 | WRTV7 | CURR | 13 | 2 | Exchange Rate Difference Realized for Third Local Currency | ||
46 | XRAGL | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
47 | PROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
48 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
49 | XSTOV | XSTOV | XFELD | CHAR | 1 | 0 | Indicator: Document is flagged for reversal | ||
50 | XARCH | XARCH | XFELD | CHAR | 1 | 0 | Indicator: Document already archived ? | ||
51 | PSWBT | PSWBT | WERT7 | CURR | 13 | 2 | Amount for Updating in General Ledger | ||
52 | XNEGP | XNEGP | XFELD | CHAR | 1 | 0 | Indicator: Negative posting | ||
53 | RFZEI | RFZEI_CC | NUM03 | NUMC | 3 | 0 | Payment Card Item | ||
54 | CCBTC | CCBTC | CCBTC | CHAR | 10 | 0 | Payment cards: Settlement run | ||
55 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
56 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | J_1BBRANCH | |
57 | PPDIFF | PPDIFF | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | ||
58 | PPDIF2 | PPDIF2 | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | ||
59 | PPDIF3 | PPDIF3 | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | ||
60 | BEWAR | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | T856 | |
61 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
62 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
63 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
64 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
65 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
66 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
67 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
68 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
69 | PPRCT | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
70 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
71 | AUGGJ | AUGGJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of Clearing Document | ||
72 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
73 | SEGMENT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | * | |
74 | PSEGMENT | FB_PSEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Partner Segment for Segmental Reporting | * | |
75 | PGEBER | FM_PFUND | BP_GEBER | CHAR | 10 | 0 | Partner Fund | * | |
76 | PGRANT_NBR | GM_GRANT_PARTNER | GM_GRANT_NBR | CHAR | 20 | 0 | Partner Grant | ||
77 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
78 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
79 | PBUDGET_PD | FM_PBUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Partner Budget Period | * | |
80 | .INCLU--AP | 0 | 0 | Local Authorities | |||||
81 | FIPEX | FM_FIPEX_DONT_USE | FM_FIPEX | CHAR | 24 | 0 | Commitment item - Do not use field - see note 447805 | * | |
82 | .INCLU--AP | 0 | 0 | Joint Venture Accounting | |||||
83 | PRODPER | JVA_PROD_MONTH | BUPER | ACCP | 6 | 0 | Produktionsmonat | ||
84 | .INCLU--AP | 0 | 0 | withholding Tax Code | |||||
85 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
86 | .INCLU--AP | 0 | 0 | Append zur Mandatsverwaltung BSIS | |||||
87 | .INCLUDE | 0 | 0 | Append Struktur für die Mandatsnummer | |||||
88 | PROPMANO | REHORECNNRM | RECNNR | CHAR | 13 | 0 | Mandate, Mandate-Opening Contract | ||
89 | .INCLUDE | 0 | 0 | Document Segment Enhancement Part | |||||
90 | DMSOL | DMSOL | WERT7 | CURR | 13 | 2 | Debit Amount in Local Currency | ||
91 | DMHAB | DMHAB | WERT7 | CURR | 13 | 2 | Credit Amount in Local Currency | ||
92 | DMSHB | DMSHB | WRTV7 | CURR | 13 | 2 | Amount in Local Currency with +/- Signs | ||
93 | WRSOL | WRSOL | WERT7 | CURR | 13 | 2 | Debit Amount in Document Currency | ||
94 | WRHAB | WRHAB | WERT7 | CURR | 13 | 2 | Credit Amount in Document Currency | ||
95 | WRSHB | WRSHB | WRTV7 | CURR | 13 | 2 | Foreign Currency Amount with Signs (+/-) | ||
96 | MDSHB | MDSHB | WRTV7 | CURR | 13 | 2 | Tax on Sales/Purchases amount in Local Curr. with +/- Sign | ||
97 | MWSHB | MWSHB | WRTV7 | CURR | 13 | 2 | Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign | ||
98 | FDSHB | FDSHB | WRTV7 | CURR | 13 | 2 | Planned Amount in Local Currency with +/- Sign | ||
99 | BLSHB | BLSHB | WRTV7 | CURR | 13 | 2 | Base Amount for Preference ( with +/- Signs ) | ||
100 | NETDT | NETDT | DATUM | DATS | 8 | 0 | Due Date for Net Payment | ||
101 | SK1DT | SK1DT | DATUM | DATS | 8 | 0 | Due Date for Cash Discount 1 | ||
102 | SK2DT | SK2DT | DATUM | DATS | 8 | 0 | Due Date for Cash Discount 2 | ||
103 | MENSH | MENSH | MENSH | QUAN | 13 | 3 | Quantity with +/- Sign | ||
104 | GKART | GKART | GKART | CHAR | 1 | 0 | Offsetting Account Type | ||
105 | GKONT | GKONT | GKONT | CHAR | 10 | 0 | Offsetting Account Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BSISEXT | AUFNR | AUFK | AUFNR | REF | C | CN |
2 | BSISEXT | BEWAR | T856 | TRTYP | REF | C | CN |
3 | BSISEXT | BLART | T003 | BLART | REF | 1 | CN |
4 | BSISEXT | BSCHL | TBSL | BSCHL | REF | 1 | CN |
5 | BSISEXT | BUPLA | J_1BBRANCH | BRANCH | KEY | 1 | CN |
6 | BSISEXT | GSBER | TGSB | GSBER | |||
7 | BSISEXT | MWSKZ | T007A | MWSKZ | REF | C | CN |
8 | BSISEXT | PROJK | PRPS | PSPNR | REF | C | CN |
9 | BSISEXT | PSWSL | TCURC | WAERS | REF | 1 | CN |
10 | BSISEXT | VBUND | T880 | RCOMP | REF | C | CN |
11 | BSISEXT | WAERS | TCURC | WAERS | REF | 1 | CN |
12 | BSISEXT | WERKS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |