P_PT_BOPACCOUNTINGDOCUMENTITEM

CDS View
29 Fields 4 CDS Views

P_PT_BOPACCOUNTINGDOCUMENTITEM is a CDS View in S/4HANA. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_PT_BOPAcctgDocItmMinimum view_entity from COMPOSITE
P_PT_BOPDownPaymentItem view_entity from COMPOSITE
P_PT_BOPInvoiceDocumentItem view_entity inner COMPOSITE
P_PT_BOPMiscellaneousDocItem view_entity inner COMPOSITE

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
AccountingDocumentType AccountingDocumentType 2
BankCountryIsoCode BankCountryIsoCode 2
ClearingItem ClearingItem 1
ClearingJournalEntry ClearingJournalEntry 1
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
Customer Customer 2
CustomerCountry CustomerCountry 1
DocumentDate DocumentDate 2
FinancialAccountType FinancialAccountType 1
FollowOnDocumentType FollowOnDocumentType 2
GLAccount GLAccount 2
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
IsSalesRelated IsSalesRelated 2
OneTimeCountry OneTimeCountry 1
OneTimeCustomer OneTimeCustomer 1
OneTimeVendor OneTimeVendor 1
Postingdate Postingdate 2
PT_BOPAccountType PT_BOPAccountType 2
PT_BOPBankNumber PT_BOPBankNumber 2
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
StateCentralBankPaytRsnDesc StateCentralBankPaytRsnDesc 1
Supplier Supplier 2
SupplierCountry SupplierCountry 1
VATRegistration VATRegistration 1
VATRegistrationCountry VATRegistrationCountry 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_PT_BOPACCOUNTINGDOCUMENTITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    BANKCOUNTRYISOCODE,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    CUSTOMER,
    CUSTOMERCOUNTRY,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FOLLOWONDOCUMENTTYPE,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISSALESRELATED,
    ONETIMECOUNTRY,
    ONETIMECUSTOMER,
    ONETIMEVENDOR,
    POSTINGDATE,
    PT_BOPACCOUNTTYPE,
    PT_BOPBANKNUMBER,
    STATECENTRALBANKPAYMENTREASON,
    STATECENTRALBANKPAYTRSNDESC,
    SUPPLIER,
    SUPPLIERCOUNTRY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More