1. Home
  2. Resources
  3. SAP Tables
  4. FAMTV - View: Billing Items by Material

SAP Table FAMTV

View: Billing Items by Material

FAMTV (View: Billing Items by Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FAMTV to other SAP tables.

FAMTV table fields

Field Data element Checktable Datatype Length Decimals
VBELN Billing Document VBELN_VF VBUK CHAR 10 0
POSNR Billing item POSNR_VF VBUP NUMC 6 0
SELKZ Selection indicator for list screens SELKZ_LIST CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
FKART Billing Type FKART TVFK CHAR 4 0
NETWR Net Value in Document Currency NETWR CURR 15 2
WAERK SD Document Currency WAERK TCURC CUKY 5 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
LLAND Country of Destination LLAND T005 CHAR 3 0
BZIRK Sales district BZIRK T171 CHAR 6 0
KDGRP Customer group KDGRP T151 CHAR 2 0
KUNNR Payer KUNRG KNA1 CHAR 10 0
NAME1 Name of the payer NAME_RG CHAR 35 0
ADRNR Address nummer of the payer ADRNR_RG CHAR 10 0
MATNR Material Number MATNR MARA CHAR 18 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
PRODH Product hierarchy PRODH_D T179 CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME Sales unit VRKME T006 UNIT 3 0
STATUS Status of the document STATUS_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
STATUS_BEZ Status Description STATUS_BEZ CHAR 20 0
FKTYP Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
SHKZG Returns item SHKZG_VF CHAR 1 0
NULL Outbound Message Processing
A Outbound - document flow negative
B Returns - document flow negative
X Returns
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
ACTIV List Level in which the Line Item is Active ACTIV NUMC 2 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR OIFSPBL CHAR 10 0

FAMTV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FAMTV BZIRK SYST MANDT T171 Customers: Sales Districts MANDT
FAMTV BZIRK FAMTV BZIRK T171 Customers: Sales Districts BZIRK
FAMTV CHARG SYST MANDT MCHA Batches MANDT
FAMTV CHARG FAMTV MATNR MCHA Batches MATNR
FAMTV CHARG FAMTV WERKS MCHA Batches WERKS
FAMTV CHARG FAMTV CHARG MCHA Batches CHARG
FAMTV FKART SYST MANDT TVFK Billing: Document Types MANDT
FAMTV FKART FAMTV FKART TVFK Billing: Document Types FKART
FAMTV KDGRP SYST MANDT T151 Customers: Customer Groups MANDT
FAMTV KDGRP FAMTV KDGRP T151 Customers: Customer Groups KDGRP
FAMTV KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
FAMTV KUNNR FAMTV KUNNR KNA1 General Data in Customer Master KUNNR
FAMTV LLAND SYST MANDT T005 Countries MANDT
FAMTV LLAND FAMTV LLAND T005 Countries LAND1
FAMTV MATNR SYST MANDT MARA General Material Data MANDT
FAMTV MATNR FAMTV MATNR MARA General Material Data MATNR
FAMTV PBLNR * OIFSPBL Physical Location - Master Data MANDT
FAMTV PBLNR FAMTV PBLNR OIFSPBL Physical Location - Master Data PBLNR
FAMTV POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
FAMTV POSNR FAMTV VBELN VBUP Sales Document: Item Status VBELN
FAMTV POSNR FAMTV POSNR VBUP Sales Document: Item Status POSNR
FAMTV PRODH SYST MANDT T179 Materials: Product Hierarchies MANDT
FAMTV PRODH FAMTV PRODH T179 Materials: Product Hierarchies PRODH
FAMTV VBELN FAMTV VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
FAMTV VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
FAMTV VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
FAMTV VKORG FAMTV VKORG TVKO Organizational Unit: Sales Organizations VKORG
FAMTV VRKME FAMTV VRKME T006 Units of Measurement MSEHI
FAMTV VRKME SYST MANDT T006 Units of Measurement MANDT
FAMTV VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
FAMTV VTWEG FAMTV VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
FAMTV WAERK SYST MANDT TCURC Currency Codes MANDT
FAMTV WAERK FAMTV WAERK TCURC Currency Codes WAERS
FAMTV WERKS SYST MANDT T001W Plants/Branches MANDT
FAMTV WERKS FAMTV WERKS T001W Plants/Branches WERKS