_BKPF

_BKPF is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentCreationDate ValueDate 1
AccountingDocumentHeaderText DocumentHeaderText 1
AlternativeReferenceDocument AlternativeReferenceDocument 1
awkey ObjectKey 2
awsys LogicalSystem 2
bktxt AccountingDocumentHeaderText 2
cpudt AccountingDocumentCreationDate 2
DocumentReferenceID DocumentReferenceID 1
frath UnplannedDeliveryCosts 2
waers Currency 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 _BKPF (
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ALTERNATIVEREFERENCEDOCUMENT,
    AWKEY,
    AWSYS,
    BKTXT,
    CPUDT,
    DOCUMENTREFERENCEID,
    FRATH,
    WAERS
);