P_RU_VATREPORTING1

CDS View

P_RU_VATREPORTING1 is a CDS View in S/4HANA. It contains 50 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_RU_VATOperationType view from CONSUMPTION
P_RU_VATOperationType view union_all CONSUMPTION
P_RU_VATReporting view from CONSUMPTION

Fields (50)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
AgentType AgentType 1
BusinessPartnerType BusinessPartnerType 1
BusinessTransactionType BusinessTransactionType 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
Currency Currency 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
FiscalYear FiscalYear 1
ImprtCstmsDeclnIsRead ImprtCstmsDeclnIsRead 1
IsReversal IsReversal 1
IsReversed IsReversed 1
MatlRcptDateIsRead MatlRcptDateIsRead 1
OriginalReferenceDocument OriginalReferenceDocument 1
PaymentOrderOutputType PaymentOrderOutputType 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
RevisionNumber RevisionNumber 1
RU_CustomerOutputType RU_CustomerOutputType 1
RU_OrgOperationType RU_OrgOperationType 1
RU_PersonOperationType RU_PersonOperationType 1
RU_SubagentOutputType RU_SubagentOutputType 1
RU_SupplierAgentOutputType RU_SupplierAgentOutputType 1
RU_SupplierOutputType RU_SupplierOutputType 1
RU_TaxAmountCalcType RU_TaxAmountCalcType 1
RU_TaxBaseAmountCalcType RU_TaxBaseAmountCalcType 1
RU_TotalAmountCalcType RU_TotalAmountCalcType 1
RU_VATReturnLine RU_VATReturnLine 1
RU_VATReturnSection RU_VATReturnSection 1
RU_VATReturnSectionType RU_VATReturnSectionType 1
RU_VATReturnVersion RU_VATReturnVersion 1
RU_VATScenario RU_VATScenario 1
RU_VATSubScenario RU_VATSubScenario 1
RU_VATSubScenarioVersion RU_VATSubScenarioVersion 1
SalesDealType SalesDealType 1
SenderLogicalSystem SenderLogicalSystem 1
SignIsInverted SignIsInverted 1
SourceDocument SourceDocument 1
SourceDocumentFiscalYear SourceDocumentFiscalYear 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptRunID StatryRptRunID 1
TaxCode TaxCode 1
TaxItem TaxItem 1
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 1
TransactionTypeDetermination TransactionTypeDetermination 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_VATREPORTING1 (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    AGENTTYPE,
    BUSINESSPARTNERTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    IMPRTCSTMSDECLNISREAD,
    ISREVERSAL,
    ISREVERSED,
    MATLRCPTDATEISREAD,
    ORIGINALREFERENCEDOCUMENT,
    PAYMENTORDEROUTPUTTYPE,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REVISIONNUMBER,
    RU_CUSTOMEROUTPUTTYPE,
    RU_ORGOPERATIONTYPE,
    RU_PERSONOPERATIONTYPE,
    RU_SUBAGENTOUTPUTTYPE,
    RU_SUPPLIERAGENTOUTPUTTYPE,
    RU_SUPPLIEROUTPUTTYPE,
    RU_TAXAMOUNTCALCTYPE,
    RU_TAXBASEAMOUNTCALCTYPE,
    RU_TOTALAMOUNTCALCTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SALESDEALTYPE,
    SENDERLOGICALSYSTEM,
    SIGNISINVERTED,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXCODE,
    TAXITEM,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONTYPEDETERMINATION
);