P_PURGINFORECORDWITHORGDATA
P_PURGINFORECORDWITHORGDATA is a CDS View in S/4HANA. It contains 87 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PurgInfoRecordWWithDraft | view | from | TRANSACTIONAL | Purchasing Info Rec. with Org Plant Data |
Fields (87)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Plant | Plant,PlantForEdit | 1 |
| KEY | PurchasingInfoRecord | PurchasingInfoRecord,PurchasingInfoRecordForEdit | 1 |
| KEY | PurchasingInfoRecordCategory | PurchasingInfoRecordCategory,PurchasingInfoRecordCatForEdit | 1 |
| KEY | PurchasingOrganization | PurchasingOrganization,PurchasingOrganizationForEdit | 1 |
| AvailabilityEndDate | AvailabilityEndDate | 1 | |
| AvailabilityStartDate | AvailabilityStartDate | 1 | |
| BaseUnit | BaseUnit | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| Currency | Currency | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | 1 | |
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | 1 | |
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | 1 | |
| IsCashDiscountGranted | IsCashDiscountGranted | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsEvaluatedRcptSettlmtAllowed | IsEvaluatedRcptSettlmtAllowed | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| IsOrderAcknRqd | IsOrderAcknRqd | 1 | |
| IsPurOrderAllwdForInbDeliv | IsPurOrderAllwdForInbDeliv | 1 | |
| IsRegularSupplier | IsRegularSupplier | 1 | |
| IsRetMatlAuthznRqdBySupplier | IsRetMatlAuthznRqdBySupplier | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastReferencingPurchaseOrder | LastReferencingPurchaseOrder | 1 | |
| LastReferencingPurOrderItem | LastReferencingPurOrderItem | 1 | |
| Manufacturer | Manufacturer | 1 | |
| Material | Material | 1 | |
| MaterialConditionGroup | MaterialConditionGroup | 1 | |
| MaterialPlannedDeliveryDurn | MaterialPlannedDeliveryDurn | 1 | |
| MaterialPriceUnitQty | MaterialPriceUnitQty | 1 | |
| MaterialRoundingProfile | MaterialRoundingProfile | 1 | |
| MaterialStagingTime | MaterialStagingTime | 1 | |
| MaximumOrderQuantity | MaximumOrderQuantity | 1 | |
| MinimumPurchaseOrderQuantity | MinimumPurchaseOrderQuantity | 1 | |
| MinRemainingShelfLife | MinRemainingShelfLife | 1 | |
| NetPriceAmount | NetPriceAmount | 1 | |
| NoDaysReminder1 | NoDaysReminder1 | 1 | |
| NoDaysReminder2 | NoDaysReminder2 | 1 | |
| NoDaysReminder3 | NoDaysReminder3 | 1 | |
| OrderItemQtyToBaseQtyDnmntr | OrderItemQtyToBaseQtyDnmntr | 1 | |
| OrderItemQtyToBaseQtyNmrtr | OrderItemQtyToBaseQtyNmrtr | 1 | |
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | 1 | |
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | 1 | |
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | 1 | |
| PriceValidityEndDate | PriceValidityEndDate | 1 | |
| PricingDateControl | PricingDateControl | 1 | |
| PriorSupplier | PriorSupplier | 1 | |
| ProductPurchasePointsQty | ProductPurchasePointsQty | 1 | |
| ProductPurchasePointsQtyUnit | ProductPurchasePointsQtyUnit | 1 | |
| ProductUnitGroup | ProductUnitGroup | 1 | |
| PurchaseOrderPriceUnit | PurchaseOrderPriceUnit | 1 | |
| PurchasingDocumentDate | PurchasingDocumentDate | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecordDesc | PurchasingInfoRecordDesc | 1 | |
| PurgDocOrderQuantityUnit | PurgDocOrderQuantityUnit | 1 | |
| PurgInfoRecNonStockItmSortTerm | PurgInfoRecNonStockItmSortTerm | 1 | |
| ReturnAgreement | ReturnAgreement | 1 | |
| ShelfLifeExpirationDatePeriod | ShelfLifeExpirationDatePeriod | 1 | |
| ShippingInstruction | ShippingInstruction | 1 | |
| StandardPurchaseOrderQuantity | StandardPurchaseOrderQuantity | 1 | |
| SuplrCertOriginClassfctnNumber | SuplrCertOriginClassfctnNumber | 1 | |
| Supplier | Supplier | 1 | |
| SupplierCertOriginCat | SupplierCertOriginCat | 1 | |
| SupplierCertOriginCountry | SupplierCertOriginCountry | 1 | |
| SupplierCertOriginNumber | SupplierCertOriginNumber | 1 | |
| SupplierCertOriginRegion | SupplierCertOriginRegion | 1 | |
| SupplierCertValidityEndDate | SupplierCertValidityEndDate | 1 | |
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | 1 | |
| SupplierMaterialGroup | SupplierMaterialGroup | 1 | |
| SupplierMaterialNumber | SupplierMaterialNumber | 1 | |
| SupplierPhoneNumber | SupplierPhoneNumber | 1 | |
| SupplierQuotation | SupplierQuotation | 1 | |
| SupplierQuotationDate | SupplierQuotationDate | 1 | |
| SupplierRespSalesPersonName | SupplierRespSalesPersonName | 1 | |
| SupplierSubrange | SupplierSubrange | 1 | |
| SupplierSubrangeSortNumber | SupplierSubrangeSortNumber | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxCountry | TaxCountry | 1 | |
| TimeDependentTaxValidFromDate | TimeDependentTaxValidFromDate | 1 | |
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | 1 | |
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | 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 P_PURGINFORECORDWITHORGDATA (
PLANT,
PURCHASINGINFORECORD,
PURCHASINGINFORECORDCATEGORY,
PURCHASINGORGANIZATION,
AVAILABILITYENDDATE,
AVAILABILITYSTARTDATE,
BASEUNIT,
CREATEDBYUSER,
CREATIONDATE,
CURRENCY,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSSUPCHNDVTGLOCADDLUUID,
INCOTERMSSUPCHNLOC1ADDLUUID,
INCOTERMSSUPCHNLOC2ADDLUUID,
INCOTERMSTRANSFERLOCATION,
INCOTERMSVERSION,
INVOICEISGOODSRECEIPTBASED,
ISCASHDISCOUNTGRANTED,
ISDELETED,
ISEVALUATEDRCPTSETTLMTALLOWED,
ISMARKEDFORDELETION,
ISORDERACKNRQD,
ISPURORDERALLWDFORINBDELIV,
ISREGULARSUPPLIER,
ISRETMATLAUTHZNRQDBYSUPPLIER,
LASTCHANGEDATETIME,
LASTREFERENCINGPURCHASEORDER,
LASTREFERENCINGPURORDERITEM,
MANUFACTURER,
MATERIAL,
MATERIALCONDITIONGROUP,
MATERIALPLANNEDDELIVERYDURN,
MATERIALPRICEUNITQTY,
MATERIALROUNDINGPROFILE,
MATERIALSTAGINGTIME,
MAXIMUMORDERQUANTITY,
MINIMUMPURCHASEORDERQUANTITY,
MINREMAININGSHELFLIFE,
NETPRICEAMOUNT,
NODAYSREMINDER1,
NODAYSREMINDER2,
NODAYSREMINDER3,
ORDERITEMQTYTOBASEQTYDNMNTR,
ORDERITEMQTYTOBASEQTYNMRTR,
ORDERPRICEUNITTOORDERUNITNMRTR,
ORDPRICEUNITTOORDERUNITDNMNTR,
OVERDELIVTOLRTDLMTRATIOINPCT,
PRICEVALIDITYENDDATE,
PRICINGDATECONTROL,
PRIORSUPPLIER,
PRODUCTPURCHASEPOINTSQTY,
PRODUCTPURCHASEPOINTSQTYUNIT,
PRODUCTUNITGROUP,
PURCHASEORDERPRICEUNIT,
PURCHASINGDOCUMENTDATE,
PURCHASINGGROUP,
PURCHASINGINFORECORDDESC,
PURGDOCORDERQUANTITYUNIT,
PURGINFORECNONSTOCKITMSORTTERM,
RETURNAGREEMENT,
SHELFLIFEEXPIRATIONDATEPERIOD,
SHIPPINGINSTRUCTION,
STANDARDPURCHASEORDERQUANTITY,
SUPLRCERTORIGINCLASSFCTNNUMBER,
SUPPLIER,
SUPPLIERCERTORIGINCAT,
SUPPLIERCERTORIGINCOUNTRY,
SUPPLIERCERTORIGINNUMBER,
SUPPLIERCERTORIGINREGION,
SUPPLIERCERTVALIDITYENDDATE,
SUPPLIERCONFIRMATIONCONTROLKEY,
SUPPLIERMATERIALGROUP,
SUPPLIERMATERIALNUMBER,
SUPPLIERPHONENUMBER,
SUPPLIERQUOTATION,
SUPPLIERQUOTATIONDATE,
SUPPLIERRESPSALESPERSONNAME,
SUPPLIERSUBRANGE,
SUPPLIERSUBRANGESORTNUMBER,
TAXCODE,
TAXCOUNTRY,
TIMEDEPENDENTTAXVALIDFROMDATE,
UNDERDELIVTOLRTDLMTRATIOINPCT,
UNLIMITEDOVERDELIVERYISALLOWED,
VARBLPURORDUNITISACTIVE,
PRIMARY KEY (PLANT, PURCHASINGINFORECORD, PURCHASINGINFORECORDCATEGORY, PURCHASINGORGANIZATION)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA