P_RU_BUSPARTNERCLEARING

CDS View
13 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_BusPartnerClearingNotRvsd view from CONSUMPTION
P_RU_VATInvoiceClearingChain2 view inner CONSUMPTION

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ClearingAccountingDocument ClearingAccountingDocument 2
KEY ClearingFiscalYear ClearingFiscalYear 2
KEY ClearingInfoCompanyCode ClearingInfoCompanyCode 1
KEY ClearingInformationIndex ClearingInformationIndex 2
AccountingDocument AccountingDocument,ClearedAccountingDocument 2
AccountingDocumentItem AccountingDocumentItem,ClearedAccountingDocumentItem 2
AccountType AccountType,ClearedAccountType 2
ClearingInformationType ClearingInformationType 2
CompanyCode CompanyCode 1
DebitCreditCode DebitCreditCode 1
FiscalYear ClearedFiscalYear,FiscalYear 2
SpecialGLCode SpecialGLCode 1
TransactionCurrency TransactionCurrency 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_BUSPARTNERCLEARING (
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGFISCALYEAR,
    CLEARINGINFOCOMPANYCODE,
    CLEARINGINFORMATIONINDEX,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTTYPE,
    CLEARINGINFORMATIONTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    SPECIALGLCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CLEARINGACCOUNTINGDOCUMENT, CLEARINGFISCALYEAR, CLEARINGINFOCOMPANYCODE, CLEARINGINFORMATIONINDEX)
);

Learn More