_PURCHASINGINFORECORD

31 Fields

_PURCHASINGINFORECORD is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 1
IsDeleted IsDeleted 1
IsRegularSupplier IsRegularSupplier 1
LastChangeDateTime LastChangeDateTime 1
Manufacturer Manufacturer 1
Material Material 2
MaterialGroup MaterialGroup 1
NoDaysReminder1 NoDaysReminder1 1
NoDaysReminder2 NoDaysReminder2 1
NoDaysReminder3 NoDaysReminder3 1
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 1
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 1
PriorSupplier PriorSupplier 1
ProductPurchasePointsQty ProductPurchasePointsQty 1
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit 1
PurchasingInfoRecordDesc PurchasingInfoRecordDesc 3
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 2
ReturnAgreement ReturnAgreement 1
SuplrCertOriginClassfctnNumber SuplrCertOriginClassfctnNumber 1
Supplier Supplier 2
SupplierCertOriginCat SupplierCertOriginCat 1
SupplierCertOriginCountry SupplierCertOriginCountry 1
SupplierCertOriginNumber SupplierCertOriginNumber 1
SupplierCertOriginRegion SupplierCertOriginRegion 1
SupplierMaterialGroup SupplierMaterialGroup 1
SupplierMaterialNumber SupplierMaterialNumber 1
SupplierPhoneNumber SupplierPhoneNumber 1
SupplierRespSalesPersonName SupplierRespSalesPersonName 1
SupplierSubrange SupplierSubrange 1
SupplierSubrangeSortNumber SupplierSubrangeSortNumber 1
VarblPurOrdUnitIsActive VarblPurOrdUnitIsActive 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 _PURCHASINGINFORECORD (
    BASEUNIT,
    ISDELETED,
    ISREGULARSUPPLIER,
    LASTCHANGEDATETIME,
    MANUFACTURER,
    MATERIAL,
    MATERIALGROUP,
    NODAYSREMINDER1,
    NODAYSREMINDER2,
    NODAYSREMINDER3,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    PRIORSUPPLIER,
    PRODUCTPURCHASEPOINTSQTY,
    PRODUCTPURCHASEPOINTSQTYUNIT,
    PURCHASINGINFORECORDDESC,
    PURGDOCORDERQUANTITYUNIT,
    RETURNAGREEMENT,
    SUPLRCERTORIGINCLASSFCTNNUMBER,
    SUPPLIER,
    SUPPLIERCERTORIGINCAT,
    SUPPLIERCERTORIGINCOUNTRY,
    SUPPLIERCERTORIGINNUMBER,
    SUPPLIERCERTORIGINREGION,
    SUPPLIERMATERIALGROUP,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    SUPPLIERSUBRANGE,
    SUPPLIERSUBRANGESORTNUMBER,
    VARBLPURORDUNITISACTIVE
);

Learn More