P_RU_DSVATREPORTING1

CDS View
19 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_DSVATReporting2 view from CONSUMPTION
P_RU_VATSPLedgerNotRptd1 view inner CONSUMPTION

Fields (19)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 2
AccountingDocumentType AccountingDocumentType 2
CompanyCode CompanyCode 2
DebitCreditCode DebitCreditCode 2
FiscalYear FiscalYear 2
IsNegativePosting IsNegativePosting 1
IsReversal IsReversal 2
IsReversed IsReversed 2
PostingDate PostingDate 2
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
ReverseDocumentTaxRepDate ReverseDocumentTaxRepDate 1
ReverseTaxItem ReverseTaxItem 1
SrcDocNmbrForOriginalDocument SrcDocNmbrForOriginalDocument 2
SrcDocTypeForOriginalDocument SrcDocTypeForOriginalDocument 2
SrcDocYearForOriginalDocument SrcDocYearForOriginalDocument 2
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_DSVATREPORTING1 (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    ISNEGATIVEPOSTING,
    ISREVERSAL,
    ISREVERSED,
    POSTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    REVERSEDOCUMENTTAXREPDATE,
    REVERSETAXITEM,
    SRCDOCNMBRFORORIGINALDOCUMENT,
    SRCDOCTYPEFORORIGINALDOCUMENT,
    SRCDOCYEARFORORIGINALDOCUMENT,
    TAXCODE,
    TAXITEM,
    TAXREPORTINGDATE
);

Learn More