RERA_OP_ITEM_L SAP (ALV GRID: Line Item Data for One-Time Postings) Structure details
Description: ALV GRID: Line Item Data for One-Time Postings
Related tables to RERA_OP_ITEM_L
Access table RERA_OP_ITEM_L
Structure field list including key, data, relationships and ABAP select examples
RERA_OP_ITEM_L is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "ALV GRID: Line Item Data for One-Time Postings" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RERA_OP_ITEM_L TYPE RERA_OP_ITEM_L.
The RERA_OP_ITEM_L table consists of various fields, each holding specific information or linking keys about ALV GRID: Line Item Data for One-Time Postings data available in SAP. These include BUKRS (Company Code), OPACT (Posting Activity), HEADERNO (Sequence Number of Document), ITEMNO (Accounting Document Line Item Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP RERA_OP_ITEM_L structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ICON_DETAIL | Selected Row (Detailed Info Is Displayed for this Row) | RECAICONMARKED | CHAR | 137 | RECAICON | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
OPACT | Posting Activity | RERAOPACT | CHAR | 6 | Assigned to domain | RERAOPACT | |||
HEADERNO | Sequence Number of Document | RERAOPHEADERNO | NUMC | 2 | Assigned to domain | NUMC2 | |||
ITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | POSNR_ACC | ||||
PROCESS | Process | RECAPROCESS | CHAR | 4 | Assigned to domain | RECAPROCESS | RECAPROCESS | ||
ACCTYPE | Account Type | RERAOPACCTYPE | CHAR | 1 | RERAOPACCTYPE | ||||
DCINDICATOR | Debit/Credit Indicator | RERADCINDICATOR | CHAR | 1 | RERADCINDICATOR | ||||
SHINDICATOR | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
BPITEMDEDUCT | Derivation Logic for Partner for Line Item | RERAOPBPITEMDEDUCT | CHAR | 1 | RERAOPBPITEMDEDUCT | ||||
VENDOR | Vendor number | RERAVENDORNO | CHAR | 10 | ALPHA | RERAPARTNERNO | LIF | KRED_C | |
CUSTOMER | Customer Number | RERACUSTOMERNO | CHAR | 10 | ALPHA | RERAPARTNERNO | KUN | C_KUNNR | |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
GLACCOUNT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
GLACCSYMB | Account Determination: Account Symbols | RERAGLACCSYMB | CHAR | 15 | Assigned to domain | RERAGLACCSYMB | |||
AMOUNT | Amount in Transaction Currency | RERAAMOUNT | CURR | 15(2) | RECACURR | ||||
TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15(2) | RECACURR | ||||
GROSSAMOUNT | Gross Amount in Transaction Currency | RERAGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15(2) | RECACURR | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
OBJNR | Account Assignment: Object Number | RERAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
ISADVANCEPAYMENT | Condition Is Advance Payment Condition | RECDADVANCEPAYMENT | CHAR | 1 | RECABOOL | ||||
HASTAXFROMBASE | Line Item Receives Tax Type and Group from Basic Data | RERAOPHASTAXFROMBASE | CHAR | 1 | RECABOOL | ||||
HASMANUALTAX | Manual Entry of Tax? | RERAHASMANUALTAX | CHAR | 1 | RECABOOL | ||||
ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | RECABOOL | ||||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | Assigned to domain | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | Assigned to domain | RERATAXGROUP | |||
TAXGROUPID | Group Indicator for Tax Line Items | RERATAXGROUPID | NUMC | 3 | NUM03 | ||||
TAXDATE | Date of Tax Calculation | RERATAXDATE | DATS | 8 | RECADATE | ||||
TAXCOUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
TAXSCHEME | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | Assigned to domain | KALSM | |||
TAXRATE | Tax Rate | RERATAXRATE | DEC | 7(3) | PRZ43V | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
TXJCDISACTIVE | General Yes/No Field | RECABOOL | CHAR | 1 | RECABOOL | ||||
TERMNOOA | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
ADDOBJNR | Object Number for Additional Account Assignment | RERAADDOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
FUND | Fund | RERAFUND | CHAR | 24 | CHAR24 | ||||
FUNDSCENTER | Funds Center | RERAFUNDSCENTER | CHAR | 24 | CHAR24 | ||||
COMMITMENTITEM | Commitment Item | RERACOMMITMENTITEM | CHAR | 24 | Assigned to domain | FMCIL | FM_FIPEX | ||
FUNCTIONALAREA | Functional Area | RERAFUNCTIONALAREA | CHAR | 24 | CHAR24 | ||||
GRANTNUMBER | Grant | RERAGRANTNUMBER | CHAR | 24 | CHAR24 | ||||
TERMNOPY | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | CHAR4 | ||||
PYMTBLOCK | Payment block key | RERAPYMTBLOCK | CHAR | 4 | CHAR4 | SPE | |||
PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | ZTERM | ||||
HASHOUSEBK | Copy House Bank in Line Item | RERAOPHASHOUSEBK | CHAR | 1 | RECABOOL | ||||
HOUSEBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
HOUSEBKACC | House Bank Account ID | RERAOPHOUSEBANKACCTID | CHAR | 5 | Assigned to domain | HKTID | |||
BANKDETAILID | Bank Details ID | RERABANKDETAILID | CHAR | 15 | CHAR15 | ||||
NOTETOPAYEE | Note to Payee | RERANOTETOPAYEE | CHAR | 25 | RERANOTETOPAYEE | ||||
DUNNINGSTATUS | Dunning Status | RERADUNNINGSTATUS | CHAR | 2 | CHAR02 | ||||
DUNNAREA | Dunning Area | RERADUNNAREA | CHAR | 4 | CHAR4 | ||||
DUNNKEY | Dunning Keys | RERADUNNKEY | CHAR | 4 | CHAR4 | ||||
DUNNBLOCK | Dunning Block | RERADUNNBLOCK | CHAR | 4 | CHAR4 | ||||
ACCDETKEY | Account Determination Value | RERAACCDETKEY | CHAR | 10 | Assigned to domain | RERAACCDETKEY | |||
PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
ITEMTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ITEMTYPE | Item Category | RERAITEMTYPE | CHAR | 2 | CHAR02 | ||||
HASCPD | Does the Line Item Allow Entering One-Time Data? | RERAOPHASCPD | CHAR | 1 | RECABOOL | ||||
SWENR | Site Number | REBDBENO | CHAR | 8 | Assigned to domain | SWENR | REBDBENO | REBDBENO | REBDBENO |
SGENR | Number of Building | REBDBUNO | CHAR | 8 | SGENR | REBDBUNO | REBDBUNO | REBDBUNO | |
SGRNR | Number of Land | REBDPRNO | CHAR | 8 | SGRNR | REBDPRNO | REBDPRNO | REBDPRNO | |
SMENR | Number of Rental Object | REBDRONO | CHAR | 8 | SMENR | REBDRONO | REBDRONO | REBDRONO | |
RECNNR | Contract Number | RECNNUMBER | CHAR | 13 | ALPHA | RECNNUMBER | RECNNR | RECNCN | |
SNKSL | Service Charge Key | RESCSCKEY | CHAR | 4 | Assigned to domain | ALPHA | RESCSCKEY | RESCSCKEY | RESCSCKEY |
SCKEY | Default Service Charge Key | RERAOPSCKEY | CHAR | 4 | Assigned to domain | ALPHA | RESCSCKEY | ||
SEMPSL | Settlement Unit | RESCSUID | CHAR | 5 | ALPHA | RESCSUID | RESCSUID | RESCSU | |
REFDATE | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
PROPOSEREFDATE | Propose Settlement Reference Date? | RERAOPPROPOSEREFDATE | CHAR | 1 | RECABOOL | ||||
HASCN | Is Entering a Contract in Line Item Possible? | RERAOPHASCN | CHAR | 1 | RECABOOL | ||||
CNITEMDEDUCT | Logic for Deriving Contract for Line Item | RERAOPCNITEMDEDUCT | CHAR | 1 | RERAOPCNITEMDEDUCT | ||||
BALANCESHEETACCOUNT | General Yes/No Field | RECABOOL | CHAR | 1 | RECABOOL | ||||
OBJTYPE | Object Type | RECAOBJTYPE | CHAR | 2 | Assigned to domain | J_OBART | RECAOBJTYPE | ||
ISOBJNRDEDOBL | Deriving Account Assignment Object Is Required | RERAOPISOBJNRDEDOBL | CHAR | 1 | RECABOOL | ||||
OBJNRDEDUCT | Derivation Logic for Account Assignment Object of Line Item | RERAOPOBJNRDEDUCT | CHAR | 1 | RERAOPOBJNRDEDUCT | ||||
OBJECTIDENT | Complete Object Identification, for Example BE 1000/123 | RECAIDENT | CHAR | 50 | CHAR50 | ||||
OBJTEXT | Object Description | RECADESCRIPTION | CHAR | 60 | RECAXLDESCRIPTION | ||||
BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
VALUEDATE | Value Date | RERAVALUEDATE | DATS | 8 | RECADATE | ||||
VALUEDATEDEDUCT | Derivation of Value Date for One-Time Postings | RERAOPVALUEDATEDEDUCT | CHAR | 1 | RERAOPVALUEDATEDEDUCT | ||||
ALLOCATIONNUMBER | Assignment Number | RERAALLOCATIONNUMBER | CHAR | 18 | |||||
HASDIST | Is the Line Item a Distribution Item? | RERAOPHASDIST | CHAR | 1 | RECABOOL | ||||
ISGENERATEDDISTITEM | General Yes/No Field | RECABOOL | CHAR | 1 | RECABOOL | ||||
DISTRULEEXT | External Distribution Formula | RECDDISTRULEEXT | CHAR | 4 | Assigned to domain | RECDDISTRULEEXT | |||
DISTRULEPARA1 | Untypified Parameter for a Distribution Formula | RECDDISTRULEPARA | CHAR | 70 | |||||
DISTRULEPARA2 | Untypified Parameter for a Distribution Formula | RECDDISTRULEPARA | CHAR | 70 | |||||
DISTVALUEFAC | Currency-Independent Distribution Factor | RECDDISTVALUE | DEC | 15(6) | RECDDISTVALUE | ||||
FSVARIANTIT | Field Status Variant for Line Item Data for One-Time Posting | RERAOPFSVARIANTIT | CHAR | 4 | |||||
FSTATE | Field Selection String | RERAOPFIELDSTATE | CHAR | 250 | |||||
PERCENTAMT | Share of the Full Document Amount in the Line Item | RERAOPPERCENTAMT | DEC | 8(5) | RERAOPPERCENTAMT | ||||
XFLOWTYPE | Name of Flow Type | RECDXFLOWTYPE | CHAR | 30 | TEXT30 | ||||
XBPNAME | Partner Name | RERAOPXBPNAME | CHAR | 50 | CHAR50 | ||||
RECNTXT | Contract name | RECNTXT | CHAR | 80 | XTEXT80 | ||||
XSCKEY | Name of Service Charge Key | RESCXSCKEY | CHAR | 30 | RECAXMDESCRIPTION | ||||
XGLACCOUNT | G/L Account Name | RERAOPXGLACCOUNT | CHAR | 50 | CHAR50 | ||||
ISOPTIONALITEM | Line Item Is Optional | RERAOPISOPTIONALITEM | CHAR | 1 | RECABOOL | ||||
QUANTITY | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
TABDETAILTEXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SHSTRATSCKEY | Search Strategy for Service Charge Key | RERASHSTRATSCKEY | CHAR | 12 | Assigned to domain | RECASHSTRAT | |||
NAME | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME_2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME_3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME_4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
POSTL_CODE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
COUNTRY | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
COUNTRY_ISO | Country key in ISO code | LAND1_ISO | CHAR | 2 | INTCA | ||||
STREET | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PO_BOX | PO Box | PFACH | CHAR | 10 | PFACH | ||||
POBX_PCD | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
POBK_CURAC | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
BANK_ACCT | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANK_NO | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANK_CTRY | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
BANK_CTRY_ISO | Bank country key in ISO code | BANKS_ISO | CHAR | 2 | INTCA | BKL | |||
TAX_NO_1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
TAX_NO_2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
TAX | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
EQUAL_TAX | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
CTRL_KEY | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
INSTR_KEY | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DME_IND | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | LAISO | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
SWIFT_CODE | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
TCOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
DATEOFSERVICE | Date of Service | REITTCDATEOFSERVICE | DATS | 8 | RECADATE | ||||
HASDIFFOPTRATE | Has Differing Option Rate | REITHASDIFFOPTRATE | CHAR | 1 | RECABOOL | ||||
DIFFOPTRATE | Differing Option Rate for Distribution | REITDIFFOPTRATE | DEC | 9(6) | REITOPTRATE | ||||
NOTAXCORR | Do Not Consider Item in Input Tax Correction | REITNOTAXCORR | CHAR | 1 | RECABOOL | ||||
TCNO | Number of Correction Object | REITTCNO | CHAR | 16 | Assigned to domain | ALPHA | REITTCNO | REITTCNO | REITTCNO |
TC_ASS_IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
XTC | Name of Correction Object | REITXTC | CHAR | 60 | RECAXLDESCRIPTION | ||||
EXTREF1 | External Reference 1 (Line Item) | RERAEXTREF1 | CHAR | 60 | |||||
EXTREF2 | External Reference 2 (Line Item) | RERAEXTREF2 | CHAR | 60 | |||||
EXTREF3 | External Reference 3 (Line Item) | RERAEXTREF3 | CHAR | 60 | |||||
EXTREF4 | External Reference 4 (Line Item) | RERAEXTREF4 | CHAR | 60 | |||||
WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
COSTCENTER | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ORDERID | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
SEPAMNDID | SEPA Mandate: Unique Reference to Mandate per Vendor | RETMSEPAMNDID | CHAR | 35 | RETMSEPAMNDID | ||||
SEPARECCRDID | SEPA Mandate: Creditor ID | RETMSEPARECCRDID | CHAR | 35 | RETMSEPACRDID | ||||
XBPNAME_OLD | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
DOCDATE_OLD | Document Date | RERADOCDATE | DATS | 8 | RECADATE | ||||
EXTREFERENCENO_OLD | External Document Reference | RERAEXTREFERENCENO | CHAR | 16 | XBLNR1 | ||||
BLINEDATE_OLD | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
O_SHFIELD_SCKEY | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure RERA_OP_ITEM_L using ABAP code?
As RERA_OP_ITEM_L is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RERA_OP_ITEM_L as there is no data to select.How to access SAP table RERA_OP_ITEM_L
Within an ECC or HANA version of SAP you can also view further information about RERA_OP_ITEM_L and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects