P_PT_BOPCUSTSUPLRBALANCE

CDS View
40 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PT_BOPCustSuplrCountry view_entity from COMPOSITE

Fields (40)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentType AccountingDocumentType 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessPartner BusinessPartner 1
ClearingAccountingDocument ClearingAccountingDocument 1
ClearingDate ClearingDate 1
ClearingDocFiscalYear ClearingDocFiscalYear 1
ClearingJournalEntry ClearingJournalEntry 1
CurrencyISOCode CurrencyISOCode 1
Customer Customer 1
CustomerCountry CustomerCountry 1
CustomerVATRegistration CustomerVATRegistration 1
CustomerVATRegistrationCountry CustomerVATRegistrationCountry 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
FinancialAccountType FinancialAccountType 1
FinancialTransactionType FinancialTransactionType 1
GLAccount GLAccount 1
OneTimeCountry OneTimeCountry 1
OneTimeCustomer OneTimeCustomer 1
OneTimeVendor OneTimeVendor 1
Postingdate Postingdate 1
PostingKey PostingKey 1
PT_BOPAccountType PT_BOPAccountType 1
PT_BOPAcctBalCreditClsfctn PT_BOPAcctBalCreditClsfctn 1
PT_BOPAcctBalDebitClsfctn PT_BOPAcctBalDebitClsfctn 1
PT_BOPValueType PT_BOPValueType 1
ReviewComment ReviewComment 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
SupplierCountry SupplierCountry 1
SupplierVATRegistration SupplierVATRegistration 1
SupplierVATRegistrationCountry SupplierVATRegistrationCountry 1
TransactionCurrency TransactionCurrency 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_BOPCUSTSUPLRBALANCE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CURRENCYISOCODE,
    CUSTOMER,
    CUSTOMERCOUNTRY,
    CUSTOMERVATREGISTRATION,
    CUSTOMERVATREGISTRATIONCOUNTRY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    GLACCOUNT,
    ONETIMECOUNTRY,
    ONETIMECUSTOMER,
    ONETIMEVENDOR,
    POSTINGDATE,
    POSTINGKEY,
    PT_BOPACCOUNTTYPE,
    PT_BOPACCTBALCREDITCLSFCTN,
    PT_BOPACCTBALDEBITCLSFCTN,
    PT_BOPVALUETYPE,
    REVIEWCOMMENT,
    SPECIALGLCODE,
    SUPPLIER,
    SUPPLIERCOUNTRY,
    SUPPLIERVATREGISTRATION,
    SUPPLIERVATREGISTRATIONCOUNTRY,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR)
);

Learn More