P_BOPREVNCOSTITEMTOFORMITEM00

CDS View
40 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BOPRevnCostItemToFormItem10 view_entity from COMPOSITE
P_BOPRevnCostItemToFormItem20 view_entity from COMPOSITE

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY BOPForm BOPForm 2
KEY BOPRptgCntry BOPRptgCntry 2
KEY CompanyCode CompanyCode 2
KEY CompanyCodeCountry CompanyCodeCountry 2
KEY FiscalYear FiscalYear 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SourceLedger SourceLedger 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
BOPCustomerCountry BOPCustomerCountry 2
BOPCustomerIsOneTimeAccount BOPCustomerIsOneTimeAccount 2
BOPOneTimeAccountBPCountry BOPOneTimeAccountBPCountry 2
BOPSupplierCountry BOPSupplierCountry 2
BOPSupplierIsOneTimeAccount BOPSupplierIsOneTimeAccount 2
ChartOfAccounts ChartOfAccounts 2
ClearingDate ClearingDate 2
ClearingJournalEntry ClearingJournalEntry 2
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 2
CompanyCodeCurrency CompanyCodeCurrency 2
Customer Customer 2
DebitCreditCode DebitCreditCode 2
FinancialAccountType FinancialAccountType 2
GLAccount GLAccount 2
ImportExportFinancialAccType ImportExportFinancialAccType 2
IsEUTriangularDeal IsEUTriangularDeal 2
OffsettingAccount OffsettingAccount 2
OffsettingAccountType OffsettingAccountType 2
PartnerCompany PartnerCompany 2
PostingDate PostingDate 2
SpecialGLCode SpecialGLCode 2
Supplier Supplier 2
TaxCode TaxCode 2
TransactionCurrency TransactionCurrency 2

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_BOPREVNCOSTITEMTOFORMITEM00 (
    ACCOUNTINGDOCUMENT,
    BOPFORM,
    BOPRPTGCNTRY,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BOPCUSTOMERCOUNTRY,
    BOPCUSTOMERISONETIMEACCOUNT,
    BOPONETIMEACCOUNTBPCOUNTRY,
    BOPSUPPLIERCOUNTRY,
    BOPSUPPLIERISONETIMEACCOUNT,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DEBITCREDITCODE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    IMPORTEXPORTFINANCIALACCTYPE,
    ISEUTRIANGULARDEAL,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    PARTNERCOMPANY,
    POSTINGDATE,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCODE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BOPFORM, BOPRPTGCNTRY, COMPANYCODE, COMPANYCODECOUNTRY, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More