P_RU_DSVATREPORTING2

CDS View

P_RU_DSVATREPORTING2 is a CDS View in S/4HANA. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_DSVATReporting3 view from CONSUMPTION
P_RU_DSVATReporting3Jrnl view from CONSUMPTION

Fields (25)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 2
CompanyCode CompanyCode 2
FiscalYear FiscalYear 2
IsCorrectionInvoice IsCorrectionInvoice 2
IsReversal IsReversal 2
IsReversed IsReversed 2
PostingDate PostingDate 2
ReverseDocument ReverseDocument 2
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 2
ReverseDocumentTaxRepDate ReverseDocumentTaxRepDate 1
ReverseTaxItem ReverseTaxItem 1
RU_SourceDocumentType RU_SourceDocumentType 2
RU_VATReturnLine RU_VATReturnLine 2
RU_VATReturnSectionType RU_VATReturnSectionType 2
RU_VATReturnVersion RU_VATReturnVersion 2
RU_VATScenario RU_VATScenario 2
RU_VATSubScenario RU_VATSubScenario 2
RU_VATSubScenarioItem RU_VATSubScenarioItem 1
RU_VATSubScenarioVersion RU_VATSubScenarioVersion 1
SrcDocNmbrForOriginalDocument OriginalDocument 1
SrcDocTypeForOriginalDocument OriginalDocumentType 1
SrcDocYearForOriginalDocument OriginalDocumentYear 1
TaxCode TaxCode 2
TaxItem TaxItem 2
TaxReportingDate TaxReportingDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_DSVATREPORTING2 (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    ISCORRECTIONINVOICE,
    ISREVERSAL,
    ISREVERSED,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDOCUMENTTAXREPDATE,
    REVERSETAXITEM,
    RU_SOURCEDOCUMENTTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOITEM,
    RU_VATSUBSCENARIOVERSION,
    SRCDOCNMBRFORORIGINALDOCUMENT,
    SRCDOCTYPEFORORIGINALDOCUMENT,
    SRCDOCYEARFORORIGINALDOCUMENT,
    TAXCODE,
    TAXITEM,
    TAXREPORTINGDATE
);