SAP Table JVTLIEFBAR
IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets
JVTLIEFBAR (IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JVTLIEFBAR to other SAP tables.
JVTLIEFBAR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| LIEFBARNR | Sequence number for delivery/home delivery viability set | LIEFBARNR | CHAR | 9 | 0 | |||||||||||||||||||
| GUELTIGAB | Valid-From Date | GUELTIGVON | DATS | 8 | 0 | |||||||||||||||||||
| GUELTIGBIS | Valid-To Date | GUELTIGBIS | DATS | 8 | 0 | |||||||||||||||||||
| GBISBEEND | Valid to Date After Closed Delivery Via. Sets are Released | GBISBEEND | DATS | 8 | 0 | |||||||||||||||||||
| XAUFTRREL | IS-M: Use of delivery viability set possible in order | XAUFTRREL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| LOESCH_KZ | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| DRUERZART | Publication Type | DRUERZART | TJD17 | CHAR | 1 | 0 | ||||||||||||||||||
| DRERZ | Publication | DRERZ | JDTDRER | CHAR | 8 | 0 | ||||||||||||||||||
| PVA | Edition | PVA | JDTPVA | CHAR | 8 | 0 | ||||||||||||||||||
| BEZUGSTYP | Mix Type | BEZUGSTYP_JE_PVA | JDTBEZTYP | CHAR | 2 | 0 | ||||||||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||||||||
| LIEFERART | Delivery Type | LIEFERART | TJV01 | CHAR | 2 | 0 | ||||||||||||||||||
| GEOEIN | Number of Geographical Unit | GEOEIN | JSTGEOEINH | CHAR | 10 | 0 | ||||||||||||||||||
| BEZIRK | Carrier Route | BEZIRK | JVTBEZIRK | CHAR | 10 | 0 | ||||||||||||||||||
| ABHOLSTELL | IS-M/SD: Customer Pickup Point | ABHOLSTELL | JGTGPNR | CHAR | 10 | 0 | ||||||||||||||||||
| BEZRUNDE | IS-M: Delivery Round | BEZRUNDE | JVTRUNDE | CHAR | 10 | 0 | ||||||||||||||||||
| DRUCKEREI | Plant | JWERK | T001W | CHAR | 4 | 0 | ||||||||||||||||||
| AENDNRBIS | Change Number for To-Date of Structural Change | AENDNRBIS | JSTAENDER | CHAR | 9 | 0 | ||||||||||||||||||
| AENDNRBISD | Date of Change Number Used to Change To-Date | AENDNRBISD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| AENDNRAB | Change Number for From-Date of Structure Change | AENDNRAB | JSTAENDER | CHAR | 9 | 0 | ||||||||||||||||||
| AENDNRABD | Date of Change Number Used to Change From-Date | AENDNRABD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| AENDNRINIT | Initiating Change Number | AENDNRINIT | JSTAENDER | CHAR | 9 | 0 | ||||||||||||||||||
| AENDLFDNRI | Sequence Number of Initiating Change Number | AENDLFDNRI | NUMC | 4 | 0 | |||||||||||||||||||
| AENDNRAKT | Change Number in Process | AENDNRAKT | JSTAENDER | CHAR | 9 | 0 | ||||||||||||||||||
| AENDLFDNRA | Sequence Number of Currently Operative Change Number | AENDLFDNRA | NUMC | 4 | 0 | |||||||||||||||||||
| XAENDER | Structure information being changed on other change number | XAENDER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XSTRUAKTIV | Structure information inactive | XSTRUAKTIV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| FCCODE | Function Control Code for Structure Changes | FCCODE | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||
| DBCODEFREI | DB Code for Structural Changes | DBCODE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||||||||||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||||||||||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||||||||||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||||||||||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||||||||||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||||||||||||||
JVTLIEFBAR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JVTLIEFBAR | ABHOLSTELL | JVTLIEFBAR | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
| JVTLIEFBAR | ABHOLSTELL | JVTLIEFBAR | ABHOLSTELL | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
| JVTLIEFBAR | AENDNRAB | JVTLIEFBAR | AENDNRAB | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | AENDNR |
| JVTLIEFBAR | AENDNRAB | SYST | MANDT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | MANDT |
| JVTLIEFBAR | AENDNRAKT | SYST | MANDT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | MANDT |
| JVTLIEFBAR | AENDNRAKT | JVTLIEFBAR | AENDNRAKT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | AENDNR |
| JVTLIEFBAR | AENDNRBIS | SYST | MANDT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | MANDT |
| JVTLIEFBAR | AENDNRBIS | JVTLIEFBAR | AENDNRBIS | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | AENDNR |
| JVTLIEFBAR | AENDNRINIT | JVTLIEFBAR | AENDNRINIT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | AENDNR |
| JVTLIEFBAR | AENDNRINIT | SYST | MANDT | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | MANDT |
| JVTLIEFBAR | BEZIRK | JVTLIEFBAR | MANDT | JVTBEZIRK | IS-M: Carrier Route (Generalization) | MANDT |
| JVTLIEFBAR | BEZIRK | JVTLIEFBAR | BEZIRK | JVTBEZIRK | IS-M: Carrier Route (Generalization) | BEZIRK |
| JVTLIEFBAR | BEZRUNDE | JVTLIEFBAR | MANDT | JVTRUNDE | IS-M/SD: Round (Delivery Round) | MANDT |
| JVTLIEFBAR | BEZRUNDE | JVTLIEFBAR | BEZRUNDE | JVTRUNDE | IS-M/SD: Round (Delivery Round) | RUNDE |
| JVTLIEFBAR | BEZUGSTYP | JVTLIEFBAR | PVA | JDTBEZTYP | IS-M: Mix Types (per Edition) | PVATRA |
| JVTLIEFBAR | BEZUGSTYP | JVTLIEFBAR | BEZUGSTYP | JDTBEZTYP | IS-M: Mix Types (per Edition) | BEZTYP |
| JVTLIEFBAR | BEZUGSTYP | JVTLIEFBAR | MANDT | JDTBEZTYP | IS-M: Mix Types (per Edition) | MANDT |
| JVTLIEFBAR | BEZUGSTYP | JVTLIEFBAR | DRERZ | JDTBEZTYP | IS-M: Mix Types (per Edition) | DRERTR |
| JVTLIEFBAR | DRERZ | JVTLIEFBAR | MANDT | JDTDRER | IS-M/SD: Publications | MANDT |
| JVTLIEFBAR | DRERZ | JVTLIEFBAR | DRERZ | JDTDRER | IS-M/SD: Publications | DRERZ |
| JVTLIEFBAR | DRUCKEREI | JVTLIEFBAR | MANDT | T001W | Plants/Branches | MANDT |
| JVTLIEFBAR | DRUCKEREI | JVTLIEFBAR | DRUCKEREI | T001W | Plants/Branches | WERKS |
| JVTLIEFBAR | DRUERZART | JVTLIEFBAR | MANDT | TJD17 | IS-M/SD: Publication Types | MANDT |
| JVTLIEFBAR | DRUERZART | JVTLIEFBAR | DRUERZART | TJD17 | IS-M/SD: Publication Types | DEART |
| JVTLIEFBAR | GEOEIN | JVTLIEFBAR | MANDT | JSTGEOEINH | IS-M/SD: Geographical Unit | MANDT |
| JVTLIEFBAR | GEOEIN | JVTLIEFBAR | GEOEIN | JSTGEOEINH | IS-M/SD: Geographical Unit | GEOEIN |
| JVTLIEFBAR | LIEFERART | JVTLIEFBAR | MANDT | TJV01 | Delivery type for issue | MANDT |
| JVTLIEFBAR | LIEFERART | JVTLIEFBAR | LIEFERART | TJV01 | Delivery type for issue | LIEFERART |
| JVTLIEFBAR | MANDT | JVTLIEFBAR | MANDT | T000 | Clients | MANDT |
| JVTLIEFBAR | PVA | JVTLIEFBAR | DRERZ | JDTPVA | IS-M/SD: Editions | DRERZ |
| JVTLIEFBAR | PVA | JVTLIEFBAR | PVA | JDTPVA | IS-M/SD: Editions | PVA |
| JVTLIEFBAR | PVA | JVTLIEFBAR | MANDT | JDTPVA | IS-M/SD: Editions | MANDT |
| JVTLIEFBAR | VKORG | JVTLIEFBAR | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| JVTLIEFBAR | VKORG | JVTLIEFBAR | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| JVTLIEFBAR | VTWEG | JVTLIEFBAR | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| JVTLIEFBAR | VTWEG | JVTLIEFBAR | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
