I_LOANCONTRACTLDOCITMDATA

CDS View
50 Fields 5 CDS Views

Actual Document Item for Loan Contract

I_LOANCONTRACTLDOCITMDATA is a CDS View in S/4HANA. Actual Document Item for Loan Contract. It contains 50 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_LoanContrPostedItemData view from COMPOSITE Posted Item for Loan Contract
P_BusinessPartnerWaiver view inner COMPOSITE
P_BusinessPartnerWriteoff view inner COMPOSITE
P_LoanContrWaiver view inner COMPOSITE
P_LoanContrWriteoff view inner COMPOSITE

Fields (50)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY PostedDocumentActivityNumber PostedDocumentActivityNumber 1
KEY PostedDocumentID PostedDocumentID 1
AccountingDocument AccountingDocument 1
AccrDefrlRefFlwCat AccrDefrlRefFlwCat 1
BusinessPartner BusinessPartner 1
CalcEndDteIsInclusive CalcEndDteIsInclusive 1
CalcPeriodEndDateIsInclusive CalcPeriodEndDateIsInclusive 1
CalcPeriodStartDateIsExclusive CalcPeriodStartDateIsExclusive 1
CalculationPeriodEndDate CalculationPeriodEndDate 1
CalculationPeriodStartDate CalculationPeriodStartDate 1
CashFlowItemBillDueDate CashFlowItemBillDueDate 1
CashFlowItemCalcDate CashFlowItemCalcDate 1
CashFlowItemCategory CashFlowItemCategory 1
CashFlowItemDueDate CashFlowItemDueDate 1
CashFlowItemEditedBy CashFlowItemEditedBy 1
CashFlowItemEditedDate CashFlowItemEditedDate 1
CashFlowItemEditedSource CashFlowItemEditedSource 1
CashFlowItemEditedTime CashFlowItemEditedTime 1
CashFlowItemEnteredBy CashFlowItemEnteredBy 1
CashFlowItemEnteredDate CashFlowItemEnteredDate 1
CashFlowItemEnteredSource CashFlowItemEnteredSource 1
CashFlowItemEnteredTime CashFlowItemEnteredTime 1
CashFlowItemGenerationDate CashFlowItemGenerationDate 1
CashFlowItemGenerationTime CashFlowItemGenerationTime 1
CashFlowItemPaymentDate CashFlowItemPaymentDate 1
CashFlowItemPercentageRate CashFlowItemPercentageRate 1
CashFlowItemPositionCurrency CashFlowItemPositionCurrency 1
CashFlowItemPostingDirection CashFlowItemPostingDirection 1
CashFlowItemReferenceType CashFlowItemReferenceType 1
CashFlowItemSequenceNumber CashFlowItemSequenceNumber 1
CashFlowItemSettlementCurrency CashFlowItemSettlementCurrency 1
CashFlowItemSource CashFlowItemSource 1
CashFlowItemType CashFlowItemType 1
CashFlowItmNominalAmt CashFlowItmNominalAmt 1
CashFlowItmNominalAmtCrcy CashFlowItmNominalAmtCrcy 1
CshFlwItmAmtInPosCrcy CshFlwItmAmtInPosCrcy 1
CshFlwItmAmtInSettlmtCrcy CshFlwItmAmtInSettlmtCrcy 1
CshFlwItmClrgDteIsInclusive CshFlwItmClrgDteIsInclusive 1
CshFlwItmCreditPostgAcct CshFlwItmCreditPostgAcct 1
CshFlwItmDebitPostgAcct CshFlwItmDebitPostgAcct 1
CshFlwItmDirectionOfFlow CshFlwItmDirectionOfFlow 1
CshFlwItmSettlementDate CshFlwItmSettlementDate 1
DebitCrdtCtrlActyType DebitCrdtCtrlActyType 1
FinConditionConditionType FinConditionConditionType 1
LoanBusinessArea LoanBusinessArea 1
LoanCalcDateInclusiveCode LoanCalcDateInclusiveCode 1
LoanCshFlwItmActivityCat LoanCshFlwItmActivityCat 1
LoanCshFlwItmClrgDateInclvCode LoanCshFlwItmClrgDateInclvCode 1
LoanMainBrwrCustNmbr LoanMainBrwrCustNmbr 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.

-- Actual Document Item for Loan Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LOANCONTRACTLDOCITMDATA (
    COMPANYCODE,
    POSTEDDOCUMENTACTIVITYNUMBER,
    POSTEDDOCUMENTID,
    ACCOUNTINGDOCUMENT,
    ACCRDEFRLREFFLWCAT,
    BUSINESSPARTNER,
    CALCENDDTEISINCLUSIVE,
    CALCPERIODENDDATEISINCLUSIVE,
    CALCPERIODSTARTDATEISEXCLUSIVE,
    CALCULATIONPERIODENDDATE,
    CALCULATIONPERIODSTARTDATE,
    CASHFLOWITEMBILLDUEDATE,
    CASHFLOWITEMCALCDATE,
    CASHFLOWITEMCATEGORY,
    CASHFLOWITEMDUEDATE,
    CASHFLOWITEMEDITEDBY,
    CASHFLOWITEMEDITEDDATE,
    CASHFLOWITEMEDITEDSOURCE,
    CASHFLOWITEMEDITEDTIME,
    CASHFLOWITEMENTEREDBY,
    CASHFLOWITEMENTEREDDATE,
    CASHFLOWITEMENTEREDSOURCE,
    CASHFLOWITEMENTEREDTIME,
    CASHFLOWITEMGENERATIONDATE,
    CASHFLOWITEMGENERATIONTIME,
    CASHFLOWITEMPAYMENTDATE,
    CASHFLOWITEMPERCENTAGERATE,
    CASHFLOWITEMPOSITIONCURRENCY,
    CASHFLOWITEMPOSTINGDIRECTION,
    CASHFLOWITEMREFERENCETYPE,
    CASHFLOWITEMSEQUENCENUMBER,
    CASHFLOWITEMSETTLEMENTCURRENCY,
    CASHFLOWITEMSOURCE,
    CASHFLOWITEMTYPE,
    CASHFLOWITMNOMINALAMT,
    CASHFLOWITMNOMINALAMTCRCY,
    CSHFLWITMAMTINPOSCRCY,
    CSHFLWITMAMTINSETTLMTCRCY,
    CSHFLWITMCLRGDTEISINCLUSIVE,
    CSHFLWITMCREDITPOSTGACCT,
    CSHFLWITMDEBITPOSTGACCT,
    CSHFLWITMDIRECTIONOFFLOW,
    CSHFLWITMSETTLEMENTDATE,
    DEBITCRDTCTRLACTYTYPE,
    FINCONDITIONCONDITIONTYPE,
    LOANBUSINESSAREA,
    LOANCALCDATEINCLUSIVECODE,
    LOANCSHFLWITMACTIVITYCAT,
    LOANCSHFLWITMCLRGDATEINCLVCODE,
    LOANMAINBRWRCUSTNMBR,
    PRIMARY KEY (COMPANYCODE, POSTEDDOCUMENTACTIVITYNUMBER, POSTEDDOCUMENTID)
);

Learn More