I_CLRGINFORELATIONFORACCTGDOC

CDS View
11 Fields 20 CDS Views

Clearing Information for Accounting

I_CLRGINFORELATIONFORACCTGDOC is a CDS View in S/4HANA. Clearing Information for Accounting. It contains 11 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_EG_ClrgReferenceDocumentType view from CONSUMPTION Clearing Information for Accounting Egypt
C_MX_JrnlEntrWithRelatedDocsLg view inner CONSUMPTION Audit Trail in Journal Entries Report
C_PT_SAFTPaymentDocumentC view_entity inner CONSUMPTION Payment Document Header - Cube
C_PT_SAFTPaymentDocValueC view_entity inner CONSUMPTION Total Amount of Payment Document - Cube
C_PT_SAFTPaymentLineC view_entity inner CONSUMPTION Payment Lines for SAFT PT - Cube
C_PT_SAFTPaymentOrderRefer view_entity inner CONSUMPTION Originating Document of the Payment
C_QA_ClrgReferenceDocumentType view from CONSUMPTION Clearing Reference Document Type
I_PT_SAFTPaymentHeader view inner COMPOSITE SAF-T PT Payment Header
I_PT_SAFTPaymentItem view inner COMPOSITE SAF-T PT Payment Item
P_AR_SuplrPaymentPartialFull view_entity inner CONSUMPTION
P_PT_PAYORGON view from COMPOSITE
P_PT_PAYORGON view left_outer COMPOSITE
P_PT_SAFTPAYMENTLINE view_entity inner COMPOSITE Payment Lines for SAF-T PT
P_PT_SAFTPAYORGON view from COMPOSITE
P_RU_BusPartnerClearing view from CONSUMPTION
P_RU_DownPaymentClearing view from CONSUMPTION
P_SK_StRpVATCSClearingInfo view from COMPOSITE
P_SK_StRpVATCSClearingInfo view inner COMPOSITE
P_SK_VATLedgerClearingInfo view_entity from COMPOSITE
P_SK_VATLedgerClearingInfo view_entity inner COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,DownPayment 5
KEY AccountingDocumentItem DownPaymentItem,RelatedDocumentItemNumber 2
KEY ClearingAccountingDocument ClearingAccountingDocument 4
KEY ClearingFiscalYear ClearingFiscalYear,FiscalYear 4
KEY ClearingInfoCompanyCode ClearingCompanyCode,ClearingInfoCompanyCode 4
KEY ClearingInformationIndex ClearingInformationIndex,DocumentItemNumber 8
KEY CompanyCode CompanyCode,DownPaymentCompanyCode 2
CompanyCodeCurrency CompanyCurrency 3
DebitCreditCode DownPaymentDebitCreditCode 1
FiscalYear DownPaymentFiscalYear,FiscalYear 4
TransactionCurrency TransactionCurrency 3

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.

-- Clearing Information for Accounting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CLRGINFORELATIONFORACCTGDOC (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGFISCALYEAR,
    CLEARINGINFOCOMPANYCODE,
    CLEARINGINFORMATIONINDEX,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    DEBITCREDITCODE,
    FISCALYEAR,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, CLEARINGACCOUNTINGDOCUMENT, CLEARINGFISCALYEAR, CLEARINGINFOCOMPANYCODE, CLEARINGINFORMATIONINDEX, COMPANYCODE)
);

Learn More