I_CLRGINFORELATIONFORACCTGDOC

CDS View
11 Fields 18 CDS Views

Clearing Information for Accounting

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

CDS Views using this table (18)

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_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_PT_SAFTPaytDocHeaderCube view_entity inner CONSUMPTION Payment Header for SAFT PT - Cube
C_QA_ClrgReferenceDocumentType view from CONSUMPTION Clearing Reference Document Type
I_PT_SAFTBillgPaytCust view_entity inner COMPOSITE Customer from Payment Document
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 Argentina Supplier Payment - Partial & Full Payments
P_PT_PAYORGON view from COMPOSITE Private Payment Org On
P_PT_PAYORGON view left_outer COMPOSITE Private Payment Org On
P_PT_SAFTPAYMENTLINE view_entity inner COMPOSITE Payment Lines for SAF-T PT
P_RU_BusPartnerClearing view from CONSUMPTION Business Partner Clearing
P_RU_DownPaymentClearing view from CONSUMPTION Down Payment Clearing
P_SK_StRpVATCSClearingInfo view from COMPOSITE SK VAT Control Statement Clearing Info
P_SK_StRpVATCSClearingInfo view inner COMPOSITE SK VAT Control Statement Clearing Info

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,DownPayment 5
KEY AccountingDocumentItem DownPaymentItem,RelatedDocumentItemNumber 2
KEY ClearingAccountingDocument ClearingAccountingDocument 3
KEY ClearingFiscalYear ClearingFiscalYear,FiscalYear 3
KEY ClearingInfoCompanyCode ClearingCompanyCode,ClearingInfoCompanyCode 3
KEY ClearingInformationIndex ClearingInformationIndex,DocumentItemNumber 7
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