P_RU_VATREPORTING

CDS View

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_VATReturnSection121 view from CONSUMPTION
P_RU_VATSPLedgersJournal1 view from CONSUMPTION

Fields (53)

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