I_JOURNALENTRYITEMONETIMEDATA

CDS View
23 Fields 16 CDS Views

One-Time Data for Journal Entry Item

I_JOURNALENTRYITEMONETIMEDATA is a CDS View in S/4HANA. One-Time Data for Journal Entry Item. It contains 23 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_StRpDocLineItemWthRefDoc view left_outer CONSUMPTION Tax Items with Reference Accounting Documents
I_MX_DIOTTxItmBusinessPartner view_entity inner COMPOSITE MX DIOT Tax Details with BP info
I_NO_SAFTCustomerMasterData view_entity inner COMPOSITE Master data of customers for SAFT
I_NO_SAFTSupplierMasterData view_entity inner COMPOSITE Master data of suppliers for SAFT
I_PT_SAFTBillAcctgOneTimeCust view_entity inner COMPOSITE One Time Customer from Accounting Doc
I_PT_SAFTOneTimeAcctgAddr view_entity inner COMPOSITE One Time Customer Addr Accounting Docs
I_SAFTAcctgOneTimeCustomer view inner COMPOSITE SAF-T Accounting OneTimeCustomers
I_SAFTGeneralLedgerOneTimeBP view inner COMPOSITE SAFT GLedger One Time Business Partner
I_SAFTGenLedgerOneTimeCustomer view inner COMPOSITE SAF-T Gen Ledger One Time Customer
I_SAFTGenLedgerOneTimeSupplier view inner COMPOSITE SAF-T Gen Ledger OneTimeSupplier
P_AR_CustomerSupplierEntryItem view_entity inner CONSUMPTION
P_AU_PTROneTimeSupplierC view_entity from CONSUMPTION
P_CO_DIANFrmt1007JrnlItmWthBP2 view_entity inner CONSUMPTION
P_NO_SAFTJournalCustSup view inner COMPOSITE
P_RO_SAFTBSECTaxID view from COMPOSITE BSEC TaxID
P_StRpBillgDocSuplrInvcItem view left_outer COMPOSITE

Fields (23)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AddressID AddressID 5
BankAccount BankAccount 2
BankNumber BankNumber 2
BusinessPartnerName1 BusinessPartnerFullName,BusinessPartnerName1,OrganizationBPName1 3
BusinessPartnerName2 BusinessPartnerName2,OrganizationBPName2 2
BusinessPartnerName3 OrganizationBPName3 1
BusinessPartnerName4 OrganizationBPName4 1
CityName CityName 8
Country Country 9
IsNaturalPerson IsNaturalPerson 1
IsOneTimeAccount IsOneTimeAccount 1
POBox POBox 5
POBoxPostalCode POBoxPostalCode 5
PostalCode PostalCode 7
Region Region 8
StreetAddressName StreetAddressName,StreetName 7
TaxID1 TaxNumber1,VATRegistration 4
TaxID2 TaxNumber2 2
TaxNumberType TaxNumberType 2

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.

-- One-Time Data for Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JOURNALENTRYITEMONETIMEDATA (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    ADDRESSID,
    BANKACCOUNT,
    BANKNUMBER,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CITYNAME,
    COUNTRY,
    ISNATURALPERSON,
    ISONETIMEACCOUNT,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    REGION,
    STREETADDRESSNAME,
    TAXID1,
    TAXID2,
    TAXNUMBERTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR)
);

Learn More