P_SI_CBRGLACCTLINEITEMPRPROCG

CDS View

G/L Account Line Item Preprocessing - SI CB reporting

P_SI_CBRGLACCTLINEITEMPRPROCG is a CDS View in S/4HANA. G/L Account Line Item Preprocessing - SI CB reporting. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_SI_StRpRblsPyblsNonResidentC view_entity from COMPOSITE SI Receivables and Payables of Non-residents - Cube
P_SI_KRDSutblRecordsCntr view_entity from COMPOSITE Suitable Records Counter for G/L Account Customizing
R_SI_RblsPyblsCstmzgTP view_entity from TRANSACTIONAL Slovenia Receivables and Payables Customizing

Fields (21)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY LedgerGLLineItem LedgerGLLineItem 3
KEY SourceLedger Ledger,SourceLedger 3
AccountingDocumentType AccountingDocumentType 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 1
BalanceTransactionCurrency BalanceTransactionCurrency 2
ClearingDate ClearingDate 2
ClearingJournalEntry ClearingJournalEntry 2
Country Country 2
Customer Customer 2
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
FinancialAccountType FinancialAccountType 2
GLAccount GLAccount 2
IsOutgoingPayment IsOutgoingPayment 1
NetDueDate NetDueDate 2
PaymentIsIncoming PaymentIsIncoming 1
PostingDate PostingDate 2
Supplier Supplier 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.

-- G/L Account Line Item Preprocessing - SI CB reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SI_CBRGLACCTLINEITEMPRPROCG (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINBALANCETRANSACCRCY,
    BALANCETRANSACTIONCURRENCY,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    COUNTRY,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    ISOUTGOINGPAYMENT,
    NETDUEDATE,
    PAYMENTISINCOMING,
    POSTINGDATE,
    SUPPLIER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM, SOURCELEDGER)
);