FCLM_BAM_REQ
Change request for bank account master Data
FCLM_BAM_REQ is an SAP database table in S/4HANA. Change request for bank account master Data. It contains 15 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BankAccInWorkFlow | view | from | BASIC | Bank Accounts in Work Flow |
| I_BankAccountChangeRequest | view | from | BASIC | Bank Account Change Request |
| I_BankAccountElectronicMessage | view_entity | inner | BASIC | EBAM message |
| I_BankAccountInVerification | view | inner | BASIC | To be verfied bank account |
| I_BankAccountRevisionWorkflow | view | inner | BASIC | Bank Account Revision created in workflow mode |
| I_BankAccSentItems | view_entity | from | BASIC | Bank Account Sent Items |
| I_BankAcctChangeRequest | view | from | BASIC | Bank Account Change Request |
| I_BankAcctRevBase | view_entity | from | BASIC | Base CDS view for review requests |
| I_BankAcctTwoPersonAllReq | view | from | BASIC | Bank Account Change Requests of Two Person Verification Mode |
| I_BankAccTwoPersonReq | view | from | BASIC | Bank Account Two Person mode request |
| VFCLM_BAM_DDL_ACCOUNTINAPPROC | view | inner | Bank Accounts in Approval Process | |
| VFCLM_BAM_DDL_CHGREQ | view | from | Change Request | |
| VFCLM_BAM_DDL_REQHIST | view | from | Change Request History | |
| VFCLM_BAM_DDL_REVIEWSTATUS | view | inner | Bank Account Review Status |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | request_id | fclm_bam_req_id | Request ID | |||
| request_status | fclm_bam_req_status | Request Status | ||||
| account_action | fclm_bam_acc_action | Action | ||||
| request_process | fclm_bam_req_process | Process | ||||
| title | fclm_bam_req_title | Title | ||||
| created_on | fclm_bam_created_on | Created On | ||||
| created_by | fclm_bam_created_by | Created By | ||||
| created_tm | cputm | Entered at | ||||
| lastchged_on | fclm_bam_lastchgon | Changed On | ||||
| lastchged_by | fclm_bam_lastchgby | Changed By | ||||
| lastchged_tm | cputm | Entered at | ||||
| request_step | fclm_bam_req_step | Request Step | ||||
| duedate | fclm_bam_duedate | Due Date | ||||
| bypass_check_mass | fclm_bam_bypass_check_mass | Bypass Validation |
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.
-- Change request for bank account master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_REQ (
MANDT, -- Client [mandt]
REQUEST_ID, -- Request ID [fclm_bam_req_id]
REQUEST_STATUS, -- Request Status [fclm_bam_req_status]
ACCOUNT_ACTION, -- Action [fclm_bam_acc_action]
REQUEST_PROCESS, -- Process [fclm_bam_req_process]
TITLE, -- Title [fclm_bam_req_title]
CREATED_ON, -- Created On [fclm_bam_created_on]
CREATED_BY, -- Created By [fclm_bam_created_by]
CREATED_TM, -- Entered at [cputm]
LASTCHGED_ON, -- Changed On [fclm_bam_lastchgon]
LASTCHGED_BY, -- Changed By [fclm_bam_lastchgby]
LASTCHGED_TM, -- Entered at [cputm]
REQUEST_STEP, -- Request Step [fclm_bam_req_step]
DUEDATE, -- Due Date [fclm_bam_duedate]
BYPASS_CHECK_MASS, -- Bypass Validation [fclm_bam_bypass_check_mass]
PRIMARY KEY (MANDT, REQUEST_ID)
);
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