_TMPL

86 Fields

_TMPL is an SAP database table in S/4HANA. It contains 86 fields.

Fields (86)

KeyField CDS FieldsUsed in Views
KEY RecrrgSuplrInvcTmplUUID RecrrgSuplrInvcTmplUUID 1
_BPBankAlias _BPBankAlias 1
_ForeignCrcyAmtCnvrsnRuleText _ForeignCrcyAmtCnvrsnRuleText 1
_PaymentTerms _PaymentTerms 1
_PostStatus _PostStatus 1
_RecurrenceEndTypeText _RecurrenceEndTypeText 1
_RecurrenceTypeText _RecurrenceTypeText 1
AccountingDocumentHeaderText AccountingDocumentHeaderText 1
AccountingDocumentType AccountingDocumentType 1
ActiveCountry ActiveCountry 1
AssignmentReference AssignmentReference 1
BusinessArea BusinessArea 1
BusinessPlace BusinessPlace 1
BusinessSectionCode BusinessSectionCode 1
CalendarDay CalendarDay 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 3
CompanyCodeCountry CompanyCodeCountry 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DocumentItemText DocumentItemText 1
DocumentReferenceID DocumentReferenceID 1
EstdCostCostgRunRcrrcDate EstdCostCostgRunRcrrcDate 1
ExchangeRate ExchangeRate 1
FirstOccurrenceDate FirstOccurrenceDate 1
FixedCashDiscount FixedCashDiscount 1
ForeignCrcyAmtCnvrsnRule ForeignCrcyAmtCnvrsnRule 1
GLAccount GLAccount 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IBAN IBAN 1
IN_GSTPartner IN_GSTPartner 1
IN_GSTPlaceOfSupply IN_GSTPlaceOfSupply 1
IN_InvoiceReferenceNumber IN_InvoiceReferenceNumber 1
InvoicingParty InvoicingParty 1
IsEUTriangularDeal IsEUTriangularDeal 1
Language Language 1
LastOccurrenceDate LastOccurrenceDate 1
LocalCurrency LocalCurrency 1
ManualCashDiscount ManualCashDiscount 1
NetPaymentDays NetPaymentDays 1
NextOccurrenceAmountInTC NextOccurrenceAmountInTC 1
NextOccurrenceDate NextOccurrenceDate 1
NumberOfNotPostedInvoices NumberOfNotPostedInvoices 1
NumberOfOccurrences NumberOfOccurrences 1
NumberOfPostedInvoices NumberOfPostedInvoices 2
OneTimeAcctCntrySpecificRef1 OneTimeAcctCntrySpecificRef1 1
PaymentMethod PaymentMethod 1
PaymentMethodSupplement PaymentMethodSupplement 1
PaymentReference PaymentReference 1
PaymentTerms PaymentTerms 1
PaytSlipWthRefCheckDigit PaytSlipWthRefCheckDigit 1
PaytSlipWthRefReference PaytSlipWthRefReference 1
PaytSlipWthRefSubscriber PaytSlipWthRefSubscriber 1
QuickResponseIBAN QuickResponseIBAN 1
RecrrgSuplrInvcIsSrvcInvoice RecrrgSuplrInvcIsSrvcInvoice 1
RecrrgSuplrInvcTemplateStatus RecrrgSuplrInvcTemplateStatus 1
RecrrgSupplierInvoiceTemplate RecrrgSupplierInvoiceTemplate 1
RecurrenceEndType RecurrenceEndType 1
RecurrenceFrequency RecurrenceFrequency 1
RecurrenceType RecurrenceType 1
ReferenceAccountForIBAN ReferenceAccountForIBAN 1
REFrequencyStart REFrequencyStart 1
REStartFrequencyWeek REStartFrequencyWeek 1
SettlmtCoCodeTaxCountry SettlmtCoCodeTaxCountry 2
StartDate StartDate 1
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
SuplrInvcPaymentBlockingReason SuplrInvcPaymentBlockingReason 1
SupplierBankType SupplierBankType 1
SupplierVATRegistration SupplierVATRegistration 1
SupplyingCountry SupplyingCountry 1
SWIFTCode SWIFTCode 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCode TaxCode 1
TaxCountry TaxCountry 1
TaxDeterminationDate TaxDeterminationDate 1
TaxJurisdictionByProvider TaxJurisdictionByProvider 1
TotalAmountInLocalCurrency TotalAmountInLocalCurrency 1
TotalAmountInTransactionCrcy TotalAmountInTransactionCrcy 1
TransactionCurrency TransactionCurrency 4
UserName UserName 1
WeekDay WeekDay 1
WithholdingTaxIsEnabled WithholdingTaxIsEnabled 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 _TMPL (
    RECRRGSUPLRINVCTMPLUUID,
    _BPBANKALIAS,
    _FOREIGNCRCYAMTCNVRSNRULETEXT,
    _PAYMENTTERMS,
    _POSTSTATUS,
    _RECURRENCEENDTYPETEXT,
    _RECURRENCETYPETEXT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIVECOUNTRY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    BUSINESSPLACE,
    BUSINESSSECTIONCODE,
    CALENDARDAY,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    ESTDCOSTCOSTGRUNRCRRCDATE,
    EXCHANGERATE,
    FIRSTOCCURRENCEDATE,
    FIXEDCASHDISCOUNT,
    FOREIGNCRCYAMTCNVRSNRULE,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    IBAN,
    IN_GSTPARTNER,
    IN_GSTPLACEOFSUPPLY,
    IN_INVOICEREFERENCENUMBER,
    INVOICINGPARTY,
    ISEUTRIANGULARDEAL,
    LANGUAGE,
    LASTOCCURRENCEDATE,
    LOCALCURRENCY,
    MANUALCASHDISCOUNT,
    NETPAYMENTDAYS,
    NEXTOCCURRENCEAMOUNTINTC,
    NEXTOCCURRENCEDATE,
    NUMBEROFNOTPOSTEDINVOICES,
    NUMBEROFOCCURRENCES,
    NUMBEROFPOSTEDINVOICES,
    ONETIMEACCTCNTRYSPECIFICREF1,
    PAYMENTMETHOD,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREFERENCE,
    PAYMENTTERMS,
    PAYTSLIPWTHREFCHECKDIGIT,
    PAYTSLIPWTHREFREFERENCE,
    PAYTSLIPWTHREFSUBSCRIBER,
    QUICKRESPONSEIBAN,
    RECRRGSUPLRINVCISSRVCINVOICE,
    RECRRGSUPLRINVCTEMPLATESTATUS,
    RECRRGSUPPLIERINVOICETEMPLATE,
    RECURRENCEENDTYPE,
    RECURRENCEFREQUENCY,
    RECURRENCETYPE,
    REFERENCEACCOUNTFORIBAN,
    REFREQUENCYSTART,
    RESTARTFREQUENCYWEEK,
    SETTLMTCOCODETAXCOUNTRY,
    STARTDATE,
    STATECENTRALBANKPAYMENTREASON,
    SUPLRINVCPAYMENTBLOCKINGREASON,
    SUPPLIERBANKTYPE,
    SUPPLIERVATREGISTRATION,
    SUPPLYINGCOUNTRY,
    SWIFTCODE,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXJURISDICTIONBYPROVIDER,
    TOTALAMOUNTINLOCALCURRENCY,
    TOTALAMOUNTINTRANSACTIONCRCY,
    TRANSACTIONCURRENCY,
    USERNAME,
    WEEKDAY,
    WITHHOLDINGTAXISENABLED,
    PRIMARY KEY (RECRRGSUPLRINVCTMPLUUID)
);

Learn More