C_PURCHASEREQUISITIONITMDTLS

CDS View
80 Fields 2 CDS Views

C_PURCHASEREQUISITIONITMDTLS is a CDS View in S/4HANA. It contains 80 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_Purchasereqitmdtlsext view from CONSUMPTION Purchase Requisition Data
C_PurOrdRefDocPurReqn view from CONSUMPTION Purchase Requisition Data For Purchase Order

Fields (80)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition PurchaseRequisition,PurchasingDocument 2
KEY PurchaseRequisitionItem PurchaseRequisitionItem 2
AccountAssignmentCategory AccountAssignmentCategory 1
AcctAssignmentCategoryName AcctAssignmentCategoryName 1
BaseUnit BaseUnit 2
CityName CityName 1
CompanyCode CompanyCode 1
ConsumptionPosting ConsumptionPosting 1
Country Country 1
CreatedByUser CreatedByUser 1
District District 1
DueDays DueDays 1
EmailAddress EmailAddress 1
FirstDeliveryDate FirstDeliveryDate 1
FixedSupplier FixedSupplier 2
FormattedPurRequisitionItem FormattedPurRequisitionItem 1
FullName FullName 1
HouseNumber HouseNumber 1
IsDeleted IsDeleted 1
IsOutline IsOutline 1
IsPurReqnCmplt IsPurReqnCmplt 1
Language Language 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Material ManufacturerMaterial,Material 2
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaterialGroup MaterialGroup 2
MaterialGroupName MaterialGroupName 1
MaterialName MaterialName 1
MaterialOrderUnit MaterialOrderUnit 1
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
NumberOfInfoRecords NumberOfInfoRecords 1
NumberOfRecords NumberOfRecords 1
OrderedQuantity OrderedQuantity 1
PerformancePeriodEndDate PerformancePeriodEndDate,ValidityEndDate 2
PerformancePeriodStartDate PerformancePeriodStartDate 2
PhoneNumber PhoneNumber 1
PhoneNumberExtension PhoneNumberExtension 1
Plant Plant 2
ProcessingStatus ProcessingStatus 1
ProcessingStatusName ProcessingStatusName 1
ProductType ProductType 1
PurchaseContract PurchaseContract 1
PurchaseContractItem PurchaseContractItem 1
PurchaseRequisitionItemText PurchaseRequisitionItemText,PurchasingDocumentItemText 2
PurchaseRequisitionPrice PurchaseRequisitionPrice 1
PurchaseRequisitionReleaseDate PurchaseRequisitionReleaseDate 1
PurchaseRequisitionType PurchaseRequisitionType 2
PurchasingCategory PurchasingCategory 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 1
PurchasingDocumentSubtype PurchasingDocumentSubtype 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingGroupPhoneNumber PurchasingGroupPhoneNumber 1
PurchasingInfoRecord PurchasingInfoRecord 1
PurchasingOrganization PurchasingOrganization 2
PurchasingOrganizationName PurchasingOrganizationName 1
PurgCatName PurgCatName 1
PurReqCreationDate PurReqCreationDate 1
PurReqnCmpltnsCat PurReqnCmpltnsCat 1
PurReqnHasAdvncdUsrInterface PurReqnHasAdvncdUsrInterface 1
PurReqnHasFllwOnDoc PurReqnHasFllwOnDoc 1
PurReqnItemCurrency Currency,PurReqnItemCurrency 2
PurReqnOrigin PurReqnOrigin 1
PurReqnPrice PurReqnPrice 1
PurReqnPriceQuantity PurchaseOrderNetPriceQuantity,PurReqnPriceQuantity 2
PurReqnReleaseStatus PurReqnReleaseStatus 1
PurReqnSourceOfSupplyCount PurReqnSourceOfSupplyCount 1
PurReqnSourceOfSupplyType PurReqnSourceOfSupplyType 1
ReleaseCode ReleaseCode 1
RequestedQuantity RequestedQuantity 1
RequisitionerName RequisitionerName 1
SourceOfSupplyIsAssigned SourceOfSupplyIsAssigned 1
Supplier FixedSupplierName,Supplier 2
SupplierName SupplierName 1
SupplierSearchText SupplierSearchText 1
SupplyingPlant SupplyingPlant 1
SupplyingPlantName SupplyingPlantName 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 C_PURCHASEREQUISITIONITMDTLS (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    ACCTASSIGNMENTCATEGORYNAME,
    BASEUNIT,
    CITYNAME,
    COMPANYCODE,
    CONSUMPTIONPOSTING,
    COUNTRY,
    CREATEDBYUSER,
    DISTRICT,
    DUEDAYS,
    EMAILADDRESS,
    FIRSTDELIVERYDATE,
    FIXEDSUPPLIER,
    FORMATTEDPURREQUISITIONITEM,
    FULLNAME,
    HOUSENUMBER,
    ISDELETED,
    ISOUTLINE,
    ISPURREQNCMPLT,
    LANGUAGE,
    MANUALDELIVERYADDRESSID,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALGROUPNAME,
    MATERIALNAME,
    MATERIALORDERUNIT,
    MATERIALPLANNEDDELIVERYDURN,
    NUMBEROFINFORECORDS,
    NUMBEROFRECORDS,
    ORDEREDQUANTITY,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    PLANT,
    PROCESSINGSTATUS,
    PROCESSINGSTATUSNAME,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEREQUISITIONITEMTEXT,
    PURCHASEREQUISITIONPRICE,
    PURCHASEREQUISITIONRELEASEDATE,
    PURCHASEREQUISITIONTYPE,
    PURCHASINGCATEGORY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTSUBTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGGROUPPHONENUMBER,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    PURGCATNAME,
    PURREQCREATIONDATE,
    PURREQNCMPLTNSCAT,
    PURREQNHASADVNCDUSRINTERFACE,
    PURREQNHASFLLWONDOC,
    PURREQNITEMCURRENCY,
    PURREQNORIGIN,
    PURREQNPRICE,
    PURREQNPRICEQUANTITY,
    PURREQNRELEASESTATUS,
    PURREQNSOURCEOFSUPPLYCOUNT,
    PURREQNSOURCEOFSUPPLYTYPE,
    RELEASECODE,
    REQUESTEDQUANTITY,
    REQUISITIONERNAME,
    SOURCEOFSUPPLYISASSIGNED,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERSEARCHTEXT,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More