RVHURL003D SAP (Report (ALV) Account Postings per Material (Detail)) Structure details
Description: Report (ALV) Account Postings per Material (Detail)
Structure field list including key, data, relationships and ABAP select examples
RVHURL003D 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 "Report (ALV) Account Postings per Material (Detail)" 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_RVHURL003D TYPE RVHURL003D.
The RVHURL003D table consists of various fields, each holding specific information or linking keys about Report (ALV) Account Postings per Material (Detail) data available in SAP. These include POSTNO (Returnable packaging account posting number), BJAHR (Posting year), POSTIT (Item Number of Account Posting), ACCTNO (Returnable packaging account).. 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 (character-type or numeric)
SAP RVHURL003D 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
POSTNO | Returnable packaging account posting number | RL_POSTNO | CHAR | 12 | RLACPOHD | ALPHA | RL_POSTNO | ||
BJAHR | Posting year | RL_POSTYEAR | NUMC | 4 | GJAHR | GJAHR | |||
POSTIT | Item Number of Account Posting | RL_POSTIT | NUMC | 4 | RL_POSTIT | ||||
ACCTNO | Returnable packaging account | RL_ACCTNO | CHAR | 12 | RLACCT | ALPHA | RL_ACCTNO | RL_ACCTNO | RLACCT01 |
POSTQUAN | Posting quantity in base unit of measure | RL_POSTQUAN | QUAN | 13(3) | RL_BALANCE | ||||
ACCTPTY | Account posting type | RL_POTYPE | CHAR | 3 | CRLPOTY | RL_POTYPE | |||
BALBPOST | Balance before posting according to physical order of entry | RL_BALBPOST | QUAN | 13(3) | RL_BALANCE | ||||
SEQNOBPOST | Posting sequence number of returnable packaging account | RL_SEQNO | INT4 | 10 | RL_SEQNO | ||||
PSHPNO | Number of Partner Relationship | RL_PSHPNO | CHAR | 12 | RLPSHP | ALPHA | RL_PSHPNO | ||
MOVTSTP | Time of the Goods Movement | RL_MOVTSTP | DEC | 15 | TZNTSTMPS | ||||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | MSEG | ALPHA | BELNR | MBN | |
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLIT | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
REFLFSNR | Number of external delivery note | RL_LFSNR | CHAR | 16 | ALPHA | RL_LFSNR | |||
REFLFSPOS | Item Number of the External Delivery Note | RL_POSNR | NUMC | 6 | RL_POSNR | ||||
REFDOCDATE | Date of Reference Document | RL_REFDOCDATE | DATS | 8 | DATUM | ||||
REFFRBNR | Number of Bill of Lading | RL_FRBNR | CHAR | 16 | ALPHA | RL_FRBNR | |||
LSMNG | Quantity in Unit of Measure from Delivery Note | LSMNG | QUAN | 13(3) | MENG13 | ||||
LSMEH | Unit of Measure From Delivery Note | LSMEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
REFLFSNR_I | Number of the Internal Delivery Note | RL_VBELN | CHAR | 10 | VBUK | ALPHA | VBELN | ||
DOCNO | Reference document for RP account posting | RL_PODOCNO | CHAR | 35 | ALPHA | RL_DOCNO | |||
REFPOSTNO | Reference Posting Number for Reversal | RL_REFPOSTNO | CHAR | 12 | RLACPOIT | ALPHA | RL_POSTNO | ||
REFPOSTYEAR | Posting Year of Reference Posting | RL_REFPOSTYEAR | NUMC | 4 | RLACPOIT | GJAHR | GJAHR | ||
REFPOSTIT | Item Number of Reference Posting | RL_REFPOSTIT | NUMC | 4 | RLACPOIT | RL_POSTIT | |||
GRP_POSTIT | Representative of an item group | RL_GRP_POSTIT | NUMC | 4 | RLACPOIT | RL_POSTIT | |||
CPGRPNO | Matching group | RL_CPGRPNO | NUMC | 12 | RLCPGRP | RL_CPGRPNO | |||
CPSTATEIT | Matching status for posting record or statement transaction | RL_CPSTATEIT | CHAR | 1 | RL_CPSTATEIT | ||||
CPKIND | Matching type | RL_CPKIND | CHAR | 1 | RL_CPKIND | ||||
CPSTATEIT_ICON | Indicator for Matching Status | RL_CPSTATE_ICON | CHAR | 40 | RL_CPSTATE_ICON | ||||
POSTQUAN_DEBIT | Posting quantity (outbound at location) | RL_POSTQUAN_DEBIT | QUAN | 13(3) | RL_BALANCE | ||||
POSTQUAN_CREDIT | Posting quantity (inbound at location) | RL_POSTQUAN_CREDIT | QUAN | 13(3) | RL_BALANCE | ||||
POTYPE_TXT | Text for account posting type | RL_POTYPE_TXT | CHAR | 50 | RL_POTYPE_TXT | ||||
ENTRPOST_DATE | Creation Date/Time of Account Posting (Formatted for Print) | RL_ENTRPOST_DATE | CHAR | 19 | CHAR19 | ||||
POSTDATE | Posting date | RL_POSTDATE | DATS | 8 | DATUM | ||||
USNAM | Posting Carried Out By | RL_USNAM | CHAR | 12 | Assigned to domain | XUBNAME | |||
SEQUENCE_LOST | Sequence Incomplete | RL_SEQUENCE_LOST | CHAR | 1 | XFELD | ||||
RET_MATNR | Returnable packaging | RL_RET_MATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
PRPSHPA | Assignment ID of Main Partner Relationship | RL_PRPSHPA | NUMC | 12 | RLPSHPA | RL_PSHPASS | |||
PP_VALFROM | Valid from date | RL_VALFROM | DATS | 8 | DATUM | ||||
PP_VALTO | Valid-to date | RL_VALTO | DATS | 8 | DATUM | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
ACCTME | Account Unit of Measure | RL_ACCTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
ROLEACM | Role of location in account statement | RL_ROLEACM | CHAR | 1 | RL_ROLEACM | ||||
ACCTBAL | Current Account Balance in Base Unit of Measure | RL_ACCTBAL | QUAN | 13(3) | RL_BALANCE | ||||
SEQNO | Posting sequence number of returnable packaging account | RL_SEQNO | INT4 | 10 | RL_SEQNO | ||||
OTYPE | Object type | RL_OTYPE | CHAR | 2 | Assigned to domain | OTYPE | POT | ||
OBJID | Processor ID in organizational management | RL_ACTORID | CHAR | 12 | HROBJID_12 | ||||
ACCTSTATE | Returnable Packaging Account Status | RL_ACCTSTATE | CHAR | 1 | RL_ACCTSTATE | ||||
VKORG | Sales organization | RL_VKORG | CHAR | 4 | TVKO | VKORG | |||
VTWEG | Distribution channel | RL_VTWEG | CHAR | 2 | TVTW | VTWEG | |||
NRART | Type of partner number | RL_NRART | CHAR | 2 | TVPA | NRART | RL_NRART | ||
PARNR | Output Partner | RL_PARNR | CHAR | 10 | RL_PARNR | RL_PARNR | |||
ACST_CTRL | Statement control for returnable packaging account | RL_ACST_CTRL | CHAR | 1 | RL_ACST_CTRL | ||||
CPCTRL | Procedure for returnable packaging account matching | RL_CPCTRL | CHAR | 1 | RL_CPCTRL | ||||
ACST_CREATE_CTRL | Control for Creation and Sending of RP Account Statements | RL_ACST_CREATE_CTRL | CHAR | 1 | RL_ACST_CREATE_CTRL | ||||
KONNR | Number of Outline Agreement | RL_KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | ||
KTPNR | Item Number of Outline Agreement | RL_KTPNR | NUMC | 5 | EKPO | EBELP | |||
PLANING | Indicator Quantity Below Reorder Point Quantity | RL_PLANING | CHAR | 1 | XFELD | ||||
PLANING_CTRL | Planning Type for Returnable Packaging Account | RL_PLANING_CTRL | CHAR | 1 | RL_PLANING_CTRL | ||||
REORDBAL | Reorder Point Quantity in Base Unit of Quantity | RL_REORDBAL | QUAN | 13(3) | RL_BALANCE | ||||
ORDQUAN | Purchase Order Quantity in Base Unit of Quantity | RL_ORDQUAN | QUAN | 13(3) | RL_BALANCE_ABS | ||||
REF_PURCH_DOC | Reference Document for Purchasing Document | RL_REFPURCH_DOC | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
ACCTBAL_ACCTME | Current Account Balance in Account Unit of Measure (AUM) | RL_ACCTBAL_ACCTME | QUAN | 13(3) | RL_BALANCE | ||||
ACCTBAL_ACPOST | Account balance after account posting in base unit of meas. | RL_ACCTBAL_ACPOST | QUAN | 13(3) | RL_BALANCE | ||||
ICON_ACCTSTATE | Container Field for Icons: RP Account Status | RL_ICON_ACCTSTATE | CHAR | 40 | RL_ICON_ACCTSTATE | ||||
STEXT | Processor | RL_STEXT | CHAR | 40 | TEXT40 | ||||
ROLEACM_TEXT | Role of location in account statement: description | RL_ROLEACM_TEXT | CHAR | 60 | AS4TEXT | ||||
ACMAN | Number of returnable packaging location | RL_ACMAN | CHAR | 10 | RL_PARTNER_NO | RL_ACMAN | |||
ACMANTY | Partner type of returnable packaging location | RL_ACMANTY | CHAR | 1 | RL_PARTNER_TYPE | RL_ACMANTY | |||
ACHOL | Number of returnable packaging exchange partner | RL_ACHOL | CHAR | 10 | RL_PARTNER_NO | RL_ACHOL | |||
ACHOLTY | Partner type of returnable packaging exchange partner | RL_ACHOLTY | CHAR | 1 | RL_PARTNER_TYPE | RL_ACHOLTY | |||
ACMAN_NAME1 | Name 1 of location of returnable packaging | RL_ACMAN_NAME1 | CHAR | 40 | TEXT40 | ||||
ACMAN_ORT01 | Place name of returnable packaging location | RL_ACMAN_ORT01 | CHAR | 40 | TEXT40 | ||||
ACHOL_NAME1 | Name 1 of returnable packaging exchange partner | RL_ACHOL_NAME1 | CHAR | 40 | TEXT40 | ||||
ACHOL_ORT01 | Location of returnable packaging exchange partner | RL_ACHOL_ORT01 | CHAR | 40 | TEXT40 | ||||
RET_MATNR_ACMAN | Returnable packaging number at location | RL_RET_MATNR_ACMAN | CHAR | 35 | RL_PARRET_MATNR | ||||
RET_MATNR_ACHOL | Returnable packaging number at exchange partner | RL_RET_MATNR_ACHOL | CHAR | 35 | RL_PARRET_MATNR |
Key field | Non-key field |
How do I retrieve data from SAP structure RVHURL003D using ABAP code?
As RVHURL003D 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 RVHURL003D as there is no data to select.How to access SAP table RVHURL003D
Within an ECC or HANA version of SAP you can also view further information about RVHURL003D 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