FICA_ITEM

44 Fields

FICA_ITEM is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY BusinessPartner BusinessPartner,CustomerSupplierAccount,ReferenceBusinessPartner 1
KEY CADocumentNumber CADocumentNumber 1
KEY CAGLItemNumber CAGLItemNumber 1
KEY CATaxReportingDetailingAssgmt CATaxReportingDetailingAssgmt 1
KEY CATaxReportingItemSequenceNmbr CATaxReportingItemSequenceNmbr 1
KEY FiscalYear FiscalYear 1
KEY TaxCode TaxCode 1
KEY TaxItem AccountingDocumentItem,TaxItem 1
KEY TransactionTypeDetermination TransactionTypeDetermination 1
_I_Customer _I_Customer 1
_I_KR_VAT_REP_CONF _I_KR_VAT_REP_CONF 1
_I_Supplier _I_Supplier 1
AccountingDocumentType AccountingDocumentType 1
BusinessPlace BusinessPlace 1
BusinessType BusinessType 1
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 1
ExporterUUID ExporterUUID 1
FinancialAccountType FinancialAccountType 1
IndustryType IndustryType 1
InvoiceDate InvoiceDate 1
IsReversal IsReversal 1
IsReversed IsReversed 1
LoadingDate LoadingDate 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
ReportingDate ReportingDate 1
ReversalReason ReversalReason 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxInvcNmbrValidityStartDate TaxInvcNmbrValidityStartDate 1
TaxInvoiceApprovalNmbr TaxInvoiceApprovalNmbr 1
TaxInvoiceRepresentativeName TaxInvoiceRepresentativeName 1
TaxItemGroup TaxItemGroup 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxType TaxType 1
VATRegistration VATRegistration 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 FICA_ITEM (
    ACCOUNTINGDOCUMENT,
    BUSINESSPARTNER,
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    CATAXREPORTINGDETAILINGASSGMT,
    CATAXREPORTINGITEMSEQUENCENMBR,
    FISCALYEAR,
    TAXCODE,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _I_CUSTOMER,
    _I_KR_VAT_REP_CONF,
    _I_SUPPLIER,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSPLACE,
    BUSINESSTYPE,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXPORTERUUID,
    FINANCIALACCOUNTTYPE,
    INDUSTRYTYPE,
    INVOICEDATE,
    ISREVERSAL,
    ISREVERSED,
    LOADINGDATE,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGDATE,
    REVERSALREASON,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXINVCNMBRVALIDITYSTARTDATE,
    TAXINVOICEAPPROVALNMBR,
    TAXINVOICEREPRESENTATIVENAME,
    TAXITEMGROUP,
    TAXRATEVALIDITYSTARTDATE,
    TAXTYPE,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BUSINESSPARTNER, CADOCUMENTNUMBER, CAGLITEMNUMBER, CATAXREPORTINGDETAILINGASSGMT, CATAXREPORTINGITEMSEQUENCENMBR, FISCALYEAR, TAXCODE, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);

Learn More