SAP ABAP Table REGUE (Line items from the settlement in the payment proposal)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBZ (Package) Payments
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBZ (Package) Payments
Basic Data
Table Category | INTTAB | Structure |
Structure | REGUE | Table Relationship Diagram |
Short Description | Line items from the settlement in the payment proposal |
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 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
2 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
3 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
4 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
5 | FILKD | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
6 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
7 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
8 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
9 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
10 | POKEN | POKEN | CHAR3 | CHAR | 3 | 0 | Item Indicator | ||
11 | SRID | SSC_OBJECT_ID | SSC_OBJECT_ID | CHAR | 10 | 0 | Shared Services Center: CRM Service Request | ||
12 | XCLOSED | SSC_SRCLOSED | BOOLE | CHAR | 1 | 0 | service request is closed | ||
13 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
14 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
15 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
16 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
17 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
18 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
19 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
20 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
21 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
22 | UMSKS | UMSKS | UMSKS | CHAR | 1 | 0 | Special G/L Transaction Type | ||
23 | ZUMSK | DZUMSK | UMSKZ | CHAR | 1 | 0 | Target Special G/L Indicator | * | |
24 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
25 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
26 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
27 | BDIFF | BDIFF | WRTV7 | CURR | 13 | 2 | Valuation Difference | ||
28 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
29 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
30 | MWSTS | MWSTS | WERT7 | CURR | 13 | 2 | Tax Amount in Local Currency | ||
31 | WMWST | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
32 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
33 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
34 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
35 | ZBD1T | DZBD1T | ZBDXT | DEC | 3 | 0 | Cash discount days 1 | ||
36 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
37 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
38 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
39 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
40 | SKFBT | SKFBT | WERT7 | CURR | 13 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
41 | SKNTO | SKNTO | WERT7 | CURR | 13 | 2 | Cash discount amount in local currency | ||
42 | WSKTO | WSKTO | WERT7 | CURR | 13 | 2 | Cash Discount Amount in Document Currency | ||
43 | SKVHW | SKVHW | WERT7 | CURR | 13 | 2 | Lost Cash Discount in Local Currency | ||
44 | SKVFW | SKVFW | WERT7 | CURR | 13 | 2 | Lost Cash Discount in Payment Currency | ||
45 | DSKVH | DSKVH | WERT7 | CURR | 13 | 2 | Impending Lost Cash Discount in Local Currency | ||
46 | ZBFIX | DZBFIX | ZBFIX | CHAR | 1 | 0 | Fixed Payment Terms | ||
47 | XNETB | XNETB | XFELD | CHAR | 1 | 0 | Indicator: Document posted net ? | ||
48 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | T008 | |
49 | SPLEV | SPLEV | SPLEV | CHAR | 1 | 0 | Level on Which a Payment Block has Taken Place | ||
50 | XREBZ | XREBZ | XFELD | CHAR | 1 | 0 | Indicator: Item is an Invoice-Related Credit Memo | ||
51 | ZOLLT | DZOLLT | ZOLLT | CHAR | 8 | 0 | Customs Tariff Number | ||
52 | ZOLLD | DZOLLD | DATUM | DATS | 8 | 0 | Customs Date | ||
53 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | * | |
54 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | * | |
55 | DIEKZ | DIEKZ | DIEKZ | CHAR | 1 | 0 | Service indicator (foreign payment) | ||
56 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
57 | QSSHB | QSSHB | WERT7 | CURR | 13 | 2 | Withholding Tax Base Amount | ||
58 | QBSHB | QBSHB | WERT7 | CURR | 13 | 2 | Withholding Tax Amount (in Document Currency) | ||
59 | QBSHH | QBSHH | WERT7 | CURR | 13 | 2 | Withholding Tax Amount (in Local Currency) | ||
60 | ESRNR | ESRNR | ESRNR | CHAR | 11 | 0 | POR subscriber number | ||
61 | ESRRE | ESRRE | ESRRE | CHAR | 27 | 0 | POR reference number | ||
62 | ESRPZ | ESRPZ | CHAR2 | CHAR | 2 | 0 | POR check digit | ||
63 | ZBDXT | DZBDXT | ZBDXT | DEC | 3 | 0 | Selected cash discount days | ||
64 | ZBDXP | DZBDXP | PRZ23 | DEC | 5 | 3 | Selected cash discount percentage rate | ||
65 | PROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
66 | VBEL2 | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
67 | POSN2 | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
68 | ETEN2 | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
69 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
70 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
71 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
72 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
73 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
74 | ZEKKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
75 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
76 | XANET | XANET | XFELD | CHAR | 1 | 0 | Indicator: Down Payment in Net Procedure? | ||
77 | INSEL | INSEL | NUM01 | NUMC | 1 | 0 | Indicator: Partial Selection of Postings | ||
78 | VBLNR | VBLNR | BELNR | CHAR | 10 | 0 | Document Number of the Payment Document | ||
79 | TYPAE | TYPAE | CHAR1 | CHAR | 1 | 0 | Type of Change | ||
80 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
81 | BDIF2 | BDIF2 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Second Local Currency | ||
82 | BDIF3 | BDIF3 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Third Local Currency | ||
83 | DMBE2 | DMBE2 | WERT7 | CURR | 13 | 2 | Amount in Second Local Currency | ||
84 | DMBE3 | DMBE3 | WERT7 | CURR | 13 | 2 | Amount in Third Local Currency | ||
85 | MWST2 | MWST2 | WERT7 | CURR | 13 | 2 | Tax Amount in Second Local Currency | ||
86 | MWST3 | MWST3 | WERT7 | CURR | 13 | 2 | Tax Amount in Third Local Currency | ||
87 | SKNT2 | SKNT2 | WERT7 | CURR | 13 | 2 | Cash Discount Amount in Second Local Currency | ||
88 | SKNT3 | SKNT3 | WERT7 | CURR | 13 | 2 | Cash Discount Amount in Third Local Currency | ||
89 | QBSH2 | QBSH2 | WERT7 | CURR | 13 | 2 | Withholding Tax Amount in Second Local Currency | ||
90 | QBSH3 | QBSH3 | WERT7 | CURR | 13 | 2 | Withholding Tax Amount in Third Local Currency | ||
91 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
92 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
93 | EMPFB | EMPFB | MAXKK | CHAR | 10 | 0 | Payee/Payer | ||
94 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
95 | XREF1 | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
96 | XREF2 | XREF2 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
97 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
98 | DTWS1 | DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | * | |
99 | DTWS2 | DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | * | |
100 | DTWS3 | DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | * | |
101 | DTWS4 | DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | * | |
102 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
103 | VBEWA | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
104 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
105 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
106 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
107 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
108 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
109 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
110 | XSAEN | XSAEN | XFELD | CHAR | 1 | 0 | Indicator: Unconfirmed master data change | ||
111 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | * | |
112 | PSWBT | PSWBT | WERT7 | CURR | 13 | 2 | Amount for Updating in General Ledger | ||
113 | PSSKT | PSSKT | WRTV7 | CURR | 13 | 2 | Cash Discount Deduction for the Item | ||
114 | KEYNO | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
115 | PENLC1 | PENALTY1 | WERT13 | CURR | 13 | 2 | Penalty Charge Amount in First Local Currency | ||
116 | PENLC2 | PENALTY2 | WERT13 | CURR | 13 | 2 | Penalty Charge Amount in Second Local Currency | ||
117 | PENLC3 | PENALTY3 | WERT13 | CURR | 13 | 2 | Penalty Charge Amount in Third Local Currency | ||
118 | PENFC | PENALTY | WERT13 | CURR | 13 | 2 | Penalty Charge Amount in Document Currency | ||
119 | PENDAYS | PDAYS | INT4 | INT4 | 10 | 0 | Number of Days for Penalty Charge Calculation |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REGUE | ZLSPR | T008 | ZAHLS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |