FCLM_FB2_TRCRT
Flow Builder 2.0: Traceability Result
FCLM_FB2_TRCRT is an SAP database table in S/4HANA. Flow Builder 2.0: Traceability Result. It contains 54 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CashDocumentChainTraceResult | view_entity | from | BASIC | Flow Builder Traceability Result |
Fields (54)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | result_uuid | SYSUUID_X16 | UUID | |||
| current_step | CHAR50 | c | ||||
| trace_uuid | SYSUUID_X16 | UUID | ||||
| parent_step | CHAR50 | c | ||||
| bukrs | FIS_BUKRS | Company Code | ||||
| gjahr | FIS_GJAHR_NO_CONV | Fiscal Year | ||||
| belnr | FARP_BELNR_D | Journal Entry | ||||
| buzei | FIS_BUZEI | Posting View Item | ||||
| fkont | FCLM_FKONT | GL Classification | ||||
| forward_type | FCLM_OFFSETTYPE | Offsetting Type | ||||
| paired_dmbtr | FIS_HSL | Amount in Company Code Currency | ||||
| hwaer | FIS_HWAER | Company Code Currency | ||||
| paired_wmbtr | FIS_WSL | Amount in Transaction Currency | ||||
| waers | FIS_RWCUR | Transaction Currency | ||||
| chain_step | FQM_CHAIN_STEP | Chain Step | ||||
| is_final | FCLM_FINALFLG | Final Flag | ||||
| fi_account | FIS_RACCT | G/L Account | ||||
| base_amount | FQM_AMOUNT | Amount | ||||
| base_currency | FQM_CURRENCY | Currency | ||||
| amount | FQM_AMOUNT | Amount | ||||
| currency | FQM_CURRENCY | Currency | ||||
| quantity | FQM_QUANT | Quantity | ||||
| unit_of_measure | FQM_UNIT | Unit | ||||
| trm_product_type | VVSART | Product Type | ||||
| trm_transaction_type | TB_SFHAART | Transactn Type | ||||
| trm_activity_category | TB_SFGZUTY | Activity Cat. | ||||
| trm_security_id | VVRANLW | Security Class | ||||
| trm_security_account | RLDEPO | Securities Acct | ||||
| trm_portfolio | RPORTB | Portfolio | ||||
| house_bank | HBKID | House Bank | ||||
| house_bank_account | HKTID | Account ID | ||||
| bank_account_id | FCLM_BAM_ACC_ID | Technical ID | ||||
| company_code | BUKRS | Company Code | ||||
| customer_number | KUNNR | Customer | ||||
| vendor_number | LIFNR | Supplier | ||||
| partner | BU_PARTNER | Bus. Partner | ||||
| material | MATNR | Material | ||||
| business_area | GSBER | Business Area | ||||
| profit_center | PRCTR | Profit Center | ||||
| project | PS_PSP_PNR | WBS Element | ||||
| cost_center | KOSTL | Cost Center | ||||
| trading_partner | RASSC | Trading Partner | ||||
| liquidity_item | FLQPOS | Liquidity Item | ||||
| segment | FB_SEGMENT | Segment | ||||
| planning_level | FDLEV | Planning Level | ||||
| planning_group | FDGRP | Planning group | ||||
| contract_number | VERTNR | Contract Number | ||||
| contract_type | RANTYP | Contract Type | ||||
| assigned_company_code | BUKRS | Company Code | ||||
| internal_reference | TB_REFER | Internal Ref. | ||||
| characteristics | TB_MERKM | Characteristics | ||||
| assignment | TB_ZUOND | Assignment | ||||
| local_last_changed_at | ABP_LOCINST_LASTCHANGE_TSTMPL | Changed On |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Flow Builder 2.0: Traceability Result
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_FB2_TRCRT (
CLIENT, -- abap.clnt
RESULT_UUID, -- UUID [SYSUUID_X16]
CURRENT_STEP, -- c [CHAR50]
TRACE_UUID, -- UUID [SYSUUID_X16]
PARENT_STEP, -- c [CHAR50]
BUKRS, -- Company Code [FIS_BUKRS]
GJAHR, -- Fiscal Year [FIS_GJAHR_NO_CONV]
BELNR, -- Journal Entry [FARP_BELNR_D]
BUZEI, -- Posting View Item [FIS_BUZEI]
FKONT, -- GL Classification [FCLM_FKONT]
FORWARD_TYPE, -- Offsetting Type [FCLM_OFFSETTYPE]
PAIRED_DMBTR, -- Amount in Company Code Currency [FIS_HSL]
HWAER, -- Company Code Currency [FIS_HWAER]
PAIRED_WMBTR, -- Amount in Transaction Currency [FIS_WSL]
WAERS, -- Transaction Currency [FIS_RWCUR]
CHAIN_STEP, -- Chain Step [FQM_CHAIN_STEP]
IS_FINAL, -- Final Flag [FCLM_FINALFLG]
FI_ACCOUNT, -- G/L Account [FIS_RACCT]
BASE_AMOUNT, -- Amount [FQM_AMOUNT]
BASE_CURRENCY, -- Currency [FQM_CURRENCY]
AMOUNT, -- Amount [FQM_AMOUNT]
CURRENCY, -- Currency [FQM_CURRENCY]
QUANTITY, -- Quantity [FQM_QUANT]
UNIT_OF_MEASURE, -- Unit [FQM_UNIT]
TRM_PRODUCT_TYPE, -- Product Type [VVSART]
TRM_TRANSACTION_TYPE, -- Transactn Type [TB_SFHAART]
TRM_ACTIVITY_CATEGORY, -- Activity Cat. [TB_SFGZUTY]
TRM_SECURITY_ID, -- Security Class [VVRANLW]
TRM_SECURITY_ACCOUNT, -- Securities Acct [RLDEPO]
TRM_PORTFOLIO, -- Portfolio [RPORTB]
HOUSE_BANK, -- House Bank [HBKID]
HOUSE_BANK_ACCOUNT, -- Account ID [HKTID]
BANK_ACCOUNT_ID, -- Technical ID [FCLM_BAM_ACC_ID]
COMPANY_CODE, -- Company Code [BUKRS]
CUSTOMER_NUMBER, -- Customer [KUNNR]
VENDOR_NUMBER, -- Supplier [LIFNR]
PARTNER, -- Bus. Partner [BU_PARTNER]
MATERIAL, -- Material [MATNR]
BUSINESS_AREA, -- Business Area [GSBER]
PROFIT_CENTER, -- Profit Center [PRCTR]
PROJECT, -- WBS Element [PS_PSP_PNR]
COST_CENTER, -- Cost Center [KOSTL]
TRADING_PARTNER, -- Trading Partner [RASSC]
LIQUIDITY_ITEM, -- Liquidity Item [FLQPOS]
SEGMENT, -- Segment [FB_SEGMENT]
PLANNING_LEVEL, -- Planning Level [FDLEV]
PLANNING_GROUP, -- Planning group [FDGRP]
CONTRACT_NUMBER, -- Contract Number [VERTNR]
CONTRACT_TYPE, -- Contract Type [RANTYP]
ASSIGNED_COMPANY_CODE, -- Company Code [BUKRS]
INTERNAL_REFERENCE, -- Internal Ref. [TB_REFER]
CHARACTERISTICS, -- Characteristics [TB_MERKM]
ASSIGNMENT, -- Assignment [TB_ZUOND]
LOCAL_LAST_CHANGED_AT, -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
PRIMARY KEY (CLIENT, RESULT_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA