PAYMENTRECEIPT

PAYMENTRECEIPT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
AccountingDocumentType AccountingDocumentType 1
AccountingDocumentTypeName AccountingDocumentTypeName 1
CompanyCode CompanyCode 1
Country Country 1
CreatedByUser CreatedByUser 1
CreateReferencePaytRcptUUID CreateReferencePaytRcptUUID 1
Customer Customer 1
DraftLastChangedDateTime DraftLastChangedDateTime 1
FiscalYear FiscalYear 1
LastChangedByUser LastChangedByUser 1
OfficialReceiptNumber OfficialReceiptNumber 1
PaymentRcptVoidedByUserName PaymentRcptVoidedByUserName 1
PaymentReceiptCreatedDate PaymentReceiptCreatedDate 1
PaymentReceiptID PaymentReceiptID 1
PaymentReceiptIssueDate PaymentReceiptIssueDate 1
PaymentReceiptStatus PaymentReceiptStatus 1
PaymentReceiptType PaymentReceiptType 2
PaymentReceiptVoidedDate PaymentReceiptVoidedDate 1
Supplier Supplier 1
SupplierFullName SupplierFullName 1
VoidReferencePaytRcptUUID VoidReferencePaytRcptUUID 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 PAYMENTRECEIPT (
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    COMPANYCODE,
    COUNTRY,
    CREATEDBYUSER,
    CREATEREFERENCEPAYTRCPTUUID,
    CUSTOMER,
    DRAFTLASTCHANGEDDATETIME,
    FISCALYEAR,
    LASTCHANGEDBYUSER,
    OFFICIALRECEIPTNUMBER,
    PAYMENTRCPTVOIDEDBYUSERNAME,
    PAYMENTRECEIPTCREATEDDATE,
    PAYMENTRECEIPTID,
    PAYMENTRECEIPTISSUEDATE,
    PAYMENTRECEIPTSTATUS,
    PAYMENTRECEIPTTYPE,
    PAYMENTRECEIPTVOIDEDDATE,
    SUPPLIER,
    SUPPLIERFULLNAME,
    VOIDREFERENCEPAYTRCPTUUID
);