COPC_ACCOUNT

Transparent Table Application Table
43 Fields 1 CDS Views

Cash Account

COPC_ACCOUNT is an SAP database table in S/4HANA. Cash Account. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_COPC_ACCOUNT view from CDS View COPC_ACCOUNT in search help

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY account_number copc_account_number Cash Acct No.
KEY active_flag copc_account_active_flag Active
account_status copc_account_status Account Status
account_name copc_account_name Cash Acct Name
account_category copc_account_group Account Group
account_type copc_account_type Account Type
org_contact_name copc_account_contact Contact Person
org_contact_tel copc_tel Telephone No.
org_contact_fax copc_fax Fax Number
org_contact_mail copc_mail_adr E-Mail Address
org_contact_pst copc_pstcd Postal Code
bank_contact_name copc_account_contact Contact Person
bank_contact_tel copc_tel Telephone No.
banks banks Bank Ctry/Reg.
bankl bankk Bank Key
waers waers Currency
bnkacc_name copc_bankacc_name Bank AcctName
plvar plvar Plan version
otype otype Object type
objid copc_de_orgunit_id Org. Unit ID
begda begda Start Date
endda endda End Date
bukrs bukrs Company Code
hbkid hbkid House Bank
hktid hktid Account ID
hb_hkont hkont G/L Acct
bnkacc_no copc_bankacc_no Account No.
bank_area copc_de_bank_area Bank Area
ihc_account_number copc_de_account_number_ext Account Number
zlspr dzlspr Pmnt block
account_epic_flag copc_account_epic_flag EPIC
ernam ernam_rf Created by
erdat erdat_rf Created On
sort1 ad_sort1ul Search Term 1
sort2 ad_sort2ul Search Term 2
address copc_address Address
refer tb_refer Internal Ref.
zuond tb_zuond Assignment
merkm tb_merkm Characteristics
posting_variant epic_copc_posting_variant Posting Variant
reconcile_variant epic_copc_reconcile_variant Recon. Variant
account_comment copc_account_remark Comment

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.

-- Cash Account
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COPC_ACCOUNT (
    MANDT,               -- Client [mandt]
    ACCOUNT_NUMBER,      -- Cash Acct No. [copc_account_number]
    ACTIVE_FLAG,         -- Active [copc_account_active_flag]
    ACCOUNT_STATUS,      -- Account Status [copc_account_status]
    ACCOUNT_NAME,        -- Cash Acct Name [copc_account_name]
    ACCOUNT_CATEGORY,    -- Account Group [copc_account_group]
    ACCOUNT_TYPE,        -- Account Type [copc_account_type]
    ORG_CONTACT_NAME,    -- Contact Person [copc_account_contact]
    ORG_CONTACT_TEL,     -- Telephone No. [copc_tel]
    ORG_CONTACT_FAX,     -- Fax Number [copc_fax]
    ORG_CONTACT_MAIL,    -- E-Mail Address [copc_mail_adr]
    ORG_CONTACT_PST,     -- Postal Code [copc_pstcd]
    BANK_CONTACT_NAME,   -- Contact Person [copc_account_contact]
    BANK_CONTACT_TEL,    -- Telephone No. [copc_tel]
    BANKS,               -- Bank Ctry/Reg. [banks]
    BANKL,               -- Bank Key [bankk]
    WAERS,               -- Currency [waers]
    BNKACC_NAME,         -- Bank AcctName [copc_bankacc_name]
    PLVAR,               -- Plan version [plvar]
    OTYPE,               -- Object type [otype]
    OBJID,               -- Org. Unit ID [copc_de_orgunit_id]
    BEGDA,               -- Start Date [begda]
    ENDDA,               -- End Date [endda]
    BUKRS,               -- Company Code [bukrs]
    HBKID,               -- House Bank [hbkid]
    HKTID,               -- Account ID [hktid]
    HB_HKONT,            -- G/L Acct [hkont]
    BNKACC_NO,           -- Account No. [copc_bankacc_no]
    BANK_AREA,           -- Bank Area [copc_de_bank_area]
    IHC_ACCOUNT_NUMBER,  -- Account Number [copc_de_account_number_ext]
    ZLSPR,               -- Pmnt block [dzlspr]
    ACCOUNT_EPIC_FLAG,   -- EPIC [copc_account_epic_flag]
    ERNAM,               -- Created by [ernam_rf]
    ERDAT,               -- Created On [erdat_rf]
    SORT1,               -- Search Term 1 [ad_sort1ul]
    SORT2,               -- Search Term 2 [ad_sort2ul]
    ADDRESS,             -- Address [copc_address]
    REFER,               -- Internal Ref. [tb_refer]
    ZUOND,               -- Assignment [tb_zuond]
    MERKM,               -- Characteristics [tb_merkm]
    POSTING_VARIANT,     -- Posting Variant [epic_copc_posting_variant]
    RECONCILE_VARIANT,   -- Recon. Variant [epic_copc_reconcile_variant]
    ACCOUNT_COMMENT,     -- Comment [copc_account_remark]
    PRIMARY KEY (MANDT, ACCOUNT_NUMBER, ACTIVE_FLAG)
);

Learn More