C_PurDocListInvoiceDetails

Invoice Details | view: CDOCLINVDTL | Extraction: Not supported | Component: Purchasing

Tables used: RBKP, RSEG, RSEG, RBKP, /CPD/D_PFP_PH, EKKO, EKPO, RBKP, RBCO, RBKPB, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, RBDRSEG, RSEG, EKBE, EKBEH, RBKP, ADRC, LFA1, CSKS, CSKT, T001W, PROJ, T163B, T024, T024E, LFA1, PRPS, PROJ

🔑 Keys (5)
💰 Amounts (2)
∑ Quantities (3)
📅 Dates (5)
☰ Categorical (2)
Other (31)
🔗 Relations (17)

Column Name	Description
PurchasingDocument	Document Number of an Invoice Document
InvoiceReferenceFiscalYear	Fiscal Year
PurchasingDocumentItem	Document Item in Invoice Document
AccountingDocumentItem	Document Item in Invoice Document
AccountingOrdinalNumber	Four Character Sequential Number for Coding Block	Show values

Column Name	Description
AmountInTranactionCurrency	Amount in document currency
💲 Currency Key (PurchaseOrderCurrency):
NetAmount	Net Order Value in PO Currency

Column Name	Description
Quantity	Quantity
GoodsMovementQuantity	null
PurchaseOrderItemQuantity	Purchase Order Quantity

Column Name	Description
DeliveryDate	null
DocumentDate	Document Date in Document
CreationDate	Day On Which Accounting Document Was Entered
InvoiceReceiptDate	Invoice Receipt Date
PostingDate	Posting Date in the Document

Column Name	Description
AccountingOrdinalNumber	Four Character Sequential Number for Coding Block	Show values
IsEndOfPurposeBlocked	Business Purpose Completed	Show values

Column Name	Description	Domain name
PurchaseOrderItem	Item Number of Purchase Order	EBELP
InvoicingStatus	null
SupplyingPlantName	Plant Name	TEXT30
Supplier	Supplier	LIFNR
SupplierName	Name of Supplier	TEXT80
SupplierAddressCity	City	TEXT40
PurchasingOrganisationName	Purchasing Organization Name	TEXT20
PlantName	Plant Name	TEXT30
PurchasingDocumentItemText	Short Text	TEXT40
PurchaseOrderItemCategory	null
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingDocumentCategory	null
ServicePerformer	null
ServicePerformerName	null
WorkItem	null
AccountAssignmentCategory	null
EnteredByUser	User Name	XUBNAME
InvoiceReceiptHeadertext	Document Header Text	TEXT25
InvoiceReference1	Invoice reference: Document number for invoice reference	AWREF
BusinessArea	Business Area	GSBER
erp_contract_id	Number of principal purchase agreement	EBELN
PaymentTerm	Terms of payment key	ZTERM
WBSElementInternalID	null
WBSElementExternalID	null
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales document item	POSNR
WorkPackageFullName	null
WBSDescription	Object Name	CHAR80
CostCenterName	Cost Center Name	TEXT20
ControllingArea	Controlling Area	CACCD
cnts	null

Master Data Relations	Join Conditions
Document Type Document Type Client	`C_PURDOCLISTINVOICEDETAILS.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_PURDOCLISTINVOICEDETAILS.MANDT == T003.MANDT`
Company Code Company Code Client	`C_PURDOCLISTINVOICEDETAILS.COMPANYCODE == T001.BUKRS` `C_PURDOCLISTINVOICEDETAILS.MANDT == T001.MANDT`
Currency Key Currency Key Currency Key Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASEORDERCURRENCY == TCURC.WAERS` `C_PURDOCLISTINVOICEDETAILS.COMPANYCODECURRENCY == TCURC.WAERS` `C_PURDOCLISTINVOICEDETAILS.MANDT == TCURC.MANDT`
Material Number Material Number Material Number Client	`C_PURDOCLISTINVOICEDETAILS.MATERIAL == MARA.MATNR` `C_PURDOCLISTINVOICEDETAILS.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURDOCLISTINVOICEDETAILS.MANDT == MARA.MANDT`
Material Number Material Number Material Number Client	`C_PURDOCLISTINVOICEDETAILS.MATERIAL == MARA.MATNR` `C_PURDOCLISTINVOICEDETAILS.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURDOCLISTINVOICEDETAILS.MANDT == MARA.MANDT`
Material Group Client Material Group	`C_PURDOCLISTINVOICEDETAILS.MANDT == T023.MANDT` `C_PURDOCLISTINVOICEDETAILS.MATERIALGROUP == T023.MATKL`
Branch Number ? Company Code Branch Number Client	`C_PURDOCLISTINVOICEDETAILS.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE` `C_PURDOCLISTINVOICEDETAILS.COMPANYCODE == J_1BBRANCH.BUKRS` `C_PURDOCLISTINVOICEDETAILS.MFGORDERSEQUENCEBRANCHOPEARAT == J_1BBRANCH.BRANCH` `C_PURDOCLISTINVOICEDETAILS.MANDT == J_1BBRANCH.MANDT`
Plant Plant Client	`C_PURDOCLISTINVOICEDETAILS.PLANT == T001W.WERKS` `C_PURDOCLISTINVOICEDETAILS.MANDT == T001W.MANDT`
Currency Key Currency Key Currency Key Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASEORDERCURRENCY == TCURC.WAERS` `C_PURDOCLISTINVOICEDETAILS.COMPANYCODECURRENCY == TCURC.WAERS` `C_PURDOCLISTINVOICEDETAILS.MANDT == TCURC.MANDT`
Different Invoicing Party Different Invoicing Party Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASEORDERVENDOR == LFA1.LIFNR` `C_PURDOCLISTINVOICEDETAILS.MANDT == LFA1.MANDT`
Purchase Order Type Purchase Order Type ? Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURDOCLISTINVOICEDETAILS.[column in domain "BSTYP"] == T161.BSTYP` `C_PURDOCLISTINVOICEDETAILS.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASINGGROUP == T024.EKGRP` `C_PURDOCLISTINVOICEDETAILS.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_PURDOCLISTINVOICEDETAILS.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURDOCLISTINVOICEDETAILS.MANDT == T024E.MANDT`
Base Unit of Measure Base Unit of Measure Client	`C_PURDOCLISTINVOICEDETAILS.QUANTITYUNIT == T006.MSEHI` `C_PURDOCLISTINVOICEDETAILS.MANDT == T006.MANDT`
Country key Client Country/Region Key	`C_PURDOCLISTINVOICEDETAILS.MANDT == T005.MANDT` `C_PURDOCLISTINVOICEDETAILS.SUPPLIERADDRESSCOUNTRY == T005.LAND1`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`C_PURDOCLISTINVOICEDETAILS.SUPPLYINGPLANT == T001W.WERKS` `C_PURDOCLISTINVOICEDETAILS.MANDT == T001W.MANDT`