SAP TLCS_WRK Table in S/4 HANA - Transaction view for collective processing
TLCS_WRK is a standard SAP Table which is used to store Transaction view for collective processing data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP TLCS_WRK table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TLCS_WRK
TLCS_WRK table structure field list
Below is the full TLCS_WRK field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
RFHA | Financial Transaction | TB_RFHA | CHAR | 13(0) | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA | RFHA |
CRUSER | Entered By | TB_CRUSER | CHAR | 12(0) | SYCHAR12 | |||||
DCRDAT | Entered On | TB_DCRDAT | DATS | 8(0) | DATUM | |||||
TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6(0) | UZEIT | |||||
UPUSER | Last Changed By | TB_UPUSER | CHAR | 12(0) | SYCHAR12 | |||||
DUPDAT | Changed On | TB_DUPDAT | DATS | 8(0) | DATUM | |||||
TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6(0) | UZEIT | |||||
RANTYP | Contract Type | RANTYP | CHAR | 1(0) | RANTYP | |||||
SANLF | Product Category | SANLF | NUMC | 3(0) | TZAF | VVSANLF | ||||
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3(0) | AT01 | T_SFGTYP | ||||
SGSART | Product Type | VVSART | CHAR | 3(0) | TZPA | VVSART | SAN | VVSART_APPL_BAS | GSART | |
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3(0) | AT10 | T_SFHAART | T02 | C_AT10 | SFHAART | |
RGATT | Class | TI_RGATT | CHAR | 13(0) | ALPHA | T_RGATT | T04 | |||
RMAID | Master Agreement | TB_RMAID | CHAR | 10(0) | VTBMA | ALPHA | T_RMAID | TMA | VTMA | RMAID |
RFHAZUNR | Number Status of Activity | TB_RFHAZUN | NUMC | 5(0) | T_RFHAZU | |||||
RFHAZUL | Last Active Transaction Activity | TB_RFHAZUL | NUMC | 5(0) | T_RFHAZU | |||||
SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1(0) | T_SAKTIV | |||||
KONTRH | Business Partner Number | TB_KUNNR_NEW | CHAR | 10(0) | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER |
SROLEXT | 3-Byte field | CHAR3 | CHAR | 3(0) | CHAR3 | |||||
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10(0) | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER |
RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8(0) | T037S | USTRU | KRE | |||
RREFKONT2 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8(0) | T037S | USTRU | KRE | |||
RPORTB | Portfolio | RPORTB | CHAR | 10(0) | TWPOB | RPORTB | T50 | H_RPORTB_CORE | RPORTB | |
WGSCHFT | Transaction Currency | TB_WGSCHFT | CUKY | 5(0) | TCURC | WAERS | CUR | |||
WGSCHFT1 | Currency of Outgoing Side | TB_WGSCHF1 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
WGSCHFT2 | Currency of Incoming Side | TB_WGSCHF2 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
AMTINPUT | Note Field for Amount Traded in Forex Transactions | TB_AMTIN | CHAR | 1(0) | TX_AMTIN | |||||
DBLFZ | Term Start | TB_DBLFZ | DATS | 8(0) | DATUM | |||||
SKALID | Factory calendar | SKALID | CHAR | 2(0) | TFACD | WFCID | H_TFACD | IDENT | ||
SKALID2 | Factory calendar | SKALID | CHAR | 2(0) | TFACD | WFCID | H_TFACD | IDENT | ||
JLIMIT | Limit Indicator | TB_JLIMIT | CHAR | 1(0) | XFELD | |||||
AKUEND | Period of Notice | TB_AKUEND | NUMC | 3(0) | T_AKUEND | |||||
SKUEND | Unit of Period of Notice | TB_SKUEND | NUMC | 1(0) | T_SKUEND | |||||
OBJNR | Object number | J_OBJNR | CHAR | 22(0) | ONR00 | J_OBJNR | ONR | |||
RLDEPO | Securities Account | VRLDEPO | CHAR | 10(0) | TWD01 | RLDEPO | DEP | |||
ZUONR | Finance Project | TB_TFPROJ | CHAR | 13(0) | T_TFPROJ | |||||
DELFZ | Term End | TB_DELFZ | DATS | 8(0) | DATUM | |||||
ABWTYP | Processing Category | TB_ABWTYP | CHAR | 5(0) | AT05 | T_ABWTYP | ||||
TBEGRU | Authorization Group | TBEGRU | CHAR | 4(0) | TRBRG | TRBEGRU | ||||
VRFHA | Reference Transaction (Rollover/Premature Settlement) | TB_VORFHA | CHAR | 13(0) | Assigned to domain | ALPHA | T_RFHA | |||
SINCLBE | Calculation Period: Start Inclusive vs. End Inclusive | TB_SINCLBE | CHAR | 1(0) | T_SINCLBE | |||||
SNPVCAL | NPV Calculation | TB_SNPVCAL | CHAR | 1(0) | T_SNPVCAL | |||||
SRNDNG | Rounding of Amount from Generated Flows | TB_SRNDNG | CHAR | 1(0) | TFM_SROUND | |||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18(0) | TEXT18 | |||||
REFER | Internal Reference | TB_REFER | CHAR | 16(0) | CHAR16 | |||||
MERKM | Characteristics | TB_MERKM | CHAR | 25(0) | CHAR25 | |||||
SFRGZUST | Transaction Release: Release Status | TB_FRGZUST | CHAR | 1(0) | T_FRGZUST | |||||
RANL | Security Class ID Number | VVRANLW | CHAR | 13(0) | ALPHA | WP_RANL | RAN | SECURITY_F4 | RANL | |
RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4(0) | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | |||
FACILITYNR | Transaction Number of Facility | TB_FACILITYNR | CHAR | 13(0) | VTBFHA | ALPHA | T_RFHA | F4_FTR_FC | RFHA | |
FACILITYBUKRS | Company Code of Facility | TB_FACILITYBUKRS | CHAR | 4(0) | T001 | BUKRS | H_T001 | BUKRS | ||
POSACC | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10(0) | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | POS_ACCOUNT | |
RCOMVALCL2 | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4(0) | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | CVC | |||
FUND | Fund | FM_FUND | CHAR | 10(0) | Assigned to domain | BP_GEBER | FIC | |||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20(0) | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | GRANT_NUMBER | |
TIMESTAMP_DEAL | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18(0) | TRCOT_CTY_MASTER | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | COMMODITY_ID | |
RPORTB2 | Portfolio | RPORTB | CHAR | 10(0) | TWPOB | RPORTB | T50 | H_RPORTB_CORE | RPORTB | |
COMMODITY_ID1 | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18(0) | TRCOT_CTY_MASTER | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | COMMODITY_ID | |
COMMODITY_ID2 | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18(0) | TRCOT_CTY_MASTER | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | COMMODITY_ID | |
CLEARING_OPTION | Central Clearing Option (TREA) | TPM_TREA_CLEARING_OPT | NUMC | 1(0) | TPM_TREA_CLEARING_OPT | |||||
CLEARING_STATUS | Clearing Status (TREA) | TPM_TREA_CLEARING_STATUS | NUMC | 1(0) | TPM_TREA_CLEARING_STATUS | |||||
CLEARING_DATE | Planned Clearing Date | TPM_TREA_CLEARING_DATE | DATS | 8(0) | TPM_TREA_CLEARING_DATE | |||||
EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10(0) | TPM_EXT_ACCOUNT | TREA_EA | TREATH_EXT_ACCOUNT | EXT_ACCOUNT | ||
CLEAR_DATE_ACT | Actual Clearing Date | TPM_TREA_CLEARING_DATE_ACT | DATS | 8(0) | TPM_TREA_CLEARING_DATE | |||||
SCONDITION | Indicates Whether Financial Trans. Is Based on a Condition | FTR_CONDITION_USED | CHAR | 1(0) | FTR_CONDITION_USED | |||||
RISK_MITIGATING | Risk Mitigation Indicator | FTR_THRESHOLD_RISK_MITIGATING | CHAR | 1(0) | FLAG | |||||
FIMA_CALCULATION | Cash Flow Calculation | TB_FIMA_CALCULATION | CHAR | 2(0) | TB_FIMA_CALCULATION | |||||
TRUSTEE | Trustee Number | FTR_TRUSTEE | CHAR | 10(0) | Assigned to domain | ALPHA | BU_PARTNER | |||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR |
RCNTR | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
RBUSA | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
HEDGE_CLASS | Hedging Classification | TOE_HEDGING_CLASSIFICATION | CHAR | 5(0) | Assigned to domain | TOE_HEDGING_CLASSIFICATION | ||||
INIT_CLASSIFIER | Initial Stage Value | TRPA_INITIAL_STAGE | CHAR | 10(0) | TRPA_CLASSIFIER_VALUE | |||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
FB_SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10(0) | FAGL_SEGM | ALPHA | FB_SEGMENT | |||
BEHALF_OF_COMPANY | On Behalf of Company Code | TRBA_BEHALF_OF_COMPANY | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
TRADED_CURRENCY | Traded Currency | FTR_TRADED_CURR | CUKY | 5(0) | Assigned to domain | WAERS | ||||
HEDGE_REQUEST_ID | Hedge Request ID | TOE_REQUEST_ID | CHAR | 13(0) | ALPHA | TOE_REQUEST_ID | ||||
CFI_CODE | CFI Code | FTR_CFI_CODE | CHAR | 6(0) | CHAR6 | |||||
ISIN | Security ID Number (ISIN) | RANL_ISIN | CHAR | 12(0) | ALPHA | RANL_ISIN | ||||
MIC | Market Identifier Code | TBA_MIC | CHAR | 4(0) | TBAC_MIC | TBA_MIC | TBA_MIC | TBAH_MIC | MIC | |
CONTRACT_TIMESTAMP_UTC | Contract Timestamp in UTC | FTR_CONTRACT_TIMESTAMP_UTC | DEC | 21(7) | TZNTSTMPL | |||||
PRESENT_DATE | Presentation Date | FTR_PRE_DATE | DATS | 8(0) | DATS | |||||
INTEREST_PAID_BY | Identify whether applicant or beneficiary pays interest | FTR_INTEREST_PAY_BY | CHAR | 1(0) | FTR_INTEREST_PAYED_BY | |||||
SHIPMENT_DATE | Shipment Date | FTR_SHIP_DATE | DATS | 8(0) | DATS | |||||
STATUS | Status | FTR_STATUS | CHAR | 2(0) | FTR_PRSNT_STATUS | |||||
PRESENT_ID | Presentation Item | FTR_PERSENT_ID | CHAR | 10(0) | FTR_PRSNT_ID | |||||
SSTOGRD | Reason for Reversal | SSTOGRD | CHAR | 2(0) | Assigned to domain | SSTOGRD | ||||
PRESENT_AMOUNT | Presentation Amount | FTR_PRESENT_AMT | CURR | 13(2) | FTR_PRSNT_AMT | |||||
PRESENT_BANK | Presentation Bank | FTR_PRESENT_BANK | CHAR | 10(0) | Assigned to domain | ALPHA | BU_PARTNER | |||
PRESENT_DISCREPANCY | Discrepancy | FTR_DISCREPANCY | CHAR | 1(0) | BOOLEAN | |||||
PRESENT_DECREASE_AMOUNT | Presentation Decreased Amount | FTR_PRESENT_DEC_AMT | CURR | 13(2) | FTR_PRSNT_AMT | |||||
PRESENT_REA_CRE_LINE | Amount of Released Credit Line | FTR_PRESENT_REA_AMT | CURR | 13(2) | FTR_PRSNT_AMT | |||||
PRESENT_PAY_AMT | Payment Amount in Payment Currency | TB_BZBETR | CURR | 13(2) | WERTV7 | |||||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2(0) | T_SFGZUTY | C_AT02 | SFGZUTY | |||
DPROLOL | Last rollover date | TB_DPROLOL | DATS | 8(0) | DATUM | |||||
RDEALER | Trader | RDEALER | CHAR | 12(0) | RDEALER | |||||
DVTRAB | Contract Conclusion Date | TB_DVTRAB | DATS | 8(0) | DATUM | |||||
TVTRAB | Time of Contract Conclusion | TB_TVTRAB | TIMS | 6(0) | UZEIT | |||||
GSPPART | Contact Person | TB_GSPPART | CHAR | 19(0) | TEXT19 | |||||
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16(0) | FTI_CHAR16LOW | |||||
BANLAGE | Single or totaled amount | TM_BSUMME | CURR | 15(2) | WERT8 | |||||
BBLFZ | Amount at start of term/ last rollover date | TM_BBLFZ | CURR | 15(2) | WERT8 | |||||
BELFZ | Amount at end of term | TM_BELFZ | CURR | 15(2) | WERT8 | |||||
BNOMI | Nominal amount | TM_BNOMI | CURR | 15(2) | WERT8 | |||||
XNPVCAL | Name of NPV calculation | TB_XNPVCAL | CHAR | 30(0) | TEXT30 | |||||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
XKONTRH | Name and Address of Business Partner | TB_XKONTRH | CHAR | 80(0) | TEXT80 | |||||
XGSART | Name of Product Type | TB_XGSART | CHAR | 30(0) | TEXT30 | |||||
XFHAART | Name of transaction type | TB_XFHAART | CHAR | 30(0) | TEXT30 | |||||
XANLF | Product Category Name | TB_XANLF | CHAR | 30(0) | TEXT30 | |||||
XFGTYP | Transaction category name | TB_XFGTYP | CHAR | 30(0) | TEXT30 | |||||
XPGTYP | Description of Product Category and Transaction Category | TB_XPGTYP | CHAR | 60(0) | TEXT60 | |||||
XFGZUSTT | Name of Activity Category | TB_XFGZUSTT | CHAR | 30(0) | TEXT30 | |||||
XAKTIV | Active status name | TB_XAKTIV | CHAR | 30(0) | TEXT30 | |||||
XSTATUS | Presentation Status Name | FTR_XSTATUS | CHAR | 30(0) | TEXT30 | |||||
ICON_CHECKED | Processing Indicator | TB_ICON_CHECKED | CHAR | 4(0) | CHAR4 | |||||
PZINS_AMOUNT | Interest rate as amount | TB_BKOND | CURR | 13(2) | WERTV7 | |||||
ICON_LOCKED | Icon in text fields (substitute display, alias) | ICON_D | CHAR | 4(0) | ICON | |||||
SEL | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
XPORTB | Portfolio Name | VVXPORTB | CHAR | 30(0) | TEXT30 | |||||
DELFZ_ACT | Term End | TB_DELFZ | DATS | 8(0) | DATUM | |||||
BZBETR | Payment Amount in Payment Currency | TB_BZBETR | CURR | 13(2) | WERTV7 | |||||
DZTERM | Payment or Delivery Date | TB_DZTERM | DATS | 8(0) | DATUM | T33 | ||||
WZBETR | Payment Currency | TB_WZBETR | CUKY | 5(0) | WAERS | |||||
BNWHR | Nominal Amount | TB_BNWHR | CURR | 13(2) | WERTV7 | |||||
CREDIT_AMT | Credit Amount | FTR_CREDIT_AMT | CURR | 13(2) | FTR_CREDIT_AMT | |||||
CRE_AMT_CUR | Credit Amount Currency | FTR_CRE_AMT_CUR | CUKY | 5(0) | FTR_AMT_CUR | CUR | ||||
LC_NUMBER | Letter of Credit Number | FTR_LC_NUMBER | CHAR | 16(0) | FTR_LC_NUMBER | |||||
BG_NUMBER | Bank Guarantee Number | FTR_BG_NUMBER | CHAR | 16(0) | FTR_BG_NUMBER | |||||
BG_TYPE | Bank Guarantee Type | FTR_BG_TYPE | CHAR | 4(0) | FTR_BG_TYPE | |||||
APPLICANT | Applicant | FTR_APPLICANT | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
BENFICIARY | Beneficiary | FTR_BENEFICIARY | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
ADVISING_BANK | Advising Bank | FTR_ADVISING_BANK | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
CONTRACT_NUMBER | Underlying Contract Number | FTR_CONTRACT_NUM | CHAR | 40(0) | FTR_CONTRACT_NUM | |||||
CONTRACT_DATE | Underlying Contract Date | FTR_CONTRACT_DATE | DATS | 8(0) | FTR_CONTRACT_DATE | |||||
CONTRACT_AMOUNT | Underlying Contract Amount | FTR_CONTRACT_AMOUNT | CURR | 13(2) | FTR_CONTRACT_AMOUNT | |||||
BG_TYPE_DESC | Bank Guarantee Type Description | FTR_BG_TYPE_DESC | CHAR | 50(0) | FTR_BG_TYPE_DESC | |||||
BENEFICIARY_TXT | Name of Beneficiary | FTR_BENEFICIARY_TXT | CHAR | 80(0) | FTR_PARTNER_TXT | |||||
APPLICANT_TXT | Name of Applicant | FTR_APPLICANT_TXT | CHAR | 80(0) | FTR_PARTNER_TXT | |||||
ADVISE_BANK_TXT | Name of Advising Bank | FTR_ADVISING_BANK_TXT | CHAR | 80(0) | FTR_PARTNER_TXT | |||||
ISSUING_BANK | Issuing Bank | FTR_ISSUE_BANK | CHAR | 10(0) | ALPHA | BU_PARTNER | ||||
ISSUE_BANK_TXT | Name of Issuing Bank | FTR_ISS_TXT | CHAR | 80(0) | FTR_PARTNER_TXT | |||||
MAN_BENFICIARY | Manual Input Beneficiary | FTR_MAN_BEN_INDICATOR | CHAR | 1(0) | XFELD | |||||
MAN_ADVISING_BANK | Manual Input Advising Bank | FTR_MAN_ADV_INDICATOR | CHAR | 1(0) | XFELD | |||||
MAN_APPLICANT | Manual Input Applicant | FTR_MAN_APP_INDICATOR | CHAR | 1(0) | XFELD | |||||
MAN_ISSUING_BANK | Manual Input Issuing Bank | FTR_MAN_ISS_INDICATOR | CHAR | 1(0) | XFELD | |||||
MAN_COMP_NAME | Manual Company Name | FTR_MAN_COMP_NAME | CHAR | 25(0) | TEXT25 | |||||
MAN_COMP_ADDR | Manual Company Address | FTR_MAN_COMP_ADDR | CHAR | 80(0) | TEXT80 | |||||
MAN_BANK_NAME | Manual Bank Name | FTR_MAN_BANK_NAME | CHAR | 60(0) | TEXT60 | |||||
MAN_BANK_ADDR | Manual Bank Address | FTR_MAN_BANK_ADDR | CHAR | 80(0) | TEXT80 | |||||
AUTO_EXT_NOTICE_DAYS | Nonextension Notice Days | FTR_SLC_EXT_NOTICE_DAYS | NUMC | 3(0) | FTR_SLC_EXT_NOTICE_DAYS | |||||
AUTO_EXT_PERIOD | Auto Extension Period | FTR_SLC_EXT_PERIOD | NUMC | 3(0) | FTR_SLC_EXT_PERIOD | |||||
AUTO_EXT_FIN_EXPIRY_DATE | Auto Extension Expiry Date | FTR_SLC_EXT_EXPIRY_DATE | DATS | 8(0) | DATUM | |||||
TF_CAT | Trade Finance Category | FTR_TF_CAT | CHAR | 1(0) | FTR_TF_CAT | |||||
MAN_BANK_COUNTRY | Manual Bank Country | FTR_MAN_BANK_CTY_KEY | CHAR | 3(0) | LAND1 | |||||
MAN_COMP_COUNTRY | Manual Company Country | FTR_MAN_COMP_CTY_KEY | CHAR | 3(0) | LAND1 | |||||
NOTICE_DATE | Termination Date | FTR_TERMINATION_DATE | DATS | 8(0) | DATUM |
Search for further information about these or an SAP related objects