P_BOPRBLSPYBLSITEMFILTER

CDS View
33 Fields 2 CDS Views

P_BOPRBLSPYBLSITEMFILTER is a CDS View in S/4HANA. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BOPRblsPyblsItemToFormItemR view_entity inner COMPOSITE
P_BOPRblsPyblsMinItem view_entity from COMPOSITE

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY BOPForm BOPForm 2
KEY BOPRptgCntry BOPRptgCntry 2
KEY CompanyCode CompanyCode 2
KEY CompanyCodeCountry CompanyCodeCountry 2
KEY FiscalYear FiscalYear 2
AccountingDocumentType AccountingDocumentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
ChartOfAccounts ChartOfAccounts 1
ClearingDate ClearingDate 1
ClearingJournalEntry ClearingJournalEntry 1
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
CustomerCountry CustomerCountry 1
CustomerIsOneTimeAccount CustomerIsOneTimeAccount 1
DebitCreditCode DebitCreditCode 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
IsEUTriangularDeal IsEUTriangularDeal 1
OffsettingAccount OffsettingAccount 1
OffsettingAccountType OffsettingAccountType 1
OneTimeAccountBPCountry OneTimeAccountBPCountry 1
PartnerCompany PartnerCompany 1
PostingDate PostingDate 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
SupplierCountry SupplierCountry 1
SupplierIsOneTimeAccount SupplierIsOneTimeAccount 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BOPRBLSPYBLSITEMFILTER (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    BOPFORM,
    BOPRPTGCNTRY,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CUSTOMER,
    CUSTOMERCOUNTRY,
    CUSTOMERISONETIMEACCOUNT,
    DEBITCREDITCODE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    ISEUTRIANGULARDEAL,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    ONETIMEACCOUNTBPCOUNTRY,
    PARTNERCOMPANY,
    POSTINGDATE,
    SPECIALGLCODE,
    SUPPLIER,
    SUPPLIERCOUNTRY,
    SUPPLIERISONETIMEACCOUNT,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BOPFORM, BOPRPTGCNTRY, COMPANYCODE, COMPANYCODECOUNTRY, FISCALYEAR)
);

Learn More