P_RU_VATSPLEDGERSJOURNAL

CDS View
73 Fields 2 CDS Views

SPLedgers/Journal

P_RU_VATSPLEDGERSJOURNAL is a CDS View in S/4HANA. SPLedgers/Journal. It contains 73 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_VATInvoiceJournal1 view from CONSUMPTION Invoice Journal: Amounts
P_RU_VATSPLedgers1 view from CONSUMPTION SPLedgers: Amounts-1

Fields (73)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
CorrectionInvoice CorrectionInvoice 1
CorrectionInvoiceDate CorrectionInvoiceDate 1
CorrectionInvoiceRevisionDate CorrectionInvoiceRevisionDate 1
CorrectionInvoiceRevisionNmbr CorrectionInvoiceRevisionNmbr 1
CorrectionInvoiceYear CorrectionInvoiceYear 1
CorRev_BusinessPartnerINN CorRev_BusinessPartnerINN 1
CorRev_BusinessPartnerIsNP CorRev_BusinessPartnerIsNP 1
CorRev_BusinessPartnerIsOrg CorRev_BusinessPartnerIsOrg 1
CorRev_BusinessPartnerKPP CorRev_BusinessPartnerKPP 1
CorRev_BusinessPartnerName CorRev_BusinessPartnerName 1
CorRev_CommisTradeCustIsNP CorRev_CommisTradeCustIsNP 1
CorRev_CommisTradeCustIsOrg CorRev_CommisTradeCustIsOrg 1
CorRev_CommisTradeCustomerINN CorRev_CommisTradeCustomerINN 1
CorRev_CommisTradeCustomerKPP CorRev_CommisTradeCustomerKPP 1
CorRev_CommisTradeCustomerName CorRev_CommisTradeCustomerName 1
CorRev_CommisTradeSupplierINN CorRev_CommisTradeSupplierINN 1
CorRev_CommisTradeSupplierKPP CorRev_CommisTradeSupplierKPP 1
CorRev_CommisTradeSupplierName CorRev_CommisTradeSupplierName 1
CorRev_CommisTradeSupplIsNP CorRev_CommisTradeSupplIsNP 1
CorRev_CommisTradeSupplIsOrg CorRev_CommisTradeSupplIsOrg 1
CorRev_SupplierINN CorRev_SupplierINN 1
CorRev_SupplierIsNP CorRev_SupplierIsNP 1
CorRev_SupplierIsOrg CorRev_SupplierIsOrg 1
CorRev_SupplierKPP CorRev_SupplierKPP 1
CorRev_SupplierName CorRev_SupplierName 1
Currency Currency 1
CurrencyISOCode CurrencyISOCode 1
DocumentDate DocumentDate 1
ExternalCorrectionInvoice ExternalCorrectionInvoice 1
ExternalInvoice ExternalInvoice 1
FiscalYear FiscalYear 1
Invoice Invoice 1
InvoiceDate InvoiceDate 1
InvoiceYear InvoiceYear 1
IsReversal IsReversal 1
IsReversed IsReversed 1
OriginalInvoiceRevisionDate OriginalInvoiceRevisionDate 1
OriginalInvoiceRevisionNumber OriginalInvoiceRevisionNumber 1
PostingDate PostingDate 1
RevisionInvoice RevisionInvoice 1
RevisionInvoiceYear RevisionInvoiceYear 1
RevisionNumber RevisionNumber 1
RU_CustomerOutputType RU_CustomerOutputType 1
RU_InvoiceType RU_InvoiceType 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_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
Sign Sign 1
SourceDocument SourceDocument 1
SourceDocumentFiscalYear SourceDocumentFiscalYear 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptRunID StatryRptRunID 1
TaxAmountInTransCrcy TaxAmountInTransCrcy 1
TaxCode TaxCode 1
TaxItem TaxItem 1
TaxItemGroupingVersion TaxItemGroupingVersion 1
TaxReportingDate TaxReportingDate 1
TotalAmountInTransactionCrcy AmountInTransactionCurrency,TotalAmountInTransactionCrcy 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.

-- SPLedgers/Journal
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_VATSPLEDGERSJOURNAL (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEREVISIONDATE,
    CORRECTIONINVOICEREVISIONNMBR,
    CORRECTIONINVOICEYEAR,
    CORREV_BUSINESSPARTNERINN,
    CORREV_BUSINESSPARTNERISNP,
    CORREV_BUSINESSPARTNERISORG,
    CORREV_BUSINESSPARTNERKPP,
    CORREV_BUSINESSPARTNERNAME,
    CORREV_COMMISTRADECUSTISNP,
    CORREV_COMMISTRADECUSTISORG,
    CORREV_COMMISTRADECUSTOMERINN,
    CORREV_COMMISTRADECUSTOMERKPP,
    CORREV_COMMISTRADECUSTOMERNAME,
    CORREV_COMMISTRADESUPPLIERINN,
    CORREV_COMMISTRADESUPPLIERKPP,
    CORREV_COMMISTRADESUPPLIERNAME,
    CORREV_COMMISTRADESUPPLISNP,
    CORREV_COMMISTRADESUPPLISORG,
    CORREV_SUPPLIERINN,
    CORREV_SUPPLIERISNP,
    CORREV_SUPPLIERISORG,
    CORREV_SUPPLIERKPP,
    CORREV_SUPPLIERNAME,
    CURRENCY,
    CURRENCYISOCODE,
    DOCUMENTDATE,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALINVOICE,
    FISCALYEAR,
    INVOICE,
    INVOICEDATE,
    INVOICEYEAR,
    ISREVERSAL,
    ISREVERSED,
    ORIGINALINVOICEREVISIONDATE,
    ORIGINALINVOICEREVISIONNUMBER,
    POSTINGDATE,
    REVISIONINVOICE,
    REVISIONINVOICEYEAR,
    REVISIONNUMBER,
    RU_CUSTOMEROUTPUTTYPE,
    RU_INVOICETYPE,
    RU_ORGOPERATIONTYPE,
    RU_PERSONOPERATIONTYPE,
    RU_SUBAGENTOUTPUTTYPE,
    RU_SUPPLIERAGENTOUTPUTTYPE,
    RU_SUPPLIEROUTPUTTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SALESDEALTYPE,
    SIGN,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TAXREPORTINGDATE,
    TOTALAMOUNTINTRANSACTIONCRCY
);

Learn More