_ACCOUNT

_ACCOUNT is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed in Views
KEY DCoAccountUUID DCoAccountUUID 2
KEY DCoBusinessPartnerUUID DCoBusinessPartnerUUID 2
_AccountHolder _Party 1
AuthorizationGroup AuthorizationGroup 1
BankAccount BankAccountNumber 1
BankAccountCurrency BankAccountCurrency 1
BankAccountNumber BankAccountNumber 1
BankAccountType BankAccountType 3
BankCountry BankCountry 1
BankGroupName BankGroupName 1
BankName BankName 1
BankNumber BankNumber 1
BrkrRecnclnNumberOfContracts BrkrRecnclnOriglNrOfContracts 1
BrkrReconciliationActivityDate BrkrReconciliationActivityDate 1
bukrs CompanyCode 1
BusinessArea BusinessArea 3
BusinessAreaName BusinessAreaName 2
BusinessPartner BusinessPartner 1
BusinessTransactionCreateDate BusinessTransactionCreateDate 1
BusinessTransactionCreateTime BusinessTransactionCreateTime 1
CompanyCode CompanyCode 4
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeName CompanyCodeName 3
ContrDrvtvContrMaturityCode ContrDrvtvContrMaturityCode 1
ControllingArea ControllingArea 3
ControllingAreaName ControllingAreaName 2
DerivativeContrSpecification DerivativeContrSpecification 1
DerivativeContrSpecName DerivativeContrSpecName 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FutureAccount FutureAccount 1
IBAN IBAN 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LotSize LotSize 1
LotSizeUnitOfMeasure LotSizeUnitOfMeasure 1
PayFnAccountHolderPartyUUID PayFnAccountHolderPartyUUID 3
PositionAccountNumber PositionAccountNumber 1
PositionCurrency PositionCurrency 1
ProfitCenter ProfitCenter 3
SecurityClass SecurityClass 1
Segment Segment 3
SegmentName SegmentName 2
TreasuryPositionLongShortCode TreasuryPositionLongShortCode 1
TreasuryPositionLotUUID TreasuryPositionLotUUID 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ACCOUNT (
    DCOACCOUNTUUID,
    DCOBUSINESSPARTNERUUID,
    _ACCOUNTHOLDER,
    AUTHORIZATIONGROUP,
    BANKACCOUNT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTNUMBER,
    BANKACCOUNTTYPE,
    BANKCOUNTRY,
    BANKGROUPNAME,
    BANKNAME,
    BANKNUMBER,
    BRKRRECNCLNNUMBEROFCONTRACTS,
    BRKRRECONCILIATIONACTIVITYDATE,
    BUKRS,
    BUSINESSAREA,
    BUSINESSAREANAME,
    BUSINESSPARTNER,
    BUSINESSTRANSACTIONCREATEDATE,
    BUSINESSTRANSACTIONCREATETIME,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    COMPANYCODENAME,
    CONTRDRVTVCONTRMATURITYCODE,
    CONTROLLINGAREA,
    CONTROLLINGAREANAME,
    DERIVATIVECONTRSPECIFICATION,
    DERIVATIVECONTRSPECNAME,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FUTUREACCOUNT,
    IBAN,
    ISBUSINESSPURPOSECOMPLETED,
    LOTSIZE,
    LOTSIZEUNITOFMEASURE,
    PAYFNACCOUNTHOLDERPARTYUUID,
    POSITIONACCOUNTNUMBER,
    POSITIONCURRENCY,
    PROFITCENTER,
    SECURITYCLASS,
    SEGMENT,
    SEGMENTNAME,
    TREASURYPOSITIONLONGSHORTCODE,
    TREASURYPOSITIONLOTUUID,
    PRIMARY KEY (DCOACCOUNTUUID, DCOBUSINESSPARTNERUUID)
);