SAP ABAP Table FAMTV (View: Billing Items by Material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VF (Package) Application development R/3 invoice

Basic Data

Table Category	INTTAB	Structure
Structure	FAMTV	Table Relationship Diagram
Short Description	View: Billing Items by Material

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	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
2	POSNR	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
3	SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
6	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
7	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
8	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
9	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
10	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
11	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
12	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
13	KUNNR	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
14	NAME1	☐	NAME_RG	NAME	CHAR	35	0	Name of the payer
15	ADRNR	☐	ADRNR_RG	ADRNR	CHAR	10	0	Address nummer of the payer	*
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
18	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
19	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
20	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
21	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
22	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
23	STATUS	☐	STATUS_VB	STATV	CHAR	1	0	Status of the document
24	STATUS_BEZ	☐	STATUS_BEZ	TEXT20	CHAR	20	0	Status description
25	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
26	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
27	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
28	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
29	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
30	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
31	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
32	.INCLUDE	☐				0	0	Customer Enhancements for Billing Items of the Material
33	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAMTV	BZIRK	T171	BZIRK
2	FAMTV	CHARG	MCHA	CHARG
3	FAMTV	FKART	TVFK	FKART
4	FAMTV	KDGRP	T151	KDGRP
5	FAMTV	KUNNR	KNA1	KUNNR
6	FAMTV	LLAND	T005	LAND1
7	FAMTV	MATNR	MARA	MATNR
8	FAMTV	POSNR	VBUP	POSNR
9	FAMTV	PRODH	T179	PRODH
10	FAMTV	VBELN	VBUK	VBELN
11	FAMTV	VKORG	TVKO	VKORG
12	FAMTV	VRKME	T006	MSEHI
13	FAMTV	VTWEG	TVTW	VTWEG
14	FAMTV	WAERK	TCURC	WAERS
15	FAMTV	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in