FACILITY

24 Fields

FACILITY is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 5
KEY FinancialTransaction FinancialTransaction 6
KEY KeyDate KeyDate 3
_TransactionCurrency _TransactionCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
Counterparty Counterparty 1
CreditLineCurrency CreditLineCurrency 2
CreditLineReportingPeriod CreditLineReportingPeriod 1
FcltyTermEndExceededIsAllowed FcltyTermEndExceededIsAllowed 1
FinancialInstrTransactionType FinancialInstrTransactionType 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FinTransProductGroup FinTransProductGroup 1
LimitDate FacilityDate 1
MinLimitDateAfterChangeDate MinLimitDateAfterChangeDate 1
Portfolio Portfolio 1
PositionAmount AmountInTransactionCurrency 1
ReferenceObject ReferenceObject 2
RelatObject RelatObject 4
SecurityAccount SecurityAccount 1
StartDate StartDate 1
SyndicatedCounterparty SyndicatedCounterparty 3
TermEndDate FacilityDate,TermEndDate 3
TotalAmountInTransactionCrcy TotalAmountInTransactionCrcy 1
TransactionCurrency TransactionCurrency 4

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FACILITY (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    KEYDATE,
    _TRANSACTIONCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    COUNTERPARTY,
    CREDITLINECURRENCY,
    CREDITLINEREPORTINGPERIOD,
    FCLTYTERMENDEXCEEDEDISALLOWED,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINTRANSPRODUCTGROUP,
    LIMITDATE,
    MINLIMITDATEAFTERCHANGEDATE,
    PORTFOLIO,
    POSITIONAMOUNT,
    REFERENCEOBJECT,
    RELATOBJECT,
    SECURITYACCOUNT,
    STARTDATE,
    SYNDICATEDCOUNTERPARTY,
    TERMENDDATE,
    TOTALAMOUNTINTRANSACTIONCRCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION, KEYDATE)
);

Learn More