P_PT_DOCITEMPARTNER

CDS View
30 Fields 2 CDS Views

View to select all partner and customer line item

P_PT_DOCITEMPARTNER is a CDS View in S/4HANA. View to select all partner and customer line item. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PT_DocItemCshDisc view from CONSUMPTION Cash Discount Items
P_PT_DocItemPartnerJoinWit view from CONSUMPTION Join Partner and WIT view

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
BalanceTransactionCurrency BalanceTransactionCurrency 1
CashDiscountAmount CashDiscountAmount 1
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 1
ClearingDate ClearingDate 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
CustomerVATRegistration CustomerVATRegistration 1
CustomerVATRegistrationCountry CustomerVATRegistrationCountry 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
ExchangeRate ExchangeRate 1
FinancialAccountType FinancialAccountType 1
IsSalesRelated IsSalesRelated 1
IsUsedInPaymentTransaction IsUsedInPaymentTransaction 1
OneTimeCustomer OneTimeCustomer 1
OneTimeVendor OneTimeVendor 1
PostingDate PostingDate 1
Supplier Supplier 1
SupplierVATRegistration SupplierVATRegistration 1
SupplierVATRegistrationCountry SupplierVATRegistrationCountry 1
TransactionCurrency TransactionCurrency 1
VATRegistration VATRegistration 1
VATRegistrationCountry VATRegistrationCountry 1
WithholdingTaxCode WithholdingTaxCode 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.

-- View to select all partner and customer line item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PT_DOCITEMPARTNER (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    BALANCETRANSACTIONCURRENCY,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTAMTINCOCODECRCY,
    CLEARINGDATE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    CUSTOMERVATREGISTRATION,
    CUSTOMERVATREGISTRATIONCOUNTRY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    EXCHANGERATE,
    FINANCIALACCOUNTTYPE,
    ISSALESRELATED,
    ISUSEDINPAYMENTTRANSACTION,
    ONETIMECUSTOMER,
    ONETIMEVENDOR,
    POSTINGDATE,
    SUPPLIER,
    SUPPLIERVATREGISTRATION,
    SUPPLIERVATREGISTRATIONCOUNTRY,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR)
);

Learn More