FICA_ITM_BP

34 Fields

FICA_ITM_BP is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
KEY BOPForm BOPForm 4
KEY BOPRptgCntry BOPRptgCntry 4
KEY CABPItemNumber CABPItemNumber 7
KEY CADocumentNumber CADocumentNumber 4
KEY CARepetitionItemNumber CARepetitionItemNumber 7
KEY CASubItemNumber CASubItemNumber 7
KEY CompanyCode CompanyCode 9
AlternativeGLAccount AlternativeGLAccount 3
BPCountry BOPPartnerCntry 4
BusinessPartner BusinessPartner 8
BusinessPartnerName BusinessPartnerName 3
CAAmountInLocalCurrency AmountInCompanyCodeCurrency,CAAmountInLocalCurrency,PreviousAmountInLocalCurrency 6
CAAmountInTransactionCurrency AmountInTransactionCurrency,CAAmountInTransactionCurrency 4
CAClearingDate CAClearingDate,ClearingDate 4
CAClearingDocumentNumber CAClearingAccountingDocument,CAClearingDocumentNumber 8
CAClearingStatus CAClearingStatus 2
CADocumentType CADocumentType 2
CAExchangeRate CAExchangeRate 2
CAMainTransaction CAMainTransaction 2
CAPostingDate CAPostingDate 4
CAReconciliationAccount GLAccount 3
CAReferenceDocument CAReferenceDocument 2
CAReversalDocumentNumber CAReversalDocumentNumber 1
CASubTransaction CASubTransaction 2
CASubTransactionName CASubTransactionName 2
ChartOfAccounts ChartOfAccounts 7
CompanyCodeCountry CompanyCodeCountry 4
CompanyCodeCurrency CompanyCodeCurrency 10
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy,CreditPrevPeriodYTDAmtInCCCrcy 2
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy,DebitPrevPeriodYTDAmtInCCCrcy 2
GLAccount GLAccount 5
PartnerCompany PartnerCompany 5
TaxCode TaxCode 6
TransactionCurrency TransactionCurrency 6

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_ITM_BP (
    BOPFORM,
    BOPRPTGCNTRY,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    COMPANYCODE,
    ALTERNATIVEGLACCOUNT,
    BPCOUNTRY,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CACLEARINGDATE,
    CACLEARINGDOCUMENTNUMBER,
    CACLEARINGSTATUS,
    CADOCUMENTTYPE,
    CAEXCHANGERATE,
    CAMAINTRANSACTION,
    CAPOSTINGDATE,
    CARECONCILIATIONACCOUNT,
    CAREFERENCEDOCUMENT,
    CAREVERSALDOCUMENTNUMBER,
    CASUBTRANSACTION,
    CASUBTRANSACTIONNAME,
    CHARTOFACCOUNTS,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINCOCODECRCY,
    GLACCOUNT,
    PARTNERCOMPANY,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BOPFORM, BOPRPTGCNTRY, CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, COMPANYCODE)
);

Learn More