SAP table TVCPF (Billing: Copying Control)

SAP table TVCPF has 6 primary key fields being MANDT,FKARN,AUARV,LFARV,FKARV,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
FKARN Copying Control: Target Billing Type CHAR 4 0 TVFK FKART_NACH
AUARV Copying Control: Reference Document Type CHAR 4 0 TVAK AUART_VON
LFARV Copy control: from delivery type CHAR 4 0 TVLK LFART_VON
FKARV Copying Control: Reference Billing Document Type CHAR 4 0 TVFK FKART_VON
PSTYV Reference Item Category CHAR 4 0 TVPT PSTYV_VON
GRBED Copying Requirements NUMC 3 0 GRBED
GRURK Data transfer VBRK NUMC 3 0 GRURK
GRURP Data transfer VBRK/VBRP NUMC 3 0 GRURP
GRUKO Data transfer KOMV NUMC 3 0 GRUKO
KNPRS Pricing Type CHAR 1 0 KNPRS
1 Customer reserve 1
2 Customer reserve 2
3 Customer reserve 3
4 Customer reserve 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Copy price elements and redetermine scales
B Carry out new pricing
C Copy manual price elements and redetermine the others
D Copy price elements unchanged
E Copy price elements and fix values
F Copy price elements, turn value and fix
G Copy price elements unchanged and redetermine taxes
H Redetermine freight conditions
I Redetermine rebate conditions
J Redetermine confirmed purch. net price / value (KNTYP=d)
K Copy price elements and cost. Redetermine taxes.
M Copy price elements, turn value
N Copy price elements unchanged, new cost
O Redetermine variant conditions (KNTYP=O)
Q Redetermine calculation conditions (KNTYP=Q)
R Copy price elements and rebate conditions. Redetermine taxes
S Ship & Debit (IBU HiTec)
U Redetermine precious metal conditions (KNTYP=U)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
PLMIN Quantity is calculated positively, negatively or not at all CHAR 1 0 PLMIN
+ Positive
- Negative
0 Zero
FKMGK Billing Quantity Indicator CHAR 1 0 FKMGK
A Order quantity minus invoiced quantity
B Delivery quantity minus invoiced quantity
C Order quantity
D Delivery quantity
E Goods receipt quantity minus invoiced quantity
F Invoice receipt quantity minus invoiced quantity
G Cumulative batch quantity minus invoiced quantity
H Cumulative batch quantity
I Purchase quantity minus invoiced quantity
POSVO Transfer Item Number from Template to Billing Document CHAR 1 0 POSVO_VF
HINEU Determine customer heirarchy again CHAR 1 0 HINEU
PFKUR Determine pricing exchange rate CHAR 1 0 PFKUR
A Copy from sales order
B Price exchange rate = Accounting rate
C Exchange rate determination according to billing date
D Exchange rate determination according to pricing date
E Exchange rate determination according to current date
F Exch.rate determination accord. to date of services rendered
EXPIM Determination of export data in billing document CHAR 1 0 EXPIM
Refer to export data in the delivery
A Copy export data in the delivery
B Redetermine the export data
ORDNR_FI Assignment Number (Financial Accounting) CHAR 1 0 ORDNR_FI
A Customer Reference
B Sales Order Number
C Delivery Number
D External Delivery Number
E Actual Billing Document Number
F External delivery no. if available, otherwise delivery no.
XBLNR_FI FI reference number CHAR 1 0 XBLNR_FI
A Customer Reference
B Sales Order Number
C Delivery Number
D External Delivery Number
E Current Billing Document Number
F External delivery no. if avalable, otherwise delivery no.
PRSQU Price Source CHAR 1 0 PRSQU
Order
A Purchase Order
B Purchase Order / Delivery
C Not Used
D Delivery
E Delivery / Order
F Shipment Costs
G External
H Copied from Main Item
I Order / Freight Order
KVPRS Cumulate cost CHAR 1 0 KVPRS
PSTYN Default Item Category CHAR 4 0 TVPT PSTYV_NACH
OIFERP Fee repricing indicator CHAR 1 0 OIA_FERP
1 Carry out new fee rate determination
2 Copy manually entered fee rates and redetermine others
3 Copy all fee elements unchanged
OIFEECH Fee edit control CHAR 1 0 OIA_FEECH
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
GRURP_2 Data Transfer 2nd Item NUMC 3 0 GRURP_2
SDBIL_GRURP_ROUTINE_NO Number of Custom Routine for Data Transfer to Billing Docs NUMC 7 0 SDBIL_GRURP_ROUTINE_NO

TVCPF foreign key relationships

Table Field Check Table Check Field
0 TVCPF AUARV TVAK Sales Document Types MANDT
0 TVCPF AUARV TVAK Sales Document Types AUART
1 TVCPF FKARN TVFK Billing: Document Types MANDT
1 TVCPF FKARN TVFK Billing: Document Types FKART
0 TVCPF FKARV TVFK Billing: Document Types MANDT
0 TVCPF FKARV TVFK Billing: Document Types FKART
1 TVCPF LFARV TVLK Delivery Types MANDT
1 TVCPF LFARV TVLK Delivery Types LFART
0 TVCPF PSTYN TVPT Sales Documents: Item categories MANDT
0 TVCPF PSTYN TVPT Sales Documents: Item categories PSTYV
1 TVCPF PSTYV TVPT Sales Documents: Item categories MANDT
1 TVCPF PSTYV TVPT Sales Documents: Item categories PSTYV