SAP table V_TVCPAFP (Generated Table for View)

SAP table V_TVCPAFP has 6 primary key fields being MANDT,AUARN,AUARV,FKARV,ETTYV,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
AUARN Copying Control: Target Sales Document Type CHAR 4 0 TVAK AUART_NACH
AUARV Copying Control: Reference Document Type CHAR 4 0 TVAK AUART_VON
FKARV Copying Control: Reference Billing Document Type CHAR 4 0 TVFK FKART_VON
ETTYV Reference Schedule Line Category CHAR 2 0 TVEP ETTYP_VON
PSTYV Reference Item Category CHAR 4 0 TVPT PSTYV_VON
PSTYN Default Item Category CHAR 4 0 TVPT PSTYV_NACH
GRBED Copying Requirements NUMC 3 0 GRBED
GRUAK Copying Requirements for Data Transfer VBAK NUMC 3 0 GRUAK
GRUAP Copying requirements for data transfer VBAP NUMC 3 0 GRUAP
GRUEP Copying requirements for schedule line data NUMC 3 0 GRUEP
GRUKD Copying Requirements for Transferring Business Data NUMC 3 0 GRUKD
GRUPA Copying Requirements for Partner Data VBPA NUMC 3 0 GRUPA
POSVO Copy Item Number from Reference CHAR 1 0 POSVO
ETTYN Proposed schedule line category CHAR 2 0 TVEP ETTYP_NACH
ETKOP Copy Schedule Lines CHAR 1 0 ETKOP
GRPZE Group Indicator for Copying Control CHAR 4 0 GRPZE
ABED Copying requirements in the order
ADAT Data transfer in the order
BBYR Bonus Buy Conditions
CASB Copying requirements for sales activities
CASC Data transfer for sales activities
CHBE Batch search strategies
CHMV Stock requirements
CHRG Batch requirements
CMPD Requirements for Campaign Determination
EXKO Export requirements
FBED Copying requirements in the billing document
FDAT Data transfer in the billing document
FOFU Subsequent functions
LBED Copying requirements in the delivery
LDAT Data transfer in the delivery
LST1 Info blocks for RV reporting
MCA1 Work item requirements (MCA = Activity)
MCA2 Work item formulas (MCA = Activity)
MCB1 Stock control requirements
MCB2 Stock control formulas
MCE1 PURCHIS Requirements
MCE2 PURCHIS formulas
MCF1 SFIS requirements
MCF2 SFIS formulas
MCI1 PM requirements
MCI2 PM formulas
MCL1 WS requirements in LIS
MCL2 WS requirements in LIS
MCQ1 QMIS requirements
MCQ2 QMIS formulas
MCT1 TIS requirements
MCT2 TIS formulas
MCU1 UIS requirements
MCU2 UIS forms (Utility Information System)
MCV1 SIS requirements
MCV2 SIS formulas
MCW1 RIS requirements
MCW2 RIS formulas
MCZ1 External data requirements
MCZ2 External data formula
OIAA IS-Oil Exchanges: User exit (Swap Partner Business)
OICA IS-Oil MAP : User exit (Marketing, Accouting,Pricing)
OIDA IS-Oil MCOE : User exit (Marketing, Contracts & Order Entry)
OIRA IS-Oil SSR : User exit (Service Station Retailing)
OIUA IS-Oil PRA : User exit (Production & Revenue Accounting)
PACK Conditions:Determinatn of pack.instructions/obj.to be packed
PBED Pricing requirements
PBEF Material determination requirements
PBEK Account determination requirements
PBEL Material listing requirements
PBEN Output control requirements
PBNA Free goods requirements
PBWV Requirements for pricing
PFRA Pricing formulas: Condition basis
PFRM Pricing formulas: Condition value
PFRS Pricing formulas: Scale basis
PSTK Structure of scale key for pricing
REAK Archiving for orders
REKA Archiving for sales activities
RELK Archiving for deliveries
RERK Archiving for billing documents
RISK Risk management (form of payment guarantee)
SPEV Validation Routines for Inbound Deliveries
TBED Copying requirements for texts
TDAT Data transfer involving texts
TNAM Text names for word processing
TRAU Data transfer transport
TXNM Text names for copying modules (out of date)
VCAU Authorization requirements for payment cards
VFCL Multi-dimensional scales
VKMP Credit check requirements
VSEL Data transfer for shipping units
SPRAS Language Key LANG 1 0 T002 SPRAS
VOREF Complete Reference Indicator CHAR 1 0 VOREF
PLMIN Quantity is calculated positively, negatively or not at all CHAR 1 0 PLMIN
+ Positive
- Negative
0 Zero
UPFLU Update Indicator for Document Flow of Sales Document CHAR 1 0 UPFLV
Do not create document flow records
2 Create doc. flow records except for dely/goods issue/billdoc
X Create document flow records
GRUKO Copying Requirements for Data Transfer FPLA NUMC 3 0 GRUFA
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
HINEU Determine customer heirarchy again CHAR 1 0 HINEU
GRUVE Copying requirements for data transfer VEDA NUMC 3 0 GRUVE
VTEXTA Sales Document Type Description CHAR 20 0 TVAKT_BEZEI
VTEXTF Description CHAR 40 0 BEZEI40
VTEXTP Description CHAR 20 0 BEZEI20
CHNEW Indicator: Do Not Copy Batch CHAR 1 0 CHNEW
PSTY2 2nd default item category CHAR 4 0 TVPT PSTYV_NAC2
KNPR2 2nd pricing type CHAR 1 0 KNPR2
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
CMPGN_COPY Copy Mode for Campaign Determination CHAR 1 0 CMPC_COPY_MODE
DT_ROUTINE_NO_ITEM Data Transfer to Sales Document (Item) NUMC 7 0 TDD_DT_ROUTINE_NO_ITEM
CR_ROUTINE_NO_ITEM_BIL Copying Requirement for Sales Document (Item) NUMC 7 0 TDD_CR_ROUTINE_NO_ITEM_BIL

V_TVCPAFP foreign key relationships

Table Field Check Table Check Field
0 V_TVCPAFP AUARN TVAK Sales Document Types MANDT
0 V_TVCPAFP AUARN TVAK Sales Document Types AUART
1 V_TVCPAFP AUARV TVAK Sales Document Types MANDT
1 V_TVCPAFP AUARV TVAK Sales Document Types AUART
0 V_TVCPAFP ETTYN TVEP Sales Document: Schedule Line Categories ETTYP
1 V_TVCPAFP ETTYV TVEP Sales Document: Schedule Line Categories ETTYP
0 V_TVCPAFP FKARV TVFK Billing: Document Types MANDT
0 V_TVCPAFP FKARV TVFK Billing: Document Types FKART
1 V_TVCPAFP MANDT T000 Clients MANDT
0 V_TVCPAFP PSTY2 TVPT Sales Documents: Item categories MANDT
0 V_TVCPAFP PSTY2 TVPT Sales Documents: Item categories PSTYV
1 V_TVCPAFP PSTYN TVPT Sales Documents: Item categories MANDT
1 V_TVCPAFP PSTYN TVPT Sales Documents: Item categories PSTYV
0 V_TVCPAFP PSTYV TVPT Sales Documents: Item categories MANDT
0 V_TVCPAFP PSTYV TVPT Sales Documents: Item categories PSTYV
1 V_TVCPAFP SPRAS T002 Language Keys (Component BC-I18) SPRAS