/CCIS/PROFTAXT SAP (Totals Table for General Ledger) Table details

Dictionary Type: Table
Description: Totals Table for General Ledger




ABAP Code to SELECT data from /CCIS/PROFTAXT
Related tables to /CCIS/PROFTAXT
Access table /CCIS/PROFTAXT




Table field list including key, data, relationships and ABAP select examples

/CCIS/PROFTAXT is a standard SAP Table which is used to store Totals Table for General Ledger data and is available within R/3 SAP systems depending on the version and release level.

The /CCIS/PROFTAXT table consists of various fields, each holding specific information or linking keys about Totals Table for General Ledger data available in SAP. These include RYEAR (Fiscal Year), OBJNR00 (Object number for table group), OBJNR01 (Object number for table group), OBJNR02 (Object number for table group).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /CCIS/PROFTAXT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
RCLNTClient MANDTCLNT3T000MANDT
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
OBJNR00Object number for table group G_OBJNRINT410INT4
OBJNR01Object number for table group G_OBJNRINT410INT4
OBJNR02Object number for table group G_OBJNRINT410INT4
OBJNR03Object number for table group G_OBJNRINT410INT4
OBJNR04Object number for table group G_OBJNRINT410INT4
OBJNR05Object number for table group G_OBJNRINT410INT4
OBJNR06Object number for table group G_OBJNRINT410INT4
OBJNR07Object number for table group G_OBJNRINT410INT4
OBJNR08Object number for table group G_OBJNRINT410INT4
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
RPMAXPeriod RPMAXNUMC3RPMAX
ACTIVFI-SL Business Transaction ACTI1CHAR4T022ACTIVITY
RMVCTTransaction Type RMVCTCHAR3T856RMVCT
RTCURCurrency Key RTCURCUKY5Assigned to domainWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
AWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
RLDNRLedger in General Ledger Accounting FAGL_RLDNRCHAR2Assigned to domainALPHARLDNRGLN_FLEXFAGL_RLDNR
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3Assigned to domainALPHARVERSGVS
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
RACCTAccount Number RACCTCHAR10SKB1ALPHASAKNRACC
COST_ELEMCost Element KSTARCHAR10CSKBALPHAKSTARKAT
RBUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RTAXOBJTax Object J_3RF_TAX_OBJECTCHAR21Assigned to domainJ_3RF_TAX_OBJECTJ_3RF_TAX_OBJCOLL
REXPTYPEType of Expenses J_3RF_TAX_EXPTYPECHAR1J_3RF_TAX_EXPTYPE
RACTIVTYPActivity Type J_3RF_TAX_ACTTYPECHAR10J_3RF_TAX_ACTTYPE
RMATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
RMATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
RPRODUCTProduct type J_3RF_TAX_PRODUCTCHAR18Assigned to domainMATN1MATNR
RANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
RANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
RTAXREGTax Register Code J_3RF_TAX_REGCODCHAR10J_3RF_TAX_REGCOD
RTAXROWTax Return Row Number J_3RF_TAX_DECROWCHAR17Assigned to domainJ_3RF_TAX_DECROWJ_3RF_TAX_DECROW
RCONTRACTContract Number J_3RF_TAX_CONTRACTCHAR18J_3RF_TAX_CONTRACT
RKTRLAGTCustomer number J_3RF_TAX_KTRLAGTCHAR10Assigned to domainALPHAKUNNR
RDIVISIONDivision Number J_3RF_TAX_DIVISIONCHAR5J_3RF_TAX_DIVISION
SBUKRSCompany code of partner PBUKRSCHAR4T001BUKRSBUK
STAXOBJSending Tax Object J_3RF_TAX_SOBJECTCHAR21Assigned to domainJ_3RF_TAX_OBJECT
SEXPTYPESending Expenses Type J_3RF_TAX_SEXPTYPECHAR1J_3RF_TAX_EXPTYPE
SACTIVTYPSending Activity Type J_3RF_TAX_SACTTYPECHAR10J_3RF_TAX_ACTTYPE
SACCTAccount number J_3RF_TAX_SACCTCHAR10Assigned to domainALPHASAKNRACC
SMATKLMaterial group J_3RF_TAX_SMATKLCHAR9T023MATKLMKLWBWG
SPRODUCTSender product type J_3RF_TAX_SPRODUCTCHAR18Assigned to domainMATN1MATNR
SCONTRACTSending Contract Number J_3RF_TAX_SCONTRACTCHAR18J_3RF_TAX_CONTRACT
SKTRLAGTSending Customer number J_3RF_TAX_SKTRLAGTCHAR10Assigned to domainALPHAKUNNR
SDIVISIONSending Division Number J_3RF_TAX_SDIVISIONCHAR5J_3RF_TAX_DIVISION
TSLVTBalance carried forward in transaction currency TSLVT12CURR23(2) WERTV12
TSL01Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL02Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL03Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL04Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL05Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL06Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL07Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL08Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL09Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL10Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL11Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL12Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL13Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL14Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL15Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL16Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
HSLVTBalance carried forward in local currency HSLVT12CURR23(2) WERTV12
HSL01Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL02Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL03Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL04Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL05Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL06Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL07Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL08Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL09Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL10Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL11Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL12Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL13Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL14Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL15Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL16Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
KSLVTTotal of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL01Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL02Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL03Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL04Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL05Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL06Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL07Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL08Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL09Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL10Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL11Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL12Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL13Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL14Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL15Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL16Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
OSLVTBalance carried forward in fourth currency OSLVT12CURR23(2) WERTV12
OSL01Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL02Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL03Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL04Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL05Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL06Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL07Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL08Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL09Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL10Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL11Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL12Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL13Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL14Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL15Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL16Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
MSLVTBalance carried forward of quantity MSLVT12QUAN23(3) MENGV12
MSL01Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL02Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL03Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL04Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL05Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL06Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL07Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL08Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL09Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL10Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL11Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL12Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL13Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL14Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL15Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL16Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table /CCIS/PROFTAXT using ABAP code

The following ABAP code Example will allow you to do a basic selection on /CCIS/PROFTAXT to SELECT all data from the table
DATA: WA_/CCIS/PROFTAXT TYPE /CCIS/PROFTAXT.

SELECT SINGLE *
FROM /CCIS/PROFTAXT
INTO CORRESPONDING FIELDS OF WA_/CCIS/PROFTAXT
WHERE...

How to access SAP table /CCIS/PROFTAXT

Within an ECC or HANA version of SAP you can also view further information about /CCIS/PROFTAXT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!