SAP table TVCPA (Sales Documents: Copying Control)

SAP table TVCPA 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
CHNEW Indicator: Do Not Copy Batch CHAR 1 0 CHNEW
PSCOP Copy result of product selection CHAR 1 0 PSCOP
Carry out new product selection
A Copy result of product selection
B Like A, but product selection is never cancelled afterwards
C Reserve
STNEW Reexplode Structure/Free Goods CHAR 1 0 STNEW
CPMEN Copy Quantity CHAR 1 0 CPMEN
Automatic quantity determination
A Copy order quantity
B Copy target quantity
PSTY2 2nd default item category CHAR 4 0 TVPT PSTYV_NAC2
KNPR2 2nd pricing type CHAR 1 0 KNPR2
WKKOP Copy Mode for Material in Value Contract Item CHAR 1 0 WKKOP
No limit
A Value contract item material may not be copied
B Only value contract item material may be copied
COPY_CON Copy Configuration CHAR 1 0 COPY_CON
No particular control
A Copy configuration / do not fix
B Copy / fix configuration
C Copy configuration /automatically fixed
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
LVKOP Copy bill of services CHAR 1 0 LVKOP
Do not Copy
C Copy Service With Costing
X Copy Service Without Costing
CUANZ Indicator: Set Configuration Read / Only After Copy CHAR 1 0 SAPHT_SW_CUANZ
FSH_VASCPY Copy Value-added Services Data CHAR 1 0 FSH_VASCPY
Do not Copy VAS Data and Item
1 Copy VAS Data and Item, No New Determination
FSH_SEACPY Copy Seasonal Data CHAR 1 0 FSH_SEACPY
COPY_CCARD Copy Payment Card CHAR 1 0 COPY_CCARD
FREEZE_PAOBJNR Profitability Segment Is Dependent on Preceding Document CHAR 1 0 SD_FREEZE_PAOBJNR
DT_ROUTINE_NO_HEAD Data Transfer to Sales Documents (Header) NUMC 7 0 TDD_DT_ROUTINE_NO_HEAD
DT_ROUTINE_NO_ITEM Data Transfer to Sales Document (Item) NUMC 7 0 TDD_DT_ROUTINE_NO_ITEM
CR_ROUTINE_NO_HEAD_SLS Copying Requirement for Sales Document (Header) NUMC 7 0 TDD_CR_ROUTINE_NO_HEAD_SLS
CR_ROUTINE_NO_HEAD_BIL Copying Requirement for Sales Document (Header) NUMC 7 0 TDD_CR_ROUTINE_NO_HEAD_BIL
CR_ROUTINE_NO_ITEM_SLS Copying Requirement for Sales Document (Item) NUMC 7 0 TDD_CR_ROUTINE_NO_ITEM_SLS
CR_ROUTINE_NO_ITEM_BIL Copying Requirement for Sales Document (Item) NUMC 7 0 TDD_CR_ROUTINE_NO_ITEM_BIL
RFM_LOCK Fashion Contract Locking during Release Order Creation CHAR 1 0 RFM_TVCPA_LOCK
RFM_RETRY_LOCK Fashion Contract Locking retry during Release Order Creation NUMC 2 0 RFM_TVCPA_RETRY
RFM_LOCK_MASS Fashion Contract Locking during Rel. Order Mass Processing CHAR 1 0 RFM_TVCPA_LOCK_MASS
RFM_CONCPY_GRID Copy Application Variant Data from Fashion Contract CHAR 1 0 RFM_CONCPY_GRID
Copy from Source Document, No Redetermination
A Copy from Source Document if Available, Else Redetermine
B Always Redetermine
CMPGN_COPY Copy Mode for Campaign Determination CHAR 1 0 CMPC_COPY_MODE

TVCPA foreign key relationships

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