P_RU_DSVATREPORTING3JRNL

CDS View
20 Fields 1 CDS Views

P_RU_DSVATREPORTING3JRNL is a CDS View in S/4HANA. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_DSVATReporting4Jrnl view from CONSUMPTION

Fields (20)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
CompanyCode CompanyCode 1
FiscalYear FiscalYear 1
IsCorrectionInvoice IsCorrectionInvoice 1
IsReversal IsReversal 1
IsReversed IsReversed 1
OriginalDocument OriginalDocument 1
OriginalDocumentYear OriginalDocumentYear 1
PostingDate PostingDate 1
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
RU_SourceDocumentType RU_SourceDocumentType 1
RU_VATReturnLine RU_VATReturnLine 1
RU_VATReturnSectionType RU_VATReturnSectionType 1
RU_VATReturnVersion RU_VATReturnVersion 1
RU_VATScenario RU_VATScenario 1
RU_VATSubScenario RU_VATSubScenario 1
TaxCode TaxCode 1
TaxItem TaxItem 1
TaxReportingDate TaxReportingDate 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 P_RU_DSVATREPORTING3JRNL (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    ISCORRECTIONINVOICE,
    ISREVERSAL,
    ISREVERSED,
    ORIGINALDOCUMENT,
    ORIGINALDOCUMENTYEAR,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RU_SOURCEDOCUMENTTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    TAXCODE,
    TAXITEM,
    TAXREPORTINGDATE
);

Learn More