I_BOPRBLSPYBLSITMTOFORMITEMC

CDS View

Rbls Pybls Item to BOP Form Item - Cube

I_BOPRBLSPYBLSITMTOFORMITEMC is a CDS View in S/4HANA. Rbls Pybls Item to BOP Form Item - Cube. It contains 49 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_BE_BoPS03CCRCube view from CONSUMPTION BOP Reporting Belgium - S03CCR Format
C_BOPRblsPyblsItmToFormItemQ view from CONSUMPTION Rbls Pybls Item to BOP Form Item - Query
P_FR_BOPECO10 view from CONSUMPTION

Fields (49)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY BOPForm BOPForm 1
KEY BOPFormItem BOPFormItem 1
KEY BOPPartnerCntry BOPPartnerCntry 1
KEY BOPRptgCntry BOPRptgCntry 1
KEY CABPItemNumber CABPItemNumber 1
KEY CADocument CADocument 1
KEY CAItemIsDoubtful CAItemIsDoubtful 3
KEY CAItemIsOffsetting CAItemIsOffsetting 3
KEY CARepetitionItemNumber CARepetitionItemNumber 3
KEY CASubItemNumber CASubItemNumber 1
KEY CompanyCode CompanyCode 1
KEY CompanyCodeCountry CompanyCodeCountry 1
KEY FiscalYear FiscalYear 1
KEY PostingDate PostingDate 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
AccountingDocumentType AccountingDocumentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessPartner BusinessPartner 1
CAClearingAccountingDocument CAClearingAccountingDocument 1
CADocumentType CADocumentType 1
CAReconciliationKey CAReconciliationKey 1
ChartOfAccounts ChartOfAccounts 1
ClearingDate ClearingDate 1
ClearingJournalEntry ClearingJournalEntry 1
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
Customer Customer 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
DebitCreditCode DebitCreditCode 1
ExportAmountInCompanyCodeCrcy ExportAmountInCompanyCodeCrcy 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
ImportAmountInCompanyCodeCrcy ImportAmountInCompanyCodeCrcy 1
IsEUTriangularDeal IsEUTriangularDeal 1
OffsettingAccount OffsettingAccount 1
OffsettingAccountType OffsettingAccountType 1
PartnerCompany PartnerCompany 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
TaxCode TaxCode 1
TransactionCurrency TransactionCurrency 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.

-- Rbls Pybls Item to BOP Form Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BOPRBLSPYBLSITMTOFORMITEMC (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    BOPFORM,
    BOPFORMITEM,
    BOPPARTNERCNTRY,
    BOPRPTGCNTRY,
    CABPITEMNUMBER,
    CADOCUMENT,
    CAITEMISDOUBTFUL,
    CAITEMISOFFSETTING,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    FISCALYEAR,
    POSTINGDATE,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    CACLEARINGACCOUNTINGDOCUMENT,
    CADOCUMENTTYPE,
    CARECONCILIATIONKEY,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    EXPORTAMOUNTINCOMPANYCODECRCY,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    IMPORTAMOUNTINCOMPANYCODECRCY,
    ISEUTRIANGULARDEAL,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    PARTNERCOMPANY,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BOPFORM, BOPFORMITEM, BOPPARTNERCNTRY, BOPRPTGCNTRY, CABPITEMNUMBER, CADOCUMENT, CAITEMISDOUBTFUL, CAITEMISOFFSETTING, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, COMPANYCODE, COMPANYCODECOUNTRY, FISCALYEAR, POSTINGDATE, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);