I_BOPRBLSPYBLSITMTOFORMITEMC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA