I_RU_FINANCIALCONTRACTTP

CDS View
24 Fields 1 CDS Views

Contract in Accounting : Transactional layer

I_RU_FINANCIALCONTRACTTP is a CDS View in S/4HANA. Contract in Accounting : Transactional layer. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_RU_FinancialContractTP view_entity projection CONSUMPTION Accounting Contract Consumption View

Fields (24)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerContract BusinessPartnerContract 1
KEY CompanyCode CompanyCode 1
_ContractCategory _ContractCategory 1
_Customer _Customer 1
_CustomerCompany _CustomerCompany 1
_Supplier _Supplier 1
_SupplierCompany _SupplierCompany 1
BusinessPartnerContractExt BusinessPartnerContractExt 1
Comments Comments 1
ContractAccountingNumber ContractAccountingNumber 1
ContractCategory ContractCategory 1
ContractCurrency ContractCurrency 1
ContractEndDate ContractEndDate 1
ContractServiceSite ContractServiceSite 1
ContractSignedDate ContractSignedDate 1
ContractStartDate ContractStartDate 1
ContractSubject ContractSubject 1
ContractTotalAmount ContractTotalAmount 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
Customer Customer 1
LastChangeByUserName LastChangeByUserName 1
LastChangeDateTime LastChangeDateTime 1
Supplier Supplier 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.

-- Contract in Accounting : Transactional layer
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RU_FINANCIALCONTRACTTP (
    BUSINESSPARTNERCONTRACT,
    COMPANYCODE,
    _CONTRACTCATEGORY,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    BUSINESSPARTNERCONTRACTEXT,
    COMMENTS,
    CONTRACTACCOUNTINGNUMBER,
    CONTRACTCATEGORY,
    CONTRACTCURRENCY,
    CONTRACTENDDATE,
    CONTRACTSERVICESITE,
    CONTRACTSIGNEDDATE,
    CONTRACTSTARTDATE,
    CONTRACTSUBJECT,
    CONTRACTTOTALAMOUNT,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CUSTOMER,
    LASTCHANGEBYUSERNAME,
    LASTCHANGEDATETIME,
    SUPPLIER,
    PRIMARY KEY (BUSINESSPARTNERCONTRACT, COMPANYCODE)
);

Learn More