PURCHASELEDGERENTRY

34 Fields

PURCHASELEDGERENTRY is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
CL_NonRecoverableVatCode CL_NonRecoverableVatCode 1
CL_PurchaseType CL_PurchaseType 1
CL_SIIDocFromPurchaseInvoice CL_SIIDocFromPurchaseInvoice 1
CL_SIIEDocAcknowledgedDate CL_SIIEDocAcknowledgedDate 1
CL_SIIEDocFolioNumber CL_SIIEDocFolioNumber 1
CL_SIIEDocReceivedDate CL_SIIEDocReceivedDate 1
CL_SIIElectronicDocumentType CL_SIIElectronicDocumentType 1
DocumentDate DocumentDate 1
ElectronicDocPostingDate ElectronicDocPostingDate 1
ReportingCurrency ReportingCurrency 1
ReportingDate ReportingDate 1
Supplier Supplier 1
SupplierName SupplierName 1
TaxBox01AmtInReportingCurrency TaxBox01AmtInReportingCurrency 1
TaxBox02AmtInReportingCurrency TaxBox02AmtInReportingCurrency 1
TaxBox03AmtInReportingCurrency TaxBox03AmtInReportingCurrency 1
TaxBox04AmtInReportingCurrency TaxBox04AmtInReportingCurrency 1
TaxBox05AmtInReportingCurrency TaxBox05AmtInReportingCurrency 1
TaxBox06AmtInReportingCurrency TaxBox06AmtInReportingCurrency 1
TaxBox07AmtInReportingCurrency TaxBox07AmtInReportingCurrency 1
TaxBox08AmtInReportingCurrency TaxBox08AmtInReportingCurrency 1
TaxBox09AmtInReportingCurrency TaxBox09AmtInReportingCurrency 1
TaxBox10AmtInReportingCurrency TaxBox10AmtInReportingCurrency 1
TaxBox11AmtInReportingCurrency TaxBox11AmtInReportingCurrency 1
TaxBox12AmtInReportingCurrency TaxBox12AmtInReportingCurrency 1
TaxNumber1 TaxNumber1 1
TotalAmountInDisplayCrcy TotalAmountInDisplayCrcy 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 PURCHASELEDGERENTRY (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    CL_NONRECOVERABLEVATCODE,
    CL_PURCHASETYPE,
    CL_SIIDOCFROMPURCHASEINVOICE,
    CL_SIIEDOCACKNOWLEDGEDDATE,
    CL_SIIEDOCFOLIONUMBER,
    CL_SIIEDOCRECEIVEDDATE,
    CL_SIIELECTRONICDOCUMENTTYPE,
    DOCUMENTDATE,
    ELECTRONICDOCPOSTINGDATE,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    SUPPLIER,
    SUPPLIERNAME,
    TAXBOX01AMTINREPORTINGCURRENCY,
    TAXBOX02AMTINREPORTINGCURRENCY,
    TAXBOX03AMTINREPORTINGCURRENCY,
    TAXBOX04AMTINREPORTINGCURRENCY,
    TAXBOX05AMTINREPORTINGCURRENCY,
    TAXBOX06AMTINREPORTINGCURRENCY,
    TAXBOX07AMTINREPORTINGCURRENCY,
    TAXBOX08AMTINREPORTINGCURRENCY,
    TAXBOX09AMTINREPORTINGCURRENCY,
    TAXBOX10AMTINREPORTINGCURRENCY,
    TAXBOX11AMTINREPORTINGCURRENCY,
    TAXBOX12AMTINREPORTINGCURRENCY,
    TAXNUMBER1,
    TOTALAMOUNTINDISPLAYCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More