SAP ABAP Table RVHURL003D (Report (ALV) Account Postings per Material (Detail))

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-RL (Application Component) Returnable Packaging Logistics
     ⤷ ISAUTO_VHU_RL (Package) Returnable Packaging Logistics

Basic Data

Table Category	INTTAB	Structure
Structure	RVHURL003D	Table Relationship Diagram
Short Description	Report (ALV) Account Postings per Material (Detail)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	POSTNO	☐	RL_POSTNO	RL_POSTNO	CHAR	12	0	Returnable packaging account posting number	RLACPOHD
3	BJAHR	☐	RL_POSTYEAR	GJAHR	NUMC	4	0	Posting year
4	POSTIT	☐	RL_POSTIT	RL_POSTIT	NUMC	4	0	Item Number of Account Posting
5	.INCLUDE	☐				0	0	Data Part Table RLACPOIT
6	ACCTNO	☐	RL_ACCTNO	RL_ACCTNO	CHAR	12	0	Returnable packaging account	RLACCT
7	POSTQUAN	☐	RL_POSTQUAN	RL_BALANCE	QUAN	13	3	Posting quantity in base unit of measure
8	ACCTPTY	☐	RL_POTYPE	RL_POTYPE	CHAR	3	0	Account posting type	CRLPOTY
9	BALBPOST	☐	RL_BALBPOST	RL_BALANCE	QUAN	13	3	Balance before posting according to physical order of entry
10	SEQNOBPOST	☐	RL_SEQNO	RL_SEQNO	INT4	10	0	Posting sequence number of returnable packaging account
11	PSHPNO	☐	RL_PSHPNO	RL_PSHPNO	CHAR	12	0	Number of Partner Relationship	RLPSHP
12	MOVTSTP	☐	RL_MOVTSTP	TZNTSTMPS	DEC	15	0	Time of the Goods Movement
13	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MSEG
14	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
15	MBLIT	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
16	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
17	REFLFSNR	☐	RL_LFSNR	RL_LFSNR	CHAR	16	0	Number of external delivery note
18	REFLFSPOS	☐	RL_POSNR	RL_POSNR	NUMC	6	0	Item Number of the External Delivery Note
19	REFDOCDATE	☐	RL_REFDOCDATE	DATUM	DATS	8	0	Date of Reference Document
20	REFFRBNR	☐	RL_FRBNR	RL_FRBNR	CHAR	16	0	Number of Bill of Lading
21	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
22	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	T006
23	REFLFSNR_I	☐	RL_VBELN	VBELN	CHAR	10	0	Number of the Internal Delivery Note	VBUK
24	DOCNO	☐	RL_PODOCNO	RL_DOCNO	CHAR	35	0	Reference document for RP account posting
25	REFPOSTNO	☐	RL_REFPOSTNO	RL_POSTNO	CHAR	12	0	Reference Posting Number for Reversal	RLACPOIT
26	REFPOSTYEAR	☐	RL_REFPOSTYEAR	GJAHR	NUMC	4	0	Posting Year of Reference Posting	RLACPOIT
27	REFPOSTIT	☐	RL_REFPOSTIT	RL_POSTIT	NUMC	4	0	Item Number of Reference Posting	RLACPOIT
28	GRP_POSTIT	☐	RL_GRP_POSTIT	RL_POSTIT	NUMC	4	0	Representative of an item group	RLACPOIT
29	.INCLUDE	☐				0	0	Info on Matching in Acct Postings and Statement Transactions
30	CPGRPNO	☐	RL_CPGRPNO	RL_CPGRPNO	NUMC	12	0	Matching group	RLCPGRP
31	CPSTATEIT	☐	RL_CPSTATEIT	RL_CPSTATEIT	CHAR	1	0	Matching status for posting record or statement transaction
32	CPKIND	☐	RL_CPKIND	RL_CPKIND	CHAR	1	0	Matching type
33	CPSTATEIT_ICON	☐	RL_CPSTATE_ICON	RL_CPSTATE_ICON	CHAR	4	0	Indicator for Matching Status
34	POSTQUAN_DEBIT	☐	RL_POSTQUAN_DEBIT	RL_BALANCE	QUAN	13	3	Posting quantity (outbound at location)
35	POSTQUAN_CREDIT	☐	RL_POSTQUAN_CREDIT	RL_BALANCE	QUAN	13	3	Posting quantity (inbound at location)
36	POTYPE_TXT	☐	RL_POTYPE_TXT	RL_POTYPE_TXT	CHAR	50	0	Text for account posting type
37	ENTRPOST_DATE	☐	RL_ENTRPOST_DATE	CHAR19	CHAR	19	0	Creation Date/Time of Account Posting (Formatted for Print)
38	POSTDATE	☐	RL_POSTDATE	DATUM	DATS	8	0	Posting date
39	USNAM	☐	RL_USNAM	XUBNAME	CHAR	12	0	Posting Carried Out By	*
40	SEQUENCE_LOST	☐	RL_SEQUENCE_LOST	XFELD	CHAR	1	0	Sequence Incomplete
41	.INCLUDE	☐				0	0	Data Part rlacct
42	RET_MATNR	☐	RL_RET_MATNR	MATNR	CHAR	18	0	Returnable packaging	MARA
43	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
44	PRPSHPA	☐	RL_PRPSHPA	RL_PSHPASS	NUMC	12	0	Assignment ID of Main Partner Relationship	RLPSHPA
45	PP_VALFROM	☐	RL_VALFROM	DATUM	DATS	8	0	Valid from date
46	PP_VALTO	☐	RL_VALTO	DATUM	DATS	8	0	Valid-to date
47	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
48	ACCTME	☐	RL_ACCTME	MEINS	UNIT	3	0	Account Unit of Measure	T006
49	ROLEACM	☐	RL_ROLEACM	RL_ROLEACM	CHAR	1	0	Role of location in account statement
50	ACCTBAL	☐	RL_ACCTBAL	RL_BALANCE	QUAN	13	3	Current Account Balance in Base Unit of Measure
51	SEQNO	☐	RL_SEQNO	RL_SEQNO	INT4	10	0	Posting sequence number of returnable packaging account
52	OTYPE	☐	RL_OTYPE	OTYPE	CHAR	2	0	Object type	*
53	OBJID	☐	RL_ACTORID	HROBJID_12	CHAR	12	0	Processor ID in organizational management
54	ACCTSTATE	☐	RL_ACCTSTATE	RL_ACCTSTATE	CHAR	1	0	Returnable Packaging Account Status
55	VKORG	☐	RL_VKORG	VKORG	CHAR	4	0	Sales organization	TVKO
56	VTWEG	☐	RL_VTWEG	VTWEG	CHAR	2	0	Distribution channel	TVTW
57	NRART	☐	RL_NRART	NRART	CHAR	2	0	Type of partner number	TVPA
58	PARNR	☐	RL_PARNR	RL_PARNR	CHAR	10	0	Output Partner
59	ACST_CTRL	☐	RL_ACST_CTRL	RL_ACST_CTRL	CHAR	1	0	Statement control for returnable packaging account
60	CPCTRL	☐	RL_CPCTRL	RL_CPCTRL	CHAR	1	0	Procedure for returnable packaging account matching
61	ACST_CREATE_CTRL	☐	RL_ACST_CREATE_CTRL	RL_ACST_CREATE_CTRL	CHAR	1	0	Control for Creation and Sending of RP Account Statements
62	KONNR	☐	RL_KONNR	EBELN	CHAR	10	0	Number of Outline Agreement	EKKO
63	KTPNR	☐	RL_KTPNR	EBELP	NUMC	5	0	Item Number of Outline Agreement	EKPO
64	PLANING	☐	RL_PLANING	XFELD	CHAR	1	0	Indicator Quantity Below Reorder Point Quantity
65	PLANING_CTRL	☐	RL_PLANING_CTRL	RL_PLANING_CTRL	CHAR	1	0	Planning Type for Returnable Packaging Account
66	REORDBAL	☐	RL_REORDBAL	RL_BALANCE	QUAN	13	3	Reorder Point Quantity in Base Unit of Quantity
67	ORDQUAN	☐	RL_ORDQUAN	RL_BALANCE_ABS	QUAN	13	3	Purchase Order Quantity in Base Unit of Quantity
68	REF_PURCH_DOC	☐	RL_REFPURCH_DOC	EBELN	CHAR	10	0	Reference Document for Purchasing Document	*
69	ACCTBAL_ACCTME	☐	RL_ACCTBAL_ACCTME	RL_BALANCE	QUAN	13	3	Current Account Balance in Account Unit of Measure (AUM)
70	ACCTBAL_ACPOST	☐	RL_ACCTBAL_ACPOST	RL_BALANCE	QUAN	13	3	Account balance after account posting in base unit of meas.
71	ICON_ACCTSTATE	☐	RL_ICON_ACCTSTATE	RL_ICON_ACCTSTATE	CHAR	40	0	Container Field for Icons: RP Account Status
72	STEXT	☐	RL_STEXT	TEXT40	CHAR	40	0	Processor
73	ROLEACM_TEXT	☐	RL_ROLEACM_TEXT	AS4TEXT	CHAR	60	0	Role of location in account statement: description
74	.INCLUDE	☐				0	0	Data Part rlpshp
75	.INCLUDE	☐				0	0	Business Management Key for Partner Relationship
76	ACMAN	☐	RL_ACMAN	RL_PARTNER_NO	CHAR	10	0	Number of returnable packaging location
77	ACMANTY	☐	RL_ACMANTY	RL_PARTNER_TYPE	CHAR	1	0	Partner type of returnable packaging location
78	ACHOL	☐	RL_ACHOL	RL_PARTNER_NO	CHAR	10	0	Number of returnable packaging exchange partner
79	ACHOLTY	☐	RL_ACHOLTY	RL_PARTNER_TYPE	CHAR	1	0	Partner type of returnable packaging exchange partner
80	.INCLUDE	☐				0	0	Data Part RLPSHP Address
81	ACMAN_NAME1	☐	RL_ACMAN_NAME1	TEXT40	CHAR	40	0	Name 1 of location of returnable packaging
82	ACMAN_ORT01	☐	RL_ACMAN_ORT01	TEXT40	CHAR	40	0	Place name of returnable packaging location
83	ACHOL_NAME1	☐	RL_ACHOL_NAME1	TEXT40	CHAR	40	0	Name 1 of returnable packaging exchange partner
84	ACHOL_ORT01	☐	RL_ACHOL_ORT01	TEXT40	CHAR	40	0	Location of returnable packaging exchange partner
85	RET_MATNR_ACMAN	☐	RL_RET_MATNR_ACMAN	RL_PARRET_MATNR	CHAR	35	0	Returnable packaging number at location
86	RET_MATNR_ACHOL	☐	RL_RET_MATNR_ACHOL	RL_PARRET_MATNR	CHAR	35	0	Returnable packaging number at exchange partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVHURL003D	ACCTME	T006	MSEHI	REF	C	CN
2	RVHURL003D	ACCTNO	RLACCT	ACCTNO	REF	1	C
3	RVHURL003D	ACCTPTY	CRLPOTY	RL_POTYPE		1	CN
4	RVHURL003D	BUKRS	T001	BUKRS	REF	1	CN
5	RVHURL003D	CPGRPNO	RLCPGRP	CPGRPNO	REF	1	CN
6	RVHURL003D	GRP_POSTIT	RLACPOIT	POSTIT
7	RVHURL003D	KONNR	EKKO	EBELN	REF	1	CN
8	RVHURL003D	KTPNR	EKPO	EBELP	REF	1	CN
9	RVHURL003D	LSMEH	T006	MSEHI		1	CN
10	RVHURL003D	MBLNR	MSEG	MBLNR	REF	1	CN
11	RVHURL003D	MEINS	T006	MSEHI	REF	1	CN
12	RVHURL003D	NRART	TVPA	NRART
13	RVHURL003D	POSTNO	RLACPOHD	POSTNO	KEY	1	CN
14	RVHURL003D	PRPSHPA	RLPSHPA	PSHPASS
15	RVHURL003D	PSHPNO	RLPSHP	PSHPNO	REF	1	CN
16	RVHURL003D	REFLFSNR_I	VBUK	VBELN	REF	1	CN
17	RVHURL003D	REFPOSTIT	RLACPOIT	POSTIT
18	RVHURL003D	REFPOSTNO	RLACPOIT	POSTNO	REF	1	CN
19	RVHURL003D	REFPOSTYEAR	RLACPOIT	BJAHR
20	RVHURL003D	RET_MATNR	MARA	MATNR	REF	1	CN
21	RVHURL003D	VKORG	TVKO	VKORG
22	RVHURL003D	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20110901
SAP Release Created in