I_JRNLENTRALTVCRCYTRNSLTNITEM

CDS View
18 Fields 2 CDS Views

T2Factors used in journal entries

I_JRNLENTRALTVCRCYTRNSLTNITEM is a CDS View in S/4HANA. T2Factors used in journal entries. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAC_CDS_HERO_EV view from T2Factors used in journal entries
R_MngJrnlEntrCrcyTranslation view_entity from COMPOSITE Currency Translation of Journal Entry

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY JrnlEntrAltvCrcyTrnsltnItem JrnlEntrAltvCrcyTrnsltnItem 2
PredecessorReferenceDocItem PredecessorReferenceDocItem 2
PredecessorReferenceDocument PredecessorReferenceDocument 2
SDDocumentItem SDDocumentItem 2
ServicesRenderedDate ServicesRenderedDate 2
TaxCode TaxCode 2
TaxCodeValidFromDate TaxCodeValidFromDate 2
TaxCountry TaxCountry 2
TaxJurisdiction TaxJurisdiction 2
TransToCoCodeCrcyCnvrsnFctr TransToCoCodeCrcyCnvrsnFctr 2
TransToCoCodeCrcyCnvrsnMeth TransToCoCodeCrcyCnvrsnMeth 2
TransToCoCodeCrcyExchRate TransToCoCodeCrcyExchRate 2
TransToRptgCrcyCnvrsnFctr TransToRptgCrcyCnvrsnFctr 2
TransToRptgCrcyCnvrsnMeth TransToRptgCrcyCnvrsnMeth 2
TransToRptgCrcyExchRate TransToRptgCrcyExchRate 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.

-- T2Factors used in journal entries
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JRNLENTRALTVCRCYTRNSLTNITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    JRNLENTRALTVCRCYTRNSLTNITEM,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCUMENT,
    SDDOCUMENTITEM,
    SERVICESRENDEREDDATE,
    TAXCODE,
    TAXCODEVALIDFROMDATE,
    TAXCOUNTRY,
    TAXJURISDICTION,
    TRANSTOCOCODECRCYCNVRSNFCTR,
    TRANSTOCOCODECRCYCNVRSNMETH,
    TRANSTOCOCODECRCYEXCHRATE,
    TRANSTORPTGCRCYCNVRSNFCTR,
    TRANSTORPTGCRCYCNVRSNMETH,
    TRANSTORPTGCRCYEXCHRATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, JRNLENTRALTVCRCYTRNSLTNITEM)
);

Learn More