P_RU_VATRETURNSECTION121

CDS View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_VATReturnSection122 view from CONSUMPTION

Fields (44)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartner BusinessPartner 1
BusinessPartnerIsNaturalPerson BusinessPartnerIsNaturalPerson 1
BusinessPartnerIsOrganization BusinessPartnerIsOrganization 1
BusinessTransactionType BusinessTransactionType 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
Currency Currency 1
CurrencyISOCode CurrencyISOCode 1
CustomerName CustomerName 1
DocumentDate DocumentDate 1
ExternalInvoice ExternalInvoice 1
FirstName FirstName 1
FiscalYear FiscalYear 1
InvoiceDate InvoiceDate 1
IsReversal IsReversal 1
IsReversed IsReversed 1
LastName LastName 1
MiddleName MiddleName 1
PostingDate PostingDate 1
RevisionNumber RevisionNumber 1
RU_PartnerOrganizationINN RU_PartnerOrganizationINN 1
RU_PartnerOrganizationKPP RU_PartnerOrganizationKPP 1
RU_PartnerPersonINN RU_PartnerPersonINN 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
Sign Sign 1
SourceDocument SourceDocument 1
SourceDocumentFiscalYear SourceDocumentFiscalYear 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptRunID StatryRptRunID 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 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_VATRETURNSECTION121 (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    BUSINESSPARTNERISNATURALPERSON,
    BUSINESSPARTNERISORGANIZATION,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CURRENCY,
    CURRENCYISOCODE,
    CUSTOMERNAME,
    DOCUMENTDATE,
    EXTERNALINVOICE,
    FIRSTNAME,
    FISCALYEAR,
    INVOICEDATE,
    ISREVERSAL,
    ISREVERSED,
    LASTNAME,
    MIDDLENAME,
    POSTINGDATE,
    REVISIONNUMBER,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PARTNERPERSONINN,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SIGN,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXCODE,
    TAXITEM,
    TAXREPORTINGDATE
);