P_FICATOBOPFORMITM12

CDS View

P_FICATOBOPFORMITM12 is a CDS View in S/4HANA. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FicaToBOPFormItm13 view from COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BOPForm BOPForm 1
KEY BOPRptgCntry BOPRptgCntry 1
KEY CABPItemNumber CABPItemNumber 1
KEY CADocumentNumber CADocumentNumber 1
KEY CAGLItemNumber CAGLItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
BOPPartnerCntry BOPPartnerCntry 1
CAPostingDate CAPostingDate 1
CAReconciliationKey CAReconciliationKey 1
CAReversedDocumentNumber CAReversedDocumentNumber 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCountry CompanyCodeCountry 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
HasUniqueClrgDate HasUniqueClrgDate 1
TaxCode TaxCode 1
UniqueAcctgDocClrgDate UniqueAcctgDocClrgDate 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 P_FICATOBOPFORMITM12 (
    BOPFORM,
    BOPRPTGCNTRY,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    CASUBITEMNUMBER,
    COMPANYCODE,
    FISCALYEAR,
    BOPPARTNERCNTRY,
    CAPOSTINGDATE,
    CARECONCILIATIONKEY,
    CAREVERSEDDOCUMENTNUMBER,
    CHARTOFACCOUNTS,
    COMPANYCODECOUNTRY,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    HASUNIQUECLRGDATE,
    TAXCODE,
    UNIQUEACCTGDOCCLRGDATE,
    PRIMARY KEY (BOPFORM, BOPRPTGCNTRY, CABPITEMNUMBER, CADOCUMENTNUMBER, CAGLITEMNUMBER, CASUBITEMNUMBER, COMPANYCODE, FISCALYEAR)
);