P_RU_VATCRQSEC9

CDS View

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_DATASELVATCRQNewItems view union_all BASIC
P_RU_DSVATCRQSec9 view from BASIC

Fields (27)

KeyField CDS FieldsUsed in Views
AddFlag AddFlag 2
CorrectiveInvDate CorrectiveInvDate 1
CorrectiveInvExtNumber CorrectiveInvExtNumber 1
CorrectiveInvRevDate CorrectiveInvRevDate 1
CorrectiveInvRevNumber CorrectiveInvRevNumber 1
ErrorCode ErrorCode 1
ExternalDocNumber ExternalDocNumber 1
FiscalYear FiscalYear 2
InvoiceAmountFC DocumentAmountFCurr 1
InvoiceAmountLC DocumentAmount 1
OriginalInvDate OriginalInvDate 1
OrigInvRevDate OrigInvRevDate 1
OrigInvRevNumber OrigInvRevNumber 1
RequestID RequestID 1
RequestLineItemNum LineNumber,RequestLineItemNum 2
TaxPeriod TaxPeriod 2
VAT0BaseAmount VAT0BaseAmount 1
VAT10Amount VAT10Amount 1
VAT10BaseAmount VAT10BaseAmount 1
VAT18Amount VAT18Amount 1
VAT18BaseAmount VAT18BaseAmount 1
VAT5Amount VAT5Amount 1
VAT5BaseAmount VAT5BaseAmount 1
VAT7Amount VAT7Amount 1
VAT7BaseAmount VAT7BaseAmount 1
VATFreeBaseAmount VATFreeBaseAmount 1
VATRetCorrNum CorrNumber,VATRetCorrNum 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_VATCRQSEC9 (
    ADDFLAG,
    CORRECTIVEINVDATE,
    CORRECTIVEINVEXTNUMBER,
    CORRECTIVEINVREVDATE,
    CORRECTIVEINVREVNUMBER,
    ERRORCODE,
    EXTERNALDOCNUMBER,
    FISCALYEAR,
    INVOICEAMOUNTFC,
    INVOICEAMOUNTLC,
    ORIGINALINVDATE,
    ORIGINVREVDATE,
    ORIGINVREVNUMBER,
    REQUESTID,
    REQUESTLINEITEMNUM,
    TAXPERIOD,
    VAT0BASEAMOUNT,
    VAT10AMOUNT,
    VAT10BASEAMOUNT,
    VAT18AMOUNT,
    VAT18BASEAMOUNT,
    VAT5AMOUNT,
    VAT5BASEAMOUNT,
    VAT7AMOUNT,
    VAT7BASEAMOUNT,
    VATFREEBASEAMOUNT,
    VATRETCORRNUM
);