_ACCOUNT

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

Fields (36)

KeyField CDS FieldsUsed in Views
Bank Bank 1
BankAccount BankAccountNumber 1
BankAccountCurrency BankAccountCurrency 2
BankAccountInternalID BankAccountInternalID 1
BankAccountNumber BankAccountNumber,CashPositionHierNodeValue 1
BankAccountType AccountType,BankAccountType 4
BankCountry BankCountry 1
BrkrRecnclnNumberOfContracts BrkrRecnclnOriglNrOfContracts 1
BrkrReconciliationActivityDate BrkrReconciliationActivityDate 1
bukrs CompanyCode 1
BusinessArea BusinessArea 3
BusinessAreaName BusinessAreaName 2
BusinessTransactionCreateDate BusinessTransactionCreateDate 1
BusinessTransactionCreateTime BusinessTransactionCreateTime 1
CompanyCode CompanyCode 4
CompanyCodeName CompanyCodeName 2
ContrDrvtvContrMaturityCode ContrDrvtvContrMaturityCode 1
ControllingArea ControllingArea 3
ControllingAreaName ControllingAreaName 2
Country Country 1
DerivativeContrSpecification DerivativeContrSpecification 1
DerivativeContrSpecName DerivativeContrSpecName 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FutureAccount FutureAccount 1
IBAN IBAN 1
LotSize LotSize 1
LotSizeUnitOfMeasure LotSizeUnitOfMeasure 1
PositionAccountNumber PositionAccountNumber 1
PositionCurrency PositionCurrency 1
ProfitCenter ProfitCenter 3
RiskPartnerNo RiskPartnerNo 1
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 (
    BANK,
    BANKACCOUNT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTINTERNALID,
    BANKACCOUNTNUMBER,
    BANKACCOUNTTYPE,
    BANKCOUNTRY,
    BRKRRECNCLNNUMBEROFCONTRACTS,
    BRKRRECONCILIATIONACTIVITYDATE,
    BUKRS,
    BUSINESSAREA,
    BUSINESSAREANAME,
    BUSINESSTRANSACTIONCREATEDATE,
    BUSINESSTRANSACTIONCREATETIME,
    COMPANYCODE,
    COMPANYCODENAME,
    CONTRDRVTVCONTRMATURITYCODE,
    CONTROLLINGAREA,
    CONTROLLINGAREANAME,
    COUNTRY,
    DERIVATIVECONTRSPECIFICATION,
    DERIVATIVECONTRSPECNAME,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FUTUREACCOUNT,
    IBAN,
    LOTSIZE,
    LOTSIZEUNITOFMEASURE,
    POSITIONACCOUNTNUMBER,
    POSITIONCURRENCY,
    PROFITCENTER,
    RISKPARTNERNO,
    SECURITYCLASS,
    SEGMENT,
    SEGMENTNAME,
    TREASURYPOSITIONLONGSHORTCODE,
    TREASURYPOSITIONLOTUUID
);