C_POWthNonCmplncPaytTrmQry

PO having Non compliant Payment Terms | view: CMMPOPAYTMQUERY | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
PurOrdNetAmountInDisplayCrcy Purchase Order Net Amount
Column Name Description
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
CalendarYear Calendar Year NUM4
NrOfPOInNonCompliantPaytTrms Number of PO with non compliant payment terms
NumberOfPurchaseOrders Number of Purchase Orders
MinNrOfPOWithNonCompPaytTrm Number of PO with non compliant payment terms
NrOfPOWithNonCompliantPaytTrm Number of PO with non compliant payment terms
POWithNonCompliantPaytTrmPct Percentage of PO with non compliant payment terms
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T001.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.COMPANYCODE == T001.BUKRS
Material Group
  • Client
  • Material Group
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T023.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T001W.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T024.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T024E.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.PURCHASINGORGANIZATION == T024E.EKORG
Region (State, Province, County)
  • Supplier Country/Region
  • Client
  • Region (State, Province, County)
  • C_POWTHNONCMPLNCPAYTTRMQRY.SUPPLIERCOUNTRY == T005S.LAND1
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T005S.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.REGION == T005S.BLAND
Supplier
  • Client
  • Supplier
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == LFA1.MANDT
  • C_POWTHNONCMPLNCPAYTTRMQRY.SUPPLIER == LFA1.LIFNR
Supplier Country/Region
  • Supplier Country/Region
  • Client
  • C_POWTHNONCMPLNCPAYTTRMQRY.SUPPLIERCOUNTRY == T005.LAND1
  • C_POWTHNONCMPLNCPAYTTRMQRY.MANDT == T005.MANDT