FCLMPOA_HD_D

Transparent Table Application Table
19 Fields 2 CDS Views

Draft table for entity R_BANKPOWEROFATTORNEYTP

FCLMPOA_HD_D is an SAP database table in S/4HANA. Draft table for entity R_BANKPOWEROFATTORNEYTP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BankPowerOfAttorneyDraft view_entity from EXTENSION Bank Power of Attorney - Draft Extension
R_BankPowerOfAttorneyDraft view_entity from BASIC Bank Power of Attorney

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bankpowerofattorneyuuid fclm_poa_uuid UUID
bankpowerofattorney fclm_poa_id Power of Attorney ID
validitystartdate fclm_poa_valid_from Valid From
validityenddate fclm_poa_valid_to Valid To
bkpoabankaccountassignmenttype fclm_poa_ba_assgmt BA Assignment Type
bankpowerofattorneyname fclm_poa_descr POA Description
bankpowerofattorneystatus fclm_poa_status Status
bkpoaauthorizationgroup fclm_poa_auth_group Authorization Group
paymentapprovalrule fclm_par_id Rule ID
lastchangedatetime fclm_poa_change_tstmp Changed At
createdbyuser fclm_bam_created_by Created By
creationdatetime fclm_poa_creation_tstmp Created At
lastchangedbyuser fclm_bam_changed_by Changed By
locallastchangedatetime fclm_poa_change_ltstmp Changed
bkpoartntnperiodstartdatetime fclm_poa_ret_period_begn_tstmp Ret. Period Start
bankpowerofattorneyisblocked fclm_poa_block_indicator POA Is Blocked
bankpowerofattorneytype fclm_poa_type
bkpoaattachmentischanged xfeld Checkbox

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.

-- Draft table for entity R_BANKPOWEROFATTORNEYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLMPOA_HD_D (
    MANDT,                           -- Client [mandt]
    BANKPOWEROFATTORNEYUUID,         -- UUID [fclm_poa_uuid]
    BANKPOWEROFATTORNEY,             -- Power of Attorney ID [fclm_poa_id]
    VALIDITYSTARTDATE,               -- Valid From [fclm_poa_valid_from]
    VALIDITYENDDATE,                 -- Valid To [fclm_poa_valid_to]
    BKPOABANKACCOUNTASSIGNMENTTYPE,  -- BA Assignment Type [fclm_poa_ba_assgmt]
    BANKPOWEROFATTORNEYNAME,         -- POA Description [fclm_poa_descr]
    BANKPOWEROFATTORNEYSTATUS,       -- Status [fclm_poa_status]
    BKPOAAUTHORIZATIONGROUP,         -- Authorization Group [fclm_poa_auth_group]
    PAYMENTAPPROVALRULE,             -- Rule ID [fclm_par_id]
    LASTCHANGEDATETIME,              -- Changed At [fclm_poa_change_tstmp]
    CREATEDBYUSER,                   -- Created By [fclm_bam_created_by]
    CREATIONDATETIME,                -- Created At [fclm_poa_creation_tstmp]
    LASTCHANGEDBYUSER,               -- Changed By [fclm_bam_changed_by]
    LOCALLASTCHANGEDATETIME,         -- Changed [fclm_poa_change_ltstmp]
    BKPOARTNTNPERIODSTARTDATETIME,   -- Ret. Period Start [fclm_poa_ret_period_begn_tstmp]
    BANKPOWEROFATTORNEYISBLOCKED,    -- POA Is Blocked [fclm_poa_block_indicator]
    BANKPOWEROFATTORNEYTYPE,         -- fclm_poa_type
    BKPOAATTACHMENTISCHANGED,        -- Checkbox [xfeld]
    PRIMARY KEY (MANDT, BANKPOWEROFATTORNEYUUID)
);

Learn More