SAP ABAP Table RVHURL003AD (Report (ALV) Account Balances per RP Account (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	RVHURL003AD	Table Relationship Diagram
Short Description	Report (ALV) Account Balances per RP Account (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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	POSTNO	☐	RL_POSTNO	RL_POSTNO	CHAR	12	0	Returnable packaging account posting number
4	BJAHR	☐	RL_POSTYEAR	GJAHR	NUMC	4	0	Posting year
5	POSTIT	☐	RL_POSTIT	RL_POSTIT	NUMC	4	0	Item Number of Account Posting
6	.INCLUDE	☐				0	0	Data Part Table RLACPOIT
7	ACCTNO	☐	RL_ACCTNO	RL_ACCTNO	CHAR	12	0	Returnable packaging account	RLACCT
8	POSTQUAN	☐	RL_POSTQUAN	RL_BALANCE	QUAN	13	3	Posting quantity in base unit of measure
9	ACCTPTY	☐	RL_POTYPE	RL_POTYPE	CHAR	3	0	Account posting type	CRLPOTY
10	BALBPOST	☐	RL_BALBPOST	RL_BALANCE	QUAN	13	3	Balance before posting according to physical order of entry
11	SEQNOBPOST	☐	RL_SEQNO	RL_SEQNO	INT4	10	0	Posting sequence number of returnable packaging account
12	PSHPNO	☐	RL_PSHPNO	RL_PSHPNO	CHAR	12	0	Number of Partner Relationship	RLPSHP
13	MOVTSTP	☐	RL_MOVTSTP	TZNTSTMPS	DEC	15	0	Time of the Goods Movement
14	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MSEG
15	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
16	MBLIT	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
17	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
18	REFLFSNR	☐	RL_LFSNR	RL_LFSNR	CHAR	16	0	Number of external delivery note
19	REFLFSPOS	☐	RL_POSNR	RL_POSNR	NUMC	6	0	Item Number of the External Delivery Note
20	REFDOCDATE	☐	RL_REFDOCDATE	DATUM	DATS	8	0	Date of Reference Document
21	REFFRBNR	☐	RL_FRBNR	RL_FRBNR	CHAR	16	0	Number of Bill of Lading
22	LSMNG	☐	LSMNG	MENG13	QUAN	13	3	Quantity in Unit of Measure from Delivery Note
23	LSMEH	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	T006
24	REFLFSNR_I	☐	RL_VBELN	VBELN	CHAR	10	0	Number of the Internal Delivery Note	VBUK
25	DOCNO	☐	RL_PODOCNO	RL_DOCNO	CHAR	35	0	Reference document for RP account posting
26	REFPOSTNO	☐	RL_REFPOSTNO	RL_POSTNO	CHAR	12	0	Reference Posting Number for Reversal	RLACPOIT
27	REFPOSTYEAR	☐	RL_REFPOSTYEAR	GJAHR	NUMC	4	0	Posting Year of Reference Posting	RLACPOIT
28	REFPOSTIT	☐	RL_REFPOSTIT	RL_POSTIT	NUMC	4	0	Item Number of Reference Posting	RLACPOIT
29	GRP_POSTIT	☐	RL_GRP_POSTIT	RL_POSTIT	NUMC	4	0	Representative of an item group	RLACPOIT
30	.INCLUDE	☐				0	0	Info on Matching in Acct Postings and Statement Transactions
31	CPGRPNO	☐	RL_CPGRPNO	RL_CPGRPNO	NUMC	12	0	Matching group	RLCPGRP
32	CPSTATEIT	☐	RL_CPSTATEIT	RL_CPSTATEIT	CHAR	1	0	Matching status for posting record or statement transaction
33	CPKIND	☐	RL_CPKIND	RL_CPKIND	CHAR	1	0	Matching type
34	CPSTATEIT_ICON	☐	RL_CPSTATE_ICON	RL_CPSTATE_ICON	CHAR	4	0	Indicator for Matching Status
35	POSTQUAN_DEBIT	☐	RL_POSTQUAN_DEBIT	RL_BALANCE	QUAN	13	3	Posting quantity (outbound at location)
36	POSTQUAN_CREDIT	☐	RL_POSTQUAN_CREDIT	RL_BALANCE	QUAN	13	3	Posting quantity (inbound at location)
37	ACCTBAL_ACPOST	☐	RL_ACCTBAL_ACPOST	RL_BALANCE	QUAN	13	3	Account balance after account posting in base unit of meas.
38	ACCTBAL_BPOST	☐	RL_BALBPOST	RL_BALANCE	QUAN	13	3	Balance before posting according to physical order of entry
39	POTYPE_TXT	☐	RL_POTYPE_TXT	RL_POTYPE_TXT	CHAR	50	0	Text for account posting type
40	ENTRPOST_DATE	☐	RL_ENTRPOST_DATE	CHAR19	CHAR	19	0	Creation Date/Time of Account Posting (Formatted for Print)
41	POSTDATE	☐	RL_POSTDATE	DATUM	DATS	8	0	Posting date
42	USNAM	☐	RL_USNAM	XUBNAME	CHAR	12	0	Posting Carried Out By	*
43	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
44	SEQUENCE_LOST	☐	RL_SEQUENCE_LOST	XFELD	CHAR	1	0	Sequence Incomplete
45	.INCLUDE	☐				0	0	Data Part rlpshp
46	.INCLUDE	☐				0	0	Business Management Key for Partner Relationship
47	ACMAN	☐	RL_ACMAN	RL_PARTNER_NO	CHAR	10	0	Number of returnable packaging location
48	ACMANTY	☐	RL_ACMANTY	RL_PARTNER_TYPE	CHAR	1	0	Partner type of returnable packaging location
49	ACHOL	☐	RL_ACHOL	RL_PARTNER_NO	CHAR	10	0	Number of returnable packaging exchange partner
50	ACHOLTY	☐	RL_ACHOLTY	RL_PARTNER_TYPE	CHAR	1	0	Partner type of returnable packaging exchange partner
51	.INCLUDE	☐				0	0	Data Part RLPSHP Address
52	ACMAN_NAME1	☐	RL_ACMAN_NAME1	TEXT40	CHAR	40	0	Name 1 of location of returnable packaging
53	ACMAN_ORT01	☐	RL_ACMAN_ORT01	TEXT40	CHAR	40	0	Place name of returnable packaging location
54	ACHOL_NAME1	☐	RL_ACHOL_NAME1	TEXT40	CHAR	40	0	Name 1 of returnable packaging exchange partner
55	ACHOL_ORT01	☐	RL_ACHOL_ORT01	TEXT40	CHAR	40	0	Location of returnable packaging exchange partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVHURL003AD	ACCTNO	RLACCT	ACCTNO	REF	1	C
2	RVHURL003AD	ACCTPTY	CRLPOTY	RL_POTYPE		1	CN
3	RVHURL003AD	CPGRPNO	RLCPGRP	CPGRPNO	REF	1	CN
4	RVHURL003AD	GRP_POSTIT	RLACPOIT	POSTIT
5	RVHURL003AD	LSMEH	T006	MSEHI		1	CN
6	RVHURL003AD	MBLNR	MSEG	MBLNR	REF	1	CN
7	RVHURL003AD	PSHPNO	RLPSHP	PSHPNO	REF	1	CN
8	RVHURL003AD	REFLFSNR_I	VBUK	VBELN	REF	1	CN
9	RVHURL003AD	REFPOSTIT	RLACPOIT	POSTIT
10	RVHURL003AD	REFPOSTNO	RLACPOIT	POSTNO	REF	1	CN
11	RVHURL003AD	REFPOSTYEAR	RLACPOIT	BJAHR

History

Last changed by/on	SAP	20110901
SAP Release Created in