SAP table V_TVAP_FPL (Generated Table for View)

SAP table V_TVAP_FPL has 2 primary key fields being MANDT,PSTYV.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PSTYV Sales document item category CHAR 4 0 TVPT PSTYV
VTEXT Description CHAR 20 0 BEZEI20
FKREL Relevant for Billing CHAR 1 0 FKREL
Not relevant for billing
A Delivery-related billing document
B Relevant for order-related billing - status acc.to order qty
C Relevant for ord.-related billing - status acc.to target qty
D Relevant for pro forma
F Order-related billing doc. - status according to invoice qty
G Order-related billing of the delivery quantity
H Delivery-related billing - no zero quantities
I Order-relevant billing - billing plan
J Relevant for deliveries across EU countries
K Delivery-related invoices for partial quantity
L Pro forma - no zero quantities
M Delivery-related invoices-no zero qtys (incl main batch itm)
N Pro forma - no zero quantities (including main batch items)
O Delivery-rel. invoices for partial quantity - No zero qtys
P Delivery-related invoices for CSFG - No batch split items
Q Delivery-related invoices for CRM
R Delivery-related invoices for CRM - No zero quantities
S IBS-DI: Order-Related Bill. Doc. with DP w/o Billing Plan
T Delivery-Related Invoices for CRM with IB in CRM
U Delivery-Rel. Invoices for CRM with IB in CRM - No Zero Qtys
V Delivery-Related ICB of Stock Transport Orders in CRM
W Delivery-Rel. ICB of StTransportOrders in CRM - No Zero Qtys
X Billing request related via an order related billing plan
Y Intercompany billing – delivery-related invoice
FPART Billing/Invoicing Plan Type CHAR 2 0 TFPLA FPART
FPBEZ Description of Billing/Invoicing Plan Type CHAR 30 0 FPBEZ

V_TVAP_FPL foreign key relationships

Table Field Check Table Check Field
0 V_TVAP_FPL FPART TFPLA Billing Plan Type FPART
1 V_TVAP_FPL MANDT T000 Clients MANDT
0 V_TVAP_FPL PSTYV TVPT Sales Documents: Item categories MANDT
0 V_TVAP_FPL PSTYV TVPT Sales Documents: Item categories PSTYV