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