FCLM_BAM_BAOR
Request for Opening bank accounts
FCLM_BAM_BAOR is an SAP database table in S/4HANA. Request for Opening bank accounts. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BankAccountOpeningRequest | view | from | BASIC | Bank Account Opening Request |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | request_uuid | sysuuid_x16 | UUID | |||
| request_id | fclm_bam_req_id | Request ID | ||||
| request_status | fclm_bam_req_status | Request Status | ||||
| title | fclm_bam_req_title | Title | ||||
| request_step | fclm_bam_req_step | Request Step | ||||
| contract_type | fclm_bam_contract_type | Contract Type | ||||
| account_action | fclm_bam_acc_action | Action | ||||
| banks | fclm_bam_bank_country_key | Bank Ctry/Rgn. Key | ||||
| bukrs | bukrs | Company Code | ||||
| waers | waers_curc | Currency | ||||
| note | fclm_bam_baor_note | Note | ||||
| created_by | fclm_bam_created_by | Created By | ||||
| created_at | fclm_bam_created_at_tsl | Created At | ||||
| lastchged_by | fclm_bam_changed_by | Changed By | ||||
| lastchged_at | fclm_bam_changed_at_tsl | Changed At | ||||
| local_last_changed_at | fclm_bam_changed_at_tsl | Changed At | ||||
| processed_by | fclm_bam_submitted_by | Processed By | ||||
| processed_at | fclm_bam_submitted_at_tsl | Processed At | ||||
| note_by_processor | fclm_bam_baor_note | Note | ||||
| deleted_flag | boole_d | TRUE |
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.
-- Request for Opening bank accounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_BAOR (
MANDT, -- Client [mandt]
REQUEST_UUID, -- UUID [sysuuid_x16]
REQUEST_ID, -- Request ID [fclm_bam_req_id]
REQUEST_STATUS, -- Request Status [fclm_bam_req_status]
TITLE, -- Title [fclm_bam_req_title]
REQUEST_STEP, -- Request Step [fclm_bam_req_step]
CONTRACT_TYPE, -- Contract Type [fclm_bam_contract_type]
ACCOUNT_ACTION, -- Action [fclm_bam_acc_action]
BANKS, -- Bank Ctry/Rgn. Key [fclm_bam_bank_country_key]
BUKRS, -- Company Code [bukrs]
WAERS, -- Currency [waers_curc]
NOTE, -- Note [fclm_bam_baor_note]
CREATED_BY, -- Created By [fclm_bam_created_by]
CREATED_AT, -- Created At [fclm_bam_created_at_tsl]
LASTCHGED_BY, -- Changed By [fclm_bam_changed_by]
LASTCHGED_AT, -- Changed At [fclm_bam_changed_at_tsl]
LOCAL_LAST_CHANGED_AT, -- Changed At [fclm_bam_changed_at_tsl]
PROCESSED_BY, -- Processed By [fclm_bam_submitted_by]
PROCESSED_AT, -- Processed At [fclm_bam_submitted_at_tsl]
NOTE_BY_PROCESSOR, -- Note [fclm_bam_baor_note]
DELETED_FLAG, -- TRUE [boole_d]
PRIMARY KEY (MANDT, REQUEST_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