P_BOPRBLSPYBLSITEMBASE

CDS View
30 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BOPRblsPyblsItemFilter view_entity from COMPOSITE
P_BOPRblsPyblsMinItemEnhcd view_entity inner COMPOSITE

Fields (30)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
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 BOPCustomerCountry,CustomerCountry 2
CustomerIsOneTimeAccount BOPCustomerIsOneTimeAccount,CustomerIsOneTimeAccount 2
DebitCreditCode DebitCreditCode 1
FinancialAccountType FinancialAccountType,ImportExportFinancialAccType 2
GLAccount GLAccount 1
IsEUTriangularDeal IsEUTriangularDeal 2
OffsettingAccount OffsettingAccount 1
OffsettingAccountType OffsettingAccountType 1
OneTimeAccountBPCountry BOPOneTimeAccountBPCountry,OneTimeAccountBPCountry 2
PartnerCompany PartnerCompany 1
PostingDate PostingDate 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
SupplierCountry BOPSupplierCountry,SupplierCountry 2
SupplierIsOneTimeAccount BOPSupplierIsOneTimeAccount,SupplierIsOneTimeAccount 2
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_BOPRBLSPYBLSITEMBASE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    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, COMPANYCODE, FISCALYEAR)
);

Learn More