_PURCHASINGDOCUMENT

47 Fields

_PURCHASINGDOCUMENT is an SAP database table in S/4HANA. It contains 47 fields.

Fields (47)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 10
KEY CreatedByUser CreatedByUser,PurchaseOrderCreatedByUser 15
KEY DeliveryDocument SubsequentDocument 3
KEY DeliveryDocumentItem PrecedingDocumentItem,SubsequentDocumentItem 3
KEY PurchasingDocument PurchasingDocument,SchedulingAgreement 2
KEY ReferenceSDDocumentItem PrecedingDocumentItem 3
KEY Supplier PurchaseOrderSupplier,Supplier 19
_CompanyCode _CompanyCode 4
_DocumentCurrency _DocumentCurrency 5
_InvoicingParty _InvoicingParty 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 6
_PurchasingDocumentOrigin _PurchasingDocumentOrigin 1
_PurchasingDocumentType _PurchasingDocumentType 5
_PurchasingGroup _PurchasingGroup 8
_PurchasingOrganization _PurchasingOrganization 4
_Supplier _Supplier 7
CreationDate CreationDate,PurchasingDocumentCreationDate 11
DocumentCurrency DocumentCurrency,PurchasingDocumentCurrency 17
InvoicingParty InvoicingParty 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 6
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 1
PaymentTerms PaymentTerms 1
PurchasingCompletenessStatus PurchasingCompletenessStatus 1
PurchasingDocumentCategory PurchasingDocumentCategory 19
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentName PurchasingDocumentName 2
PurchasingDocumentOrderDate CreationDate,PurchaseOrderDate,PurchasingDocumentOrderDate 7
PurchasingDocumentOrigin PurchasingDocumentOrigin 7
PurchasingDocumentSubtype PurchasingDocumentSubtype 6
PurchasingDocumentType OrderType,PurchaseOrderType,PurchasingDocumentType 31
PurchasingGroup PurchasingGroup,PurOrdPurchasingGroup 28
PurchasingOrganization PurchasingOrganization,PurOrdPurchasingOrganization 23
PurchasingProcessingStatus PurchasingProcessingStatus 3
PurchasingReleaseStrategy PurchasingReleaseStrategy 1
PurgDocHdrInvcRtntnPct PurgDocHdrInvcRtntnPct 1
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 1
QuotationSubmissionDate QuotationSubmissionDate 1
ReleaseCode ReleaseCode 1
ReleaseIsNotCompleted ReleaseIsNotCompleted 2
RetentionType RetentionType 1
ScheduleAgreementHasReleaseDoc ScheduleAgreementHasReleaseDoc 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplyingPlant Plant,SupplyingPlant 3
TargetAmount TargetAmount 1
ValidityEndDate ValidityEndDate,ValidTo 4
ValidityStartDate ValidFrom,ValidityStartDate 4

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 _PURCHASINGDOCUMENT (
    COMPANYCODE,
    CREATEDBYUSER,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    PURCHASINGDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    SUPPLIER,
    _COMPANYCODE,
    _DOCUMENTCURRENCY,
    _INVOICINGPARTY,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTORIGIN,
    _PURCHASINGDOCUMENTTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PAYMENTTERMS,
    PURCHASINGCOMPLETENESSSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTORDERDATE,
    PURCHASINGDOCUMENTORIGIN,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURCHASINGRELEASESTRATEGY,
    PURGDOCHDRINVCRTNTNPCT,
    PURGRELEASESEQUENCESTATUS,
    QUOTATIONSUBMISSIONDATE,
    RELEASECODE,
    RELEASEISNOTCOMPLETED,
    RETENTIONTYPE,
    SCHEDULEAGREEMENTHASRELEASEDOC,
    SUPPLIERPHONENUMBER,
    SUPPLYINGPLANT,
    TARGETAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (COMPANYCODE, CREATEDBYUSER, DELIVERYDOCUMENT, DELIVERYDOCUMENTITEM, PURCHASINGDOCUMENT, REFERENCESDDOCUMENTITEM, SUPPLIER)
);

Learn More