SAP ABAP Table RERA_OP_ITEM_L (ALV GRID: Line Item Data for One-Time Postings)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-RA (Application Component) Rental Accounting
⤷ RE_RA_OP (Package) RE: One-Time Posting
⤷ RE-FX-RA (Application Component) Rental Accounting
⤷ RE_RA_OP (Package) RE: One-Time Posting
Basic Data
Table Category | INTTAB | Structure |
Structure | RERA_OP_ITEM_L | Table Relationship Diagram |
Short Description | ALV GRID: Line Item Data for One-Time Postings |
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 | ICON_DETAIL | RECAICONMARKED | RECAICON | CHAR | 137 | 0 | Selected Row (Detailed Info Is Displayed for this Row) | ||
2 | .INCLUDE | 0 | 0 | Line Item Data for One-Time Postings | |||||
3 | .INCLUDE | 0 | 0 | Screen Fields: Line Item Data for One-Time Postings | |||||
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
5 | OPACT | RERAOPACT | RERAOPACT | CHAR | 6 | 0 | Posting Activity | * | |
6 | HEADERNO | RERAOPHEADERNO | NUMC2 | NUMC | 2 | 0 | Sequence Number of Document | * | |
7 | ITEMNO | POSNR_ACC | POSNR_ACC | NUMC | 10 | 0 | Accounting Document Line Item Number | ||
8 | PROCESS | RECAPROCESS | RECAPROCESS | CHAR | 4 | 0 | Process | * | |
9 | ACCTYPE | RERAOPACCTYPE | RERAOPACCTYPE | CHAR | 1 | 0 | Account Type | ||
10 | DCINDICATOR | RERADCINDICATOR | RERADCINDICATOR | CHAR | 1 | 0 | Debit/Credit Indicator | ||
11 | SHINDICATOR | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
12 | BPITEMDEDUCT | RERAOPBPITEMDEDUCT | RERAOPBPITEMDEDUCT | CHAR | 1 | 0 | Derivation Logic for Partner for Line Item | ||
13 | VENDOR | RERAVENDORNO | RERAPARTNERNO | CHAR | 10 | 0 | Vendor number | ||
14 | CUSTOMER | RERACUSTOMERNO | RERAPARTNERNO | CHAR | 10 | 0 | Customer Number | ||
15 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
16 | GLACCOUNT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
17 | GLACCSYMB | RERAGLACCSYMB | RERAGLACCSYMB | CHAR | 15 | 0 | Account Determination: Account Symbols | * | |
18 | AMOUNT | RERAAMOUNT | RECACURR | CURR | 15 | 2 | Amount in Transaction Currency | ||
19 | TAXAMOUNT | RERATAXAMOUNT | RECACURR | CURR | 15 | 2 | Tax Amount in Transaction Currency | ||
20 | GROSSAMOUNT | RERAGROSSAMOUNT | RECACURR | CURR | 15 | 2 | Gross Amount in Transaction Currency | ||
21 | NETAMOUNT | RERANETAMOUNT | RECACURR | CURR | 15 | 2 | Net Amount in Transaction Currency | ||
22 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
23 | OBJNR | RERAOBJNR | J_OBJNR | CHAR | 22 | 0 | Account Assignment: Object Number | * | |
24 | CONDTYPE | RECDCONDTYPE | RECDCONDTYPE | CHAR | 4 | 0 | Condition Type | * | |
25 | FLOWTYPE | RECDFLOWTYPE | RECDFLOWTYPE | CHAR | 4 | 0 | Flow Type | * | |
26 | ISADVANCEPAYMENT | RECDADVANCEPAYMENT | RECABOOL | CHAR | 1 | 0 | Condition Is Advance Payment Condition | ||
27 | HASTAXFROMBASE | RERAOPHASTAXFROMBASE | RECABOOL | CHAR | 1 | 0 | Line Item Receives Tax Type and Group from Basic Data | ||
28 | HASMANUALTAX | RERAHASMANUALTAX | RECABOOL | CHAR | 1 | 0 | Manual Entry of Tax? | ||
29 | ISGROSS | RECDISGROSS | RECABOOL | CHAR | 1 | 0 | Condition Amount Is Gross Amount | ||
30 | TAXTYPE | RERATAXTYPE | RERATAXTYPE | CHAR | 4 | 0 | Tax Type | * | |
31 | TAXGROUP | RERATAXGROUP | RERATAXGROUP | CHAR | 20 | 0 | Tax Group | * | |
32 | TAXGROUPID | RERATAXGROUPID | NUM03 | NUMC | 3 | 0 | Group Indicator for Tax Line Items | ||
33 | TAXDATE | RERATAXDATE | RECADATE | DATS | 8 | 0 | Date of Tax Calculation | ||
34 | TAXCOUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
35 | TAXSCHEME | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
36 | TAXRATE | RERATAXRATE | PRZ43V | DEC | 7 | 3 | Tax Rate | ||
37 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
38 | TXJCDISACTIVE | RECABOOL | RECABOOL | CHAR | 1 | 0 | General Yes/No Field | ||
39 | TERMNOOA | RETMTERMNO | RETMTERMNO | CHAR | 4 | 0 | Term Number | ||
40 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
41 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
42 | ADDOBJNR | RERAADDOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number for Additional Account Assignment | * | |
43 | FUND | RERAFUND | CHAR24 | CHAR | 24 | 0 | Fund | ||
44 | FUNDSCENTER | RERAFUNDSCENTER | CHAR24 | CHAR | 24 | 0 | Funds Center | ||
45 | COMMITMENTITEM | RERACOMMITMENTITEM | FM_FIPEX | CHAR | 24 | 0 | Commitment Item | * | |
46 | FUNCTIONALAREA | RERAFUNCTIONALAREA | CHAR24 | CHAR | 24 | 0 | Functional Area | ||
47 | GRANTNUMBER | RERAGRANTNUMBER | CHAR24 | CHAR | 24 | 0 | Grant | ||
48 | TERMNOPY | RETMTERMNO | RETMTERMNO | CHAR | 4 | 0 | Term Number | ||
49 | PYMTMETH | RERAPYMTMETH | CHAR4 | CHAR | 4 | 0 | Payment Method | ||
50 | PYMTBLOCK | RERAPYMTBLOCK | CHAR4 | CHAR | 4 | 0 | Payment block key | ||
51 | PYMTTERM | RERAPYMTTERM | ZTERM | CHAR | 4 | 0 | Terms of Payment Key | ||
52 | HASHOUSEBK | RERAOPHASHOUSEBK | RECABOOL | CHAR | 1 | 0 | Copy House Bank in Line Item | ||
53 | HOUSEBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
54 | HOUSEBKACC | RERAOPHOUSEBANKACCTID | HKTID | CHAR | 5 | 0 | House Bank Account ID | * | |
55 | BANKDETAILID | RERABANKDETAILID | CHAR15 | CHAR | 15 | 0 | Bank Details ID | ||
56 | NOTETOPAYEE | RERANOTETOPAYEE | RERANOTETOPAYEE | CHAR | 25 | 0 | Note to Payee | ||
57 | DUNNINGSTATUS | RERADUNNINGSTATUS | CHAR02 | CHAR | 2 | 0 | Dunning Status | ||
58 | DUNNAREA | RERADUNNAREA | CHAR4 | CHAR | 4 | 0 | Dunning Area | ||
59 | DUNNKEY | RERADUNNKEY | CHAR4 | CHAR | 4 | 0 | Dunning Keys | ||
60 | DUNNBLOCK | RERADUNNBLOCK | CHAR4 | CHAR | 4 | 0 | Dunning Block | ||
61 | ACCDETKEY | RERAACCDETKEY | RERAACCDETKEY | CHAR | 10 | 0 | Account Determination Value | * | |
62 | PARTNEROBJNR | RETMPARTNEROBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number for Internal Use | * | |
63 | ITEMTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
64 | ITEMTYPE | RERAITEMTYPE | CHAR02 | CHAR | 2 | 0 | Item Category | ||
65 | HASCPD | RERAOPHASCPD | RECABOOL | CHAR | 1 | 0 | Does the Line Item Allow Entering One-Time Data? | ||
66 | SWENR | REBDBENO | REBDBENO | CHAR | 8 | 0 | Business Entity Number | * | |
67 | SGENR | REBDBUNO | REBDBUNO | CHAR | 8 | 0 | Number of Building | ||
68 | SGRNR | REBDPRNO | REBDPRNO | CHAR | 8 | 0 | Number of Land | ||
69 | SMENR | REBDRONO | REBDRONO | CHAR | 8 | 0 | Number of Rental Object | ||
70 | RECNNR | RECNNUMBER | RECNNUMBER | CHAR | 13 | 0 | Contract Number | ||
71 | SNKSL | RESCSCKEY | RESCSCKEY | CHAR | 4 | 0 | Service Charge Key | * | |
72 | SCKEY | RERAOPSCKEY | RESCSCKEY | CHAR | 4 | 0 | Default Service Charge Key | * | |
73 | SEMPSL | RESCSUID | RESCSUID | CHAR | 5 | 0 | Settlement Unit | ||
74 | REFDATE | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
75 | PROPOSEREFDATE | RERAOPPROPOSEREFDATE | RECABOOL | CHAR | 1 | 0 | Propose Settlement Reference Date? | ||
76 | HASCN | RERAOPHASCN | RECABOOL | CHAR | 1 | 0 | Is Entering a Contract in Line Item Possible? | ||
77 | CNITEMDEDUCT | RERAOPCNITEMDEDUCT | RERAOPCNITEMDEDUCT | CHAR | 1 | 0 | Logic for Deriving Contract for Line Item | ||
78 | BALANCESHEETACCOUNT | RECABOOL | RECABOOL | CHAR | 1 | 0 | General Yes/No Field | ||
79 | OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
80 | ISOBJNRDEDOBL | RERAOPISOBJNRDEDOBL | RECABOOL | CHAR | 1 | 0 | Deriving Account Assignment Object Is Required | ||
81 | OBJNRDEDUCT | RERAOPOBJNRDEDUCT | RERAOPOBJNRDEDUCT | CHAR | 1 | 0 | Derivation Logic for Account Assignment Object of Line Item | ||
82 | OBJECTIDENT | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
83 | OBJTEXT | RECADESCRIPTION | RECAXLDESCRIPTION | CHAR | 60 | 0 | Object Description | ||
84 | BLINEDATE | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
85 | VALUEDATE | RERAVALUEDATE | RECADATE | DATS | 8 | 0 | Value Date | ||
86 | VALUEDATEDEDUCT | RERAOPVALUEDATEDEDUCT | RERAOPVALUEDATEDEDUCT | CHAR | 1 | 0 | Derivation of Value Date for One-Time Postings | ||
87 | ALLOCATIONNUMBER | RERAALLOCATIONNUMBER | CHAR | 18 | 0 | Assignment Number | |||
88 | HASDIST | RERAOPHASDIST | RECABOOL | CHAR | 1 | 0 | Is the Line Item a Distribution Item? | ||
89 | ISGENERATEDDISTITEM | RECABOOL | RECABOOL | CHAR | 1 | 0 | General Yes/No Field | ||
90 | DISTRULEEXT | RECDDISTRULEEXT | RECDDISTRULEEXT | CHAR | 4 | 0 | External Distribution Formula | * | |
91 | DISTRULEPARA1 | RECDDISTRULEPARA | CHAR | 70 | 0 | Untypified Parameter for a Distribution Formula | |||
92 | DISTRULEPARA2 | RECDDISTRULEPARA | CHAR | 70 | 0 | Untypified Parameter for a Distribution Formula | |||
93 | DISTVALUEFAC | RECDDISTVALUE | RECDDISTVALUE | DEC | 15 | 6 | Currency-Independent Distribution Factor | ||
94 | FSVARIANTIT | RERAOPFSVARIANTIT | CHAR | 4 | 0 | Field Status Variant for Line Item Data for One-Time Posting | |||
95 | FSTATE | RERAOPFIELDSTATE | CHAR | 250 | 0 | Field Selection String | |||
96 | PERCENTAMT | RERAOPPERCENTAMT | RERAOPPERCENTAMT | DEC | 8 | 5 | Share of the Full Document Amount in the Line Item | ||
97 | XFLOWTYPE | RECDXFLOWTYPE | TEXT30 | CHAR | 30 | 0 | Name of Flow Type | ||
98 | XBPNAME | RERAOPXBPNAME | CHAR50 | CHAR | 50 | 0 | Partner Name | ||
99 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
100 | XSCKEY | RESCXSCKEY | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Service Charge Key | ||
101 | XGLACCOUNT | RERAOPXGLACCOUNT | CHAR50 | CHAR | 50 | 0 | G/L Account Name | ||
102 | ISOPTIONALITEM | RERAOPISOPTIONALITEM | RECABOOL | CHAR | 1 | 0 | Line Item Is Optional | ||
103 | QUANTITY | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
104 | BASE_UOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
105 | TABDETAILTEXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
106 | SHSTRATSCKEY | RERASHSTRATSCKEY | RECASHSTRAT | CHAR | 12 | 0 | Search Strategy for Service Charge Key | * | |
107 | .INCLUDE | 0 | 0 | RE Posting Record Information for One-Time Data | |||||
108 | NAME | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
109 | NAME_2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
110 | NAME_3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
111 | NAME_4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
112 | POSTL_CODE | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
113 | CITY | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
114 | COUNTRY | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
115 | COUNTRY_ISO | LAND1_ISO | INTCA | CHAR | 2 | 0 | Country key in ISO code | ||
116 | STREET | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
117 | PO_BOX | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
118 | POBX_PCD | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
119 | POBK_CURAC | PSKTO | PSKTO | CHAR | 16 | 0 | Account Number of Bank Account At Post Office | ||
120 | BANK_ACCT | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
121 | BANK_NO | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
122 | BANK_CTRY | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
123 | BANK_CTRY_ISO | BANKS_ISO | INTCA | CHAR | 2 | 0 | Bank country key in ISO code | ||
124 | TAX_NO_1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
125 | TAX_NO_2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
126 | TAX | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
127 | EQUAL_TAX | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
128 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
129 | CTRL_KEY | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
130 | INSTR_KEY | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
131 | DME_IND | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
132 | LANGU_ISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
133 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
134 | SWIFT_CODE | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
135 | .INCLUDE | 0 | 0 | Attributes for Input Tax Correction | |||||
136 | TCOBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
137 | DATEOFSERVICE | REITTCDATEOFSERVICE | RECADATE | DATS | 8 | 0 | Date of Service | ||
138 | HASDIFFOPTRATE | REITHASDIFFOPTRATE | RECABOOL | CHAR | 1 | 0 | Has Differing Option Rate | ||
139 | DIFFOPTRATE | REITDIFFOPTRATE | REITOPTRATE | DEC | 9 | 6 | Differing Option Rate for Distribution | ||
140 | NOTAXCORR | REITNOTAXCORR | RECABOOL | CHAR | 1 | 0 | Do Not Consider Item in Input Tax Correction | ||
141 | TCNO | REITTCNO | REITTCNO | CHAR | 16 | 0 | Number of Correction Object | * | |
142 | TC_ASS_IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
143 | XTC | REITXTC | RECAXLDESCRIPTION | CHAR | 60 | 0 | Name of Correction Object | ||
144 | EXTREF1 | RERAEXTREF1 | CHAR | 60 | 0 | External Reference 1 (Line Item) | |||
145 | EXTREF2 | RERAEXTREF2 | CHAR | 60 | 0 | External Reference 2 (Line Item) | |||
146 | EXTREF3 | RERAEXTREF3 | CHAR | 60 | 0 | External Reference 3 (Line Item) | |||
147 | EXTREF4 | RERAEXTREF4 | CHAR | 60 | 0 | External Reference 4 (Line Item) | |||
148 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
149 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
150 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
151 | SEPAMNDID | RETMSEPAMNDID | RETMSEPAMNDID | CHAR | 35 | 0 | SEPA Mandate: Unique Reference to Mandate per Vendor | ||
152 | SEPARECCRDID | RETMSEPARECCRDID | RETMSEPACRDID | CHAR | 35 | 0 | SEPA Mandate: Creditor ID | ||
153 | .INCLUDE | 0 | 0 | Variable Values for One-Time Postings | |||||
154 | XBPNAME_OLD | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
155 | DOCDATE_OLD | RERADOCDATE | RECADATE | DATS | 8 | 0 | Document Date | ||
156 | EXTREFERENCENO_OLD | RERAEXTREFERENCENO | XBLNR1 | CHAR | 16 | 0 | External Document Reference | ||
157 | BLINEDATE_OLD | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
158 | O_SHFIELD_SCKEY | IF_RECA_SEARCH_FIELD | REF | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RERA_OP_ITEM_L | BANK_CTRY | T005 | LAND1 | |||
2 | RERA_OP_ITEM_L | BASE_UOM | T006 | MSEHI | |||
3 | RERA_OP_ITEM_L | REGION | T005S | BLAND |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 600 |