ESH_N_RESERVATIONDOCUMENT

Anchor view -RESERVATIONDOCUMENT | view: ESH_L_RESVNDOC | TRAN | Extraction: Not supported | Component: VDM Reservations

Tables used: MATDOC, RKPF, RESB, MARA, T001, TKA02, T156, T156HT, T001W, MARA, MAKT, T001K, T001L, LFA1, LFB1, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, PRPS

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (4)
Other (14)
🔗 Relations (10)

Column Name	Description
RESERVATION	Number of reservation/dependent requirements

Column Name	Description

Column Name	Description

Column Name	Description
RESERVATIONDATE	Base date for reservation

Column Name	Description
DEBITCREDITCODE	Debit/Credit Indicator	Show values
RESERVATIONITEMISFINALLYISSUED	Final Issue for Reservation	Show values
RESERVATIONITMISMARKEDFORDELTN	Item is deleted	Show values
RESVNACCTASSGMTCATEGORY	Account assignment of reservation	Show values

Column Name	Description	Domain name
SUPPLIERAUTHORIZATIONGROUP	Authorization Group	BRGRU
SUPPLIERBYPLNTAUTHORIZATIONGRP	Authorization Group	BRGRU
GOODSMOVEMENTTYPENAME	Movement Type Text (Inventory Management)	BTEXT
GOODSRECIPIENTNAME	Goods Recipient	WEMPF
MATERIALDOCUMENT	Number of Material Document	BELNR
PLANTNAME	Plant Name	TEXT30
RECEIVINGPLANTNAME	Plant Name	TEXT30
PRODUCTNAME	Product Description	TEXT40
REQUIREMENTTYPE	Requirement type	BDART
SALESORDER	Sales Order Number	VBELN
STORAGELOCATIONNAME	Storage Location Name	TEXT16
RECEIVINGSTORAGELOCNAME	Storage Location Name	TEXT16
USERDESCRIPTION	User Description	SUIDTECHDESC
WBSELEMENT	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT

Master Data Relations	Join Conditions
Cost Center Base date for reservation Client ? Cost Center	`ESH_N_RESERVATIONDOCUMENT.RESERVATIONDATE == CSKS.DATBI` `ESH_N_RESERVATIONDOCUMENT.MANDT == CSKS.MANDT` `ESH_N_RESERVATIONDOCUMENT.[column in domain "KOKRS"] == CSKS.KOKRS` `ESH_N_RESERVATIONDOCUMENT.COSTCENTER == CSKS.KOSTL`
Movement type (inventory management) Movement type (inventory management) Client	`ESH_N_RESERVATIONDOCUMENT.GOODSMOVEMENTTYPE == T156.BWART` `ESH_N_RESERVATIONDOCUMENT.MANDT == T156.MANDT`
Receiving plant/issuing plant Receiving plant/issuing plant Client	`ESH_N_RESERVATIONDOCUMENT.ISSUINGORRECEIVINGPLANT == T001W.WERKS` `ESH_N_RESERVATIONDOCUMENT.MANDT == T001W.MANDT`
Receiving/issuing storage location Receiving/issuing storage location Receiving plant/issuing plant Client	`ESH_N_RESERVATIONDOCUMENT.ISSUINGORRECEIVINGSTORAGELOC == T001L.LGORT` `ESH_N_RESERVATIONDOCUMENT.ISSUINGORRECEIVINGPLANT == T001L.WERKS` `ESH_N_RESERVATIONDOCUMENT.MANDT == T001L.MANDT`
Network Number for Account Assignment Network Number for Account Assignment Client	`ESH_N_RESERVATIONDOCUMENT.NETWORKNUMBERFORACCTASSGMT == AUFK.AUFNR` `ESH_N_RESERVATIONDOCUMENT.MANDT == AUFK.MANDT`
Order Number Order Number Client	`ESH_N_RESERVATIONDOCUMENT.ORDERID == AUFK.AUFNR` `ESH_N_RESERVATIONDOCUMENT.MANDT == AUFK.MANDT`
Plant Client Plant	`ESH_N_RESERVATIONDOCUMENT.MANDT == T001W.MANDT` `ESH_N_RESERVATIONDOCUMENT.PLANT == T001W.WERKS`
Material Number Material Number Client	`ESH_N_RESERVATIONDOCUMENT.PRODUCT == MARA.MATNR` `ESH_N_RESERVATIONDOCUMENT.MANDT == MARA.MANDT`
Storage location Storage location Client Plant	`ESH_N_RESERVATIONDOCUMENT.STORAGELOCATION == T001L.LGORT` `ESH_N_RESERVATIONDOCUMENT.MANDT == T001L.MANDT` `ESH_N_RESERVATIONDOCUMENT.PLANT == T001L.WERKS`