_PURCHASECONTRACT

36 Fields

_PURCHASECONTRACT is an SAP database table in S/4HANA. It contains 36 fields.

Fields (36)

KeyField CDS FieldsUsed in Views
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_Supplier _Supplier 1
ActivePurchasingDocument ActivePurchasingDocument 4
bukrs CompanyCode 1
CompanyCode CompanyCode 7
CorrespncExternalReference CorrespncExternalReference 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser,PurchaseContractCreatedByUser 5
CreationDate CreationDate 6
DocumentCurrency DocumentCurrency 7
ekgrp PurchasingGroup 1
ekorg PurchasingOrganization 1
ExchangeRate ExchangeRate 1
ExchangeRateIsFixed ExchangeRateIsFixed 1
IncotermsVersion IncotermsVersion 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
LastChangeDateTime LastChangeDateTime 3
lifnr Supplier 1
PaymentTerms PaymentTerms 1
PurchaseContractTargetAmount OutlineAgreementTargetAmount,PurchaseContractTargetAmount 3
PurchaseContractType PurchaseContractType 9
PurchaseContractValidityStatus PurchaseContractValidityStatus 1
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentType PurchaseContractType 2
PurchasingDocVersionReasonCode PurchasingDocVersionReasonCode 1
PurchasingGroup PurchasingGroup 7
PurchasingOrganization PurchasingOrganization 6
ReleaseCode ReleaseCode 1
Supplier Supplier 10
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
ValidityEndDate PurContrValidityEndDate,ValidityEndDate 6
ValidityStartDate PurContrValidityStartDate,ValidityStartDate 5
waers DocumentCurrency 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 _PURCHASECONTRACT (
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    ACTIVEPURCHASINGDOCUMENT,
    BUKRS,
    COMPANYCODE,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    EKGRP,
    EKORG,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    INCOTERMSVERSION,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    LIFNR,
    PAYMENTTERMS,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASECONTRACTVALIDITYSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGDOCVERSIONREASONCODE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASECODE,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WAERS
);

Learn More