SAP Table TPARG

Arguments for Finding Transfer Prices

TPARG (Arguments for Finding Transfer Prices) 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 TPARG to other SAP tables.

TPARG table fields

Field Data element Checktable Datatype Length Decimals
KURST Exchange Rate Type KURST CHAR 4 0
DATUM System Date SYDATUM DATS 8 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
MTART Material Type MTART CHAR 4 0
MBRSH Industry sector MBRSH CHAR 1 0
MATKL Material Group MATKL CHAR 9 0
SPART Division SPART CHAR 2 0
MAABC ABC Indicator MAABC TMABC CHAR 1 0
BKLAS Valuation Class BKLAS CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
REP_MATNR Representative material for Profit Center Accounting REP_MATNR CHAR 18 0
WAERS Currency Key WAERS CUKY 5 0
KDUMMY Dummy function in length 1 DUMMY CHAR 1 0
TXJCD_SF Jurisdiction code "Ship-from" TXJCD_SF CHAR 15 0
PDUMMY Dummy function in length 1 DUMMY CHAR 1 0
VERTN Contract Number RANL CHAR 13 0
HROBJID Product ID /XLSO/E_PRODUCT_ID NUMC 8 0
CATEGORY_ID Category ID CACS_COM_CATEGORY_ID CHAR 20 0
INDUSTRY Industry Sector CACS_CRM_INDUSTRY CHAR 4 0
SSPARTE Line of Business Package Insurance CACSINS_SPARTE CHAR 20 0
LV Life Insurance
SACH Non-Life Insurance
KRANKEN Health Insurance
TTARIF Tariff Package Insurance CACSINS_TARIF CHAR 20 0
L2 Life Insurance for Fatality and Endowment
RN Private Pension Insurance with Deferment Period
KFZ Vehicle Insurance
KV Private Health Insurance
NAME Surname of Policy Holder CACSINS_NAME CHAR 20 0
VORNAME First Name of Policy Holder CACSINS_VORNAME CHAR 20 0
VSNR Insurance Policy Number CACSINS_VSNR NUMC 20 0
LAUFZEIT Coverage Periods CACSINS_LAUFZEIT DEC 4 2
ANNUAL_PREMIUM Annual Contribution CACSINS_ANNUALPREMIUM CURR 10 2
ZTS_PRODUCT YTEL01 - Product ZTS_PRODUCT CHAR 25 0
LONGDIST. Long Distance
TOLLFREE Toll Free
TELECONF. Teleconferencing
DATAFRREL. Data Frame Relay
DATPRLIDNA Data Private Line DNA
DATPRLIDIG Data Private Line Digital IX
BUSINTERN. Business Internet
ASP ASP
INTWORKING Internetworking
TESCLASSIC TES "Classic"
VOICELOACC Voice Local Access
CENTREX Centrex
DATPRLIANA Data Private Line Analog
SWDATAACC. Switched Data Access (BRI/PRI)
BROADCAST Broadcast
VIDEOCONF. Videoconference
INSIDEWIRE Inside Wire
CPE CPE
CPEMAINT. CPE Maintenance
CPECONVER. CPE Converged
CUSTSOLUT. Custom Solutions
CUSCONCEN. Customer Contact Center
MANWORKPL. Managed Workplace
TECHROLL. Technology Rollover
MANCOLOC. Managed / Co-Locations
SHARHOST. Shared Hosting
GEOMATICS Geomatics
PROFSERV. Professional Services
MANHOST. Managed Hosting
ZTS_EPP_L3 Strategic focused product sets ZTS_EPP_L3 CHAR 1 0
ZTS_CLIENT YTEL01 - Client ZTS_CLIENT CHAR 20 0
ZTS_MANAGER_R YTEL01 - Manager Contract (Reporting) ZTS_MANAGER_R CHAR 20 0
ZTS_SUPPORT_R YTEL01 - Support Rep. Contract Number (Reporting) ZTS_SUPPORT_R CHAR 20 0
ZTS_TERM YTEL01 - Term ZTS_TERM CHAR 3 0
ZTS_DISCOUNT YTEL01 - Discount ZTS_DISCOUNT CHAR 5 0
ZTS_LISTPRICE YTEL01 - Listprice ZTS_LISTPRICE CHAR 5 0
ZTS_MARGIN YTEL01 - Margin ZTS_MARGIN CHAR 5 0
ZTS_CONTRVALUE YTEL01 - Contract Value ZTS_CONTRVALUE CHAR 25 0
ZTS_PERFORM Performance [%] ZTS_PERFORM CHAR 6 0
ZTS_ADJVALTOT Total Adjusted Value ZTS_ADJVALTOT CHAR 25 0
ZTS_TATAR_MTL Accelerated Payout ZTS_TATAR_MTL CHAR 25 0
ZTS_INCTAR_MTL Payment ZTS_INCTAR_MTL CHAR 25 0
ZTS_TNN YTEL01 - TNN (Result) ZTS_TNN CHAR 25 0
ZTS_REP_R YTEL01 - Contract of representative ZTS_REP_R CHAR 20 0
INV_VALUE0 Billing Document Value ZCRMT_00001_0INV_VALUE CURR 17 2
COMM_BAS_VAL Commission Basis Value CACS_CRM_COMMBAS_VALUE_CUM CURR 15 2
CTGTTYPE Target Agreements: Complex Target Type CACS_TGTTYPE CHAR 4 0
CURRENCY Currency CACS_CRM_CURRENCY CUKY 5 0
CURR_YR_TO_DATE Current Year YTD Sales ZCURRYRDATE CURR 15 2
EXO_MONTHLY Monthly Sales of E Revenue ZEXOMONTHLY CURR 15 2
EXO_QTR_ACTUAL Quarterly Sales of E Revenue ZEXOQTRACT CURR 15 2
EXO_QTR_PLAN Quarterly Plan of E Revenue ZEXOQTRPLAN CURR 15 2
INCENTIVE_BAS Bonus Basis Value INCENTIVE_BASIS_VALUE_CUM CURR 15 2
PREV_YR_TO_DATE Previous Year YTD Sales ZPREVYRDATE CURR 15 2
SALESORG0 Sales Organization ZCRMT_00003_0SALESORG CHAR 4 0
STGTTYPE Target Agreements: Elementary Target Types CACS_TGTSIMPLETYPE CHAR 4 0
SUP_MONTHLY Monthly Sales of S Revenue ZSUPMONTHLY CURR 15 2
SUP_QTR_ACTUAL Quarterly Sales of S Revenue ZSUPQTRACT CURR 15 2
SUP_QTR_PLAN Quarterly Plan of S Revenue ZSUPQTRPLAN CURR 15 2
TA_ACT_AMT Target Agreements: Actual Value (Amount) CACS_TGTACTVALAMT CURR 15 2
TA_ACT_QTY Target Agreements: Actual Value (Quantity) CACS_TGTACTVALQTY QUAN 13 3
TA_COR_AMT Target Agreements: Correction Value (Amount) CACS_TGTCORVALAMT CURR 15 2
TA_COR_QTY Target Agreements: Correction Value (Quantity) CACS_TGTCORVALQTY QUAN 13 3
TA_CURR Target Agreement: Currency CACS_TGTCURRENCY CUKY 5 0
TA_KNOCKOUT Target Agreements: Knockout Indicator CACS_KNOCKOUT CHAR 1 0
NULL No Knockout Criteria
X Knockout Criteria (Multiplication)
N Knockout Criteria (Contra Item)
TA_TAR_AMT Target Agreements: Target Value (Amount) CACS_TGTTARVALAMT CURR 15 2
TA_TAR_QTY Target Agreements: Target Value (Quantity) CACS_TGTTARVALQTY QUAN 13 3
TA_UOM Target Agreement: Unit of Measurement CACS_TGTUOM UNIT 3 0
TA_WEIGHT Target Agreements: Weighting CACS_TGTWEIGHT DEC 8 5
U_TERR Territory ZCRMT_00003_U_TERR CHAR 30 0
ZACHV Achievement ZCRMT_00003_ZACHV DEC 17 3
ZCMBASV Total Commission Val ZCRMT_00003_ZCMBASV CURR 17 2
ZDOCVALUE Billing Document Value ZCRMT_00003_ZDOCVALUE CURR 17 2
ZINCTPY Calculated Incentive ZCRMT_00003_ZINCTPY CURR 17 2
ZPRDSALES Product Sales ZCRMT_00003_ZPRDSALES CURR 17 2
ZRTNVALUE Returns Value ZCRMT_00003_ZRTNVALUE CURR 17 2
ZSRVSALES Service Sales ZCRMT_00003_ZSRVSALES CURR 17 2
CTRTST_ID Number of Standard Commission Contract CACS_CTRTST_ID CHAR 20 0
BUCAGR_ID Commission Contract Number CACS_CTRTBU_ID CHAR 20 0
CTRTST Number of Standard Commission Contract CACS_CTRTST_ID CHAR 20 0
REM_BUSCASE_TYP Remunerating Business Transaction in Operational System CACSREMBUSCASTYP CHAR 3 0
P_VERSION Version Date as Timestamp CACS_COND_VERSION NUMC 14 0
P_CTRT_XL Agreement Number Including Contract Type Indicator CACS_COND_CTRTID_XL CHAR 21 0
P_CACSAPPL Commission Application (ICM) CACSAPPL CHAR 6 0
P_STATE Condition Record Status CACSCONDSTATE CHAR 1 0
NULL Valid
P Parked
I Invalid (Active)
O Invalid (Parked)
MVGR1 Material group 1 MVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
J_3ASIZE Grid Value ZZ_J3ASIZE CHAR 8 0
TP_VBELN Delivery VBELN_VL CHAR 10 0
TP_POSNR Delivery Item POSNR_VL NUMC 6 0
TP_EBELN Purchasing Document Number EBELN CHAR 10 0
TP_EBELP Item Number of Purchasing Document EBELP NUMC 5 0
TP_BWART Movement Type (Inventory Management) BWART CHAR 3 0

TPARG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TPARG MAABC SYST MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
TPARG MAABC TPARG MAABC TMABC Values Table for the ABC Indicator for Materials MAABC