I_ADDITIONALFISCALDATAODN

CDS View
14 Fields 6 CDS Views

ODN in Additional Fiscal Data

I_ADDITIONALFISCALDATAODN is a CDS View in S/4HANA. ODN in Additional Fiscal Data. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_AccountingDocumentODN view_entity from BASIC Accounting Document ODN
I_BillingDocumentODN view_entity from BASIC ODN in Billing Document
I_ManualClearingPaytItmODN view_entity from BASIC ODN Numbers for Open Items
I_SettlementDocumentODN view_entity from BASIC ODN in Settlement Document
I_SupplierInvoiceODN view_entity from BASIC ODN in Supplier Invoice
R_OfficialDocumentNumberTP view_entity from TRANSACTIONAL Official Document Number

Fields (14)

KeyField CDS FieldsUsed in Views
KEY AFDFDocumentType AFDFDocumentType 1
KEY AFDFUniqueKeyUUID AFDFUniqueKeyUUID 1
AFDFDocumentKey1 AFDFDocumentKey1 1
AFDFDocumentKey2 AFDFDocumentKey2 1
AFDFDocumentKey3 AFDFDocumentKey3 1
AFDFDocumentKey4 AFDFDocumentKey4 1
AFDFRecordType AFDFRecordType 1
ODNLegalDateTimeText ODNLegalDateTimeText 1
OfficialDocumentNumber OfficialDocumentNumber 1
OfficialDocumentNumberCountry OfficialDocumentNumberCountry 1
OfficialDocumentNumberDateTime OfficialDocumentNumberDateTime 1
OfficialDocumentNumberIntType OfficialDocumentNumberIntType 1
OfficialDocumentNumberType OfficialDocumentNumberType 1
OfficialDocumentNumberTypeText OfficialDocumentNumberTypeText 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.

-- ODN in Additional Fiscal Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDITIONALFISCALDATAODN (
    AFDFDOCUMENTTYPE,
    AFDFUNIQUEKEYUUID,
    AFDFDOCUMENTKEY1,
    AFDFDOCUMENTKEY2,
    AFDFDOCUMENTKEY3,
    AFDFDOCUMENTKEY4,
    AFDFRECORDTYPE,
    ODNLEGALDATETIMETEXT,
    OFFICIALDOCUMENTNUMBER,
    OFFICIALDOCUMENTNUMBERCOUNTRY,
    OFFICIALDOCUMENTNUMBERDATETIME,
    OFFICIALDOCUMENTNUMBERINTTYPE,
    OFFICIALDOCUMENTNUMBERTYPE,
    OFFICIALDOCUMENTNUMBERTYPETEXT,
    PRIMARY KEY (AFDFDOCUMENTTYPE, AFDFUNIQUEKEYUUID)
);

Learn More