BASE

32 Fields

BASE is an SAP database table in S/4HANA. It contains 32 fields.

Fields (32)

KeyField CDS FieldsUsed in Views
KEY BudgetCostCenterHierarchyId BudgetCostCenterHierarchyId 1
KEY NodeName NodeName 1
KEY SitnBaseTemplateID SitnBaseTemplateID 2
_Dir _Dir 1
AmountInDisplayCurrency AmountInDisplayCurrency 1
AmountInPaymentCurrency AmountInPaymentCurrency 2
Bank Bank 2
BankCountryKey BankCountryKey 3
BankKey Bank 1
BankName BankName 1
CompanyCode CompanyCode 3
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeName CompanyCodeName 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
DisplayCurrency DisplayCurrency 2
GeneralStatus GeneralStatus 3
GeneralStatusName GeneralStatusName 1
IsUrgentPayment IsUrgentPayment 3
NumberOfPaymentBatches NumberOfPaymentBatches 2
NumberOfPayments NumberOfPayments 2
NumberOfProcessingDays NumberOfProcessingDays 2
PayeeBankCountry PayeeBankCountry 3
PayeeBankInternalID PayeeBankInternalID 3
PaymentBatch PaymentBatch 3
PaymentBatchRule PaymentBatchRule 3
PaymentCurrency PaymentCurrency 3
PaymentMethod PaymentMethod 3
PaymentProcessingStatus PaymentProcessingStatus 2
ProcessingDays ProcessingDays 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BASE (
    BUDGETCOSTCENTERHIERARCHYID,
    NODENAME,
    SITNBASETEMPLATEID,
    _DIR,
    AMOUNTINDISPLAYCURRENCY,
    AMOUNTINPAYMENTCURRENCY,
    BANK,
    BANKCOUNTRYKEY,
    BANKKEY,
    BANKNAME,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    COSTCENTER,
    DISPLAYCURRENCY,
    GENERALSTATUS,
    GENERALSTATUSNAME,
    ISURGENTPAYMENT,
    NUMBEROFPAYMENTBATCHES,
    NUMBEROFPAYMENTS,
    NUMBEROFPROCESSINGDAYS,
    PAYEEBANKCOUNTRY,
    PAYEEBANKINTERNALID,
    PAYMENTBATCH,
    PAYMENTBATCHRULE,
    PAYMENTCURRENCY,
    PAYMENTMETHOD,
    PAYMENTPROCESSINGSTATUS,
    PROCESSINGDAYS,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BUDGETCOSTCENTERHIERARCHYID, NODENAME, SITNBASETEMPLATEID)
);

Learn More