P_QuantityContractAcctAssgmt

Quantity Contract Account Assignment | view: PQTYCONTRACCT | Extraction: Not supported | Component: Reporting
Tables used: EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKKO, EKPO, TKA01, T001W, T161, T162, T000, LFA1
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
AccountAssignmentNumber Sequential Number of Account Assignment
ReleaseOrder FK Purchasing Document Number
ReleaseOrderItem FK Item Number of Purchasing Document
Column Name Description
💲 Display Currency (DisplayCurrency):
ContractNetPriceAmount null
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ReleaseOrderItemOrderQuantity Release Order Quantity
TargetQuantity Quantity
AverageTargetQuantity Quantity
Column Name Description
ValidityEndDate End of Validity Period
ReleaseOrderDate Purchase Order Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
FormattedPurchaseContractItem Purchase Contract Item ID
CreatedByUser User of person who created a purchasing document USNAM
MultipleAcctAssgmtDistrPercent null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.COMPANYCODE == T001.BUKRS
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T001.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_QUANTITYCONTRACTACCTASSGMT.COSTCENTER == CSKS.KOSTL
  • P_QUANTITYCONTRACTACCTASSGMT.[column in domain "DATBI"] == CSKS.DATBI
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == CSKS.MANDT
Material Number
  • Material Number
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.MATERIAL == MARA.MATNR
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.MATERIALGROUP == T023.MATKL
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T006.MANDT
  • P_QUANTITYCONTRACTACCTASSGMT.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.PLANT == T001W.WERKS
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.PURCHASECONTRACTTYPE == T161.BSART
  • P_QUANTITYCONTRACTACCTASSGMT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.PURCHASINGGROUP == T024.EKGRP
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_QUANTITYCONTRACTACCTASSGMT.SUPPLIER == LFA1.LIFNR
  • P_QUANTITYCONTRACTACCTASSGMT.MANDT == LFA1.MANDT