P_RU_BUSPARTNERCLEARINGNOTRVSD

CDS View

Business Partner Clearing Not Reversed

P_RU_BUSPARTNERCLEARINGNOTRVSD is a CDS View in S/4HANA. Business Partner Clearing Not Reversed. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_VATInvoiceClearingChain1 view from CONSUMPTION VAT Invoice Clearing Chain - 1
P_RU_VATInvoiceClearingChain3 view inner CONSUMPTION VAT Invoice Clearing Chain - 3

Fields (10)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument,ClearedAccountingDocument,ClearedAccountingDocumentItem 2
AccountingDocumentItem AccountingDocumentItem 1
AccountType AccountType 1
ClearingAccountingDocument ClearedAccountingDocument,ClearingAccountingDocument 2
ClearingFiscalYear ClearedFiscalYear,ClearingFiscalYear 2
ClearingInformationIndex ClearingInformationIndex 2
ClearingInformationType ClearingInformationType 2
CompanyCode CompanyCode 1
DebitCreditCode DebitCreditCode 1
FiscalYear ClearedFiscalYear,FiscalYear 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.

-- Business Partner Clearing Not Reversed
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_BUSPARTNERCLEARINGNOTRVSD (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTTYPE,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGFISCALYEAR,
    CLEARINGINFORMATIONINDEX,
    CLEARINGINFORMATIONTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR
);